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.XLA_ALT_CURR_LEDGERS_V

Source

View Text - Preformatted


SELECT rep.ledger_id, /* alternate currency ledger id */ rep.currency_code, /* user key */ rep.name, rep.short_name, glr.primary_ledger_id, /* primary or secondary ledger id */ glr.sla_ledger_id, glr.relationship_enabled_flag enabled_flag FROM gl_ledgers rep, gl_ledger_relationships glr WHERE glr.target_ledger_id = rep.ledger_id AND rep.object_type_code = 'L' /* only ledgers (not ledger sets) */ AND rep.le_ledger_type_code = 'L' /* only legal ledgers */ AND rep.ledger_category_code = 'ALC' AND glr.application_id = 101 and glr.relationship_type_code = 'SUBLEDGER'

View Text - HTML Formatted

SELECT REP.LEDGER_ID
, /* ALTERNATE CURRENCY LEDGER ID */ REP.CURRENCY_CODE
, /* USER KEY */ REP.NAME
, REP.SHORT_NAME
, GLR.PRIMARY_LEDGER_ID
, /* PRIMARY OR SECONDARY LEDGER ID */ GLR.SLA_LEDGER_ID
, GLR.RELATIONSHIP_ENABLED_FLAG ENABLED_FLAG
FROM GL_LEDGERS REP
, GL_LEDGER_RELATIONSHIPS GLR
WHERE GLR.TARGET_LEDGER_ID = REP.LEDGER_ID
AND REP.OBJECT_TYPE_CODE = 'L' /* ONLY LEDGERS (NOT LEDGER SETS) */
AND REP.LE_LEDGER_TYPE_CODE = 'L' /* ONLY LEGAL LEDGERS */
AND REP.LEDGER_CATEGORY_CODE = 'ALC'
AND GLR.APPLICATION_ID = 101
AND GLR.RELATIONSHIP_TYPE_CODE = 'SUBLEDGER'