eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CST_PAC_LEGAL_ENTITIES_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'