View: AP_SRS_ACCTG_CURR_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_SRS_ACCTG_CURR_V

View Text

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

Columns