In R12 use below query to fetch Legal entity details for Operating Unit
Select a.organization_id,
a.organization_code,
a.organization_name,
Select a.organization_id,
a.organization_code,
a.organization_name,
a.operating_unit,
b.name OU,
a.set_of_books_id,
d.name LEDGER,
a.legal_entity,
a.legal_entity,
c.name LE_NAME
From apps. ORG_ORGANIZATION_DEFINITIONS a,
apps. HR_OPERATING_UNITS b,
apps. xle_entity_profiles c,
apps. gl_ledgers d
Where a.operating_unit=b.organizatio n_id
and C.LEGAL_ENTITY_ID=a.LEGAL_ENTI TY
AND d.ledger_id=a.set_of_books_id;
From apps. ORG_ORGANIZATION_DEFINITIONS a,
apps. HR_OPERATING_UNITS b,
apps. xle_entity_profiles c,
apps. gl_ledgers d
Where a.operating_unit=b.organizatio
and C.LEGAL_ENTITY_ID=a.LEGAL_ENTI
AND d.ledger_id=a.set_of_books_id;
2 comments:
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
Post a Comment