View: CST_PAC_LEGAL_ENTITIES_V

Product:	BOM - Bills of Material
Description:	Shows denormalized legal entity information for legal entities belonging to Periodic
Implementation/DBA Data:	APPS.CST_PAC_LEGAL_ENTITIES_V

View Text

SELECT DISTINCT CCG.LEGAL_ENTITY LEGAL_ENTITY
, XFI.NAME NAME
, GLL.PRIMARY_LEDGER_ID SET_OF_BOOKS_ID
, XFI.LE_EFFECTIVE_FROM DATE_FROM
, XFI.EFFECTIVE_TO DATE_TO FROM CST_COST_GROUPS CCG
, XLE_FIRSTPARTY_INFORMATION_V XFI
, GL_LEDGER_LE_V GLL
WHERE CCG.COST_GROUP_TYPE =2
AND XFI.LEGAL_ENTITY_ID = CCG.LEGAL_ENTITY
AND GLL.LEGAL_ENTITY_ID = XFI.LEGAL_ENTITY_ID
AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'

Columns