select
a.LEGAL_ENTITY_NAME,
c.NAME OU,
b.ORGANIZATION_CODE inv_org
from
GMF_LEGAL_ENTITIES a,
org_organization_definitions b,
hr_operating_units c
where
a.LEGAL_ENTITY_ID=b.LEGAL_ENTITY
and
b.OPERATING_UNIT=c.ORGANIZATION_ID;
a.LEGAL_ENTITY_NAME,
c.NAME OU,
b.ORGANIZATION_CODE inv_org
from
GMF_LEGAL_ENTITIES a,
org_organization_definitions b,
hr_operating_units c
where
a.LEGAL_ENTITY_ID=b.LEGAL_ENTITY
and
b.OPERATING_UNIT=c.ORGANIZATION_ID;
ReplyDeleteRegards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.