[Home] [Help]
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
Name |
LEGAL_ENTITY |
NAME |
SET_OF_BOOKS_ID |
DATE_FROM |
DATE_TO |