VIEW: APPS.IGI_CBR_GL_SEC_LEDGER_V

Source

View Text - Preformatted

SELECT rs.PRIMARY_LEDGER_ID , lg.LEDGER_ID , lg.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, das.access_set_id FROM GL_LEDGER_RELATIONSHIPS rs , GL_LEDGERS lg , GL_ACCESS_SET_LEDGERS_V das 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 in ('SUBLEDGER','JOURNAL') AND rs.application_id = 101 and rs.automatic_post_flag = 'Y' and das.access_privilege_code = 'F' and das.object_type_code = 'L' and das.ledger_id = lg.ledger_id

View Text - HTML Formatted

SELECT RS.PRIMARY_LEDGER_ID
, LG.LEDGER_ID
, LG.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
, DAS.ACCESS_SET_ID
FROM GL_LEDGER_RELATIONSHIPS RS
, GL_LEDGERS LG
, GL_ACCESS_SET_LEDGERS_V DAS
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 IN ('SUBLEDGER'
, 'JOURNAL')
AND RS.APPLICATION_ID = 101
AND RS.AUTOMATIC_POST_FLAG = 'Y'
AND DAS.ACCESS_PRIVILEGE_CODE = 'F'
AND DAS.OBJECT_TYPE_CODE = 'L'
AND DAS.LEDGER_ID = LG.LEDGER_ID