SELECT DISTINCT MRC.currency_code ,MRC.ledger_name SOB_NAME ,MRC.ledger_id SOB_ID ,MRC.source_ledger_id P_SOB_ID ,MRC.org_id REPORTING_ORG_ID FROM GL_ALC_LEDGER_RSHIPS_V MRC WHERE mrc.RELATIONSHIP_TYPE_CODE = 'SUBLEDGER' and mrc.RELATIONSHIP_ENABLED_FLAG = 'Y' and mrc.application_id = 200 UNION SELECT GSOB.CURRENCY_CODE CURR_CODE ,GSOB.NAME SOB_NAME ,GSOB.SET_OF_BOOKS_ID SOB_ID ,GSOB.SET_OF_BOOKS_ID P_SOB_ID ,-1 FROM GL_SETS_OF_BOOKS GSOB
SELECT DISTINCT MRC.CURRENCY_CODE
, MRC.LEDGER_NAME SOB_NAME
, MRC.LEDGER_ID SOB_ID
, MRC.SOURCE_LEDGER_ID P_SOB_ID
, MRC.ORG_ID REPORTING_ORG_ID
FROM GL_ALC_LEDGER_RSHIPS_V MRC
WHERE MRC.RELATIONSHIP_TYPE_CODE = 'SUBLEDGER'
AND MRC.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND MRC.APPLICATION_ID = 200 UNION SELECT GSOB.CURRENCY_CODE CURR_CODE
, GSOB.NAME SOB_NAME
, GSOB.SET_OF_BOOKS_ID SOB_ID
, GSOB.SET_OF_BOOKS_ID P_SOB_ID
, -1
FROM GL_SETS_OF_BOOKS GSOB
|
|
|