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.

[Home] [Help]

View: GL_SECONDARY_LEDGER_RSHIPS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_SECONDARY_LEDGER_RSHIPS_V

View Text

SELECT RS.PRIMARY_LEDGER_ID
, LG.LEDGER_ID
, LG.NAME
, LG.SHORT_NAME
, LG.CHART_OF_ACCOUNTS_ID
, LG.CURRENCY_CODE
, LG.PERIOD_SET_NAME
, LG.ACCOUNTED_PERIOD_TYPE
, RS.SL_COA_MAPPING_ID
, LG.SLA_ACCOUNTING_METHOD_CODE
, LG.SLA_ACCOUNTING_METHOD_TYPE
, RS.RELATIONSHIP_TYPE_CODE
, RS.RELATIONSHIP_ENABLED_FLAG
FROM GL_LEDGER_RELATIONSHIPS RS
, GL_LEDGERS LG
WHERE LG.LEDGER_CATEGORY_CODE = 'SECONDARY'
AND NVL(LG.COMPLETE_FLAG
, 'Y') = 'Y'
AND RS.TARGET_LEDGER_ID = LG.LEDGER_ID
AND RS.TARGET_LEDGER_CATEGORY_CODE = LG.LEDGER_CATEGORY_CODE
AND RS.RELATIONSHIP_TYPE_CODE <> 'NONE'
AND RS.APPLICATION_ID = 101

Columns

Name
PRIMARY_LEDGER_ID
LEDGER_ID
LEDGER_NAME
LEDGER_SHORT_NAME
CHART_OF_ACCOUNTS_ID
CURRENCY_CODE
PERIOD_SET_NAME
ACCOUNTED_PERIOD_TYPE
SL_COA_MAPPING_ID
SLA_ACCOUNTING_METHOD_CODE
SLA_ACCOUNTING_METHOD_TYPE
RELATIONSHIP_TYPE_CODE
RELATIONSHIP_ENABLED_FLAG