[Home] [Help]
View: AP_SRS_SOB_NAME_V
View Text
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
Columns
Name |
VALUE_FIELD |
MEANING_FIELD |
ID_FIELD |
ACCTG_MTH_FIELD |