View: AP_SOB_INFO_V

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

View Text

SELECT 200 APPLICATION_ID
, SOB.NAME
, SOB.SET_OF_BOOKS_ID
, 'PRIMARY' SOB_TYPE
, DECODE( SOB.SLA_LEDGER_CASH_BASIS_FLAG
, 'Y'
, 'CASH'
, 'ACCRUAL') ACCOUNTING_METHOD
, SP.BASE_CURRENCY_CODE
, DECODE(SOB.SET_OF_BOOKS_ID
, SP.SET_OF_BOOKS_ID
, NVL(FSP.PURCH_ENCUMBRANCE_FLAG
, 'N')
, 'N') ENCUMBRANCE_FLAG
FROM GL_SETS_OF_BOOKS SOB
, AP_SYSTEM_PARAMETERS SP
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE SOB.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID
AND SP.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID UNION ALL SELECT 200 APPLICATION_ID
, MRC.LEDGER_NAME
, MRC.LEDGER_ID
, 'REPORTING' SOB_TYPE
, DECODE( SOB.SLA_LEDGER_CASH_BASIS_FLAG
, 'Y'
, 'CASH'
, 'ACCRUAL') ACCOUNTING_METHOD
, SP.BASE_CURRENCY_CODE
, 'N' ENCUMBRANCE_FLAG
FROM GL_SETS_OF_BOOKS SOB
, AP_SYSTEM_PARAMETERS SP
, GL_ALC_LEDGER_RSHIPS_V MRC
WHERE MRC.SOURCE_LEDGER_ID = SP.SET_OF_BOOKS_ID
AND MRC.LEDGER_ID = SOB.SET_OF_BOOKS_ID
AND MRC.RELATIONSHIP_TYPE_CODE = 'SUBLEDGER'
AND MRC.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND MRC.APPLICATION_ID = 200
AND MRC.ORG_ID = SP.ORG_ID UNION ALL SELECT 200 APPLICATION_ID
, SECONDARY.LEDGER_NAME
, SECONDARY.LEDGER_ID
, 'SECONDARY' SOB_TYPE
, DECODE( SECONDARY.SLA_ACCOUNTING_METHOD_CODE
, 'STANDARD_ACCRUAL'
, 'ACCRUAL'
, 'STANDARD_CASH'
, 'CASH'
, 'ACCRUAL') ACCOUNTING_METHOD
, SP.BASE_CURRENCY_CODE
, 'N' ENCUMBRANCE_FLAG
FROM AP_SYSTEM_PARAMETERS SP
, GL_SECONDARY_LEDGER_RSHIPS_V SECONDARY
WHERE SECONDARY.PRIMARY_LEDGER_ID = SP.SET_OF_BOOKS_ID
AND SECONDARY.RELATIONSHIP_TYPE_CODE = 'SUBLEDGER'
AND SECONDARY.RELATIONSHIP_ENABLED_FLAG = 'Y'

Columns