Product: | GL - General Ledger |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.GL_BC_OPTION_DETAILS_V |
SELECT D.ROWID ROW_ID
, D.BC_OPTION_ID BC_OPTION_ID
, D.LAST_UPDATE_DATE LAST_UPDATE_DATE
, D.LAST_UPDATED_BY LAST_UPDATED_BY
, D.JE_SOURCE_NAME JE_SOURCE_NAME
, D.JE_CATEGORY_NAME JE_CATEGORY_NAME
, D.FUNDS_CHECK_LEVEL_CODE FUNDS_CHECK_LEVEL_CODE
, D.CREATION_DATE CREATION_DATE
, D.CREATED_BY CREATED_BY
, D.OVERRIDE_AMOUNT OVERRIDE_AMOUNT
, D.TOLERANCE_PERCENTAGE TOLERANCE_PERCENTAGE
, D.TOLERANCE_AMOUNT TOLERANCE_AMOUNT
, D.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, D.CONTEXT CONTEXT
, D.ATTRIBUTE1 ATTRIBUTE1
, D.ATTRIBUTE2 ATTRIBUTE2
, D.ATTRIBUTE3 ATTRIBUTE3
, D.ATTRIBUTE4 ATTRIBUTE4
, D.ATTRIBUTE5 ATTRIBUTE5
, D.ATTRIBUTE6 ATTRIBUTE6
, D.ATTRIBUTE7 ATTRIBUTE7
, D.ATTRIBUTE8 ATTRIBUTE8
, D.ATTRIBUTE9 ATTRIBUTE9
, D.ATTRIBUTE10 ATTRIBUTE10
, D.ATTRIBUTE11 ATTRIBUTE11
, D.ATTRIBUTE12 ATTRIBUTE12
, D.ATTRIBUTE13 ATTRIBUTE13
, D.ATTRIBUTE14 ATTRIBUTE14
, D.ATTRIBUTE15 ATTRIBUTE15
, /**/ S.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, /**/ C.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, /**/ L.MEANING USER_FUNDS_CHECK_LEVEL
FROM GL_LOOKUPS L
, GL_JE_CATEGORIES C
, GL_JE_SOURCES S
, GL_BC_OPTION_DETAILS D
WHERE S.JE_SOURCE_NAME = D.JE_SOURCE_NAME /**/
AND C.JE_CATEGORY_NAME = D.JE_CATEGORY_NAME /**/
AND L.LOOKUP_TYPE = 'FUNDS_CHECK_LEVEL'
AND L.LOOKUP_CODE = D.FUNDS_CHECK_LEVEL_CODE