VIEW: APPS.AP_SRS_SOB_NAME_V

Source

View Text - Preformatted

SELECT SOB.NAME VALUE_FIELD, DECODE(NVL(SP.SECONDARY_SET_OF_BOOKS_ID, -1), -1, '', DECODE(SOB.SET_OF_BOOKS_ID, SP.SET_OF_BOOKS_ID, 'Primary', 'Secondary')) MEANING_FIELD, SOB.NAME ID_FIELD, DECODE(NVL(SP.SECONDARY_SET_OF_BOOKS_ID, -1), -1, '', DECODE(SOB.SET_OF_BOOKS_ID, SP.SET_OF_BOOKS_ID, NVL(SP.ACCOUNTING_METHOD_OPTION, 'Accrual'), SP.SECONDARY_ACCOUNTING_METHOD)) ACCTG_MTH_FIELD FROM GL_SETS_OF_BOOKS SOB, AP_SYSTEM_PARAMETERS SP WHERE SOB.SET_OF_BOOKS_ID IN (SP.SET_OF_BOOKS_ID, NVL(SP.SECONDARY_SET_OF_BOOKS_ID, -1)) UNION SELECT L.MEANING VALUE_FIELD, '' MEANING_FIELD, 'Both' ID_FIELD, '' ACCTG_MTH_FIELD FROM AP_SYSTEM_PARAMETERS SP, FND_LOOKUPS L WHERE L.LOOKUP_TYPE = 'BOTH_ALL_NONE' AND L.LOOKUP_CODE = 'B' AND NVL(SP.SECONDARY_SET_OF_BOOKS_ID, -1) <> -1

View Text - HTML Formatted

SELECT SOB.NAME VALUE_FIELD
, DECODE(NVL(SP.SECONDARY_SET_OF_BOOKS_ID
, -1)
, -1
, ''
, DECODE(SOB.SET_OF_BOOKS_ID
, SP.SET_OF_BOOKS_ID
, 'PRIMARY'
, 'SECONDARY')) MEANING_FIELD
, SOB.NAME ID_FIELD
, DECODE(NVL(SP.SECONDARY_SET_OF_BOOKS_ID
, -1)
, -1
, ''
, DECODE(SOB.SET_OF_BOOKS_ID
, SP.SET_OF_BOOKS_ID
, NVL(SP.ACCOUNTING_METHOD_OPTION
, 'ACCRUAL')
, SP.SECONDARY_ACCOUNTING_METHOD)) ACCTG_MTH_FIELD
FROM GL_SETS_OF_BOOKS SOB
, AP_SYSTEM_PARAMETERS SP
WHERE SOB.SET_OF_BOOKS_ID IN (SP.SET_OF_BOOKS_ID
, NVL(SP.SECONDARY_SET_OF_BOOKS_ID
, -1)) UNION SELECT L.MEANING VALUE_FIELD
, '' MEANING_FIELD
, 'BOTH' ID_FIELD
, '' ACCTG_MTH_FIELD
FROM AP_SYSTEM_PARAMETERS SP
, FND_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'BOTH_ALL_NONE'
AND L.LOOKUP_CODE = 'B'
AND NVL(SP.SECONDARY_SET_OF_BOOKS_ID
, -1) <> -1