VIEW: APPS.AP_SOB_INFO_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'