View: GL_AUTOMATIC_POSTING_OPTIONS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_AUTOMATIC_POSTING_OPTIONS_V

View Text

SELECT APO.ROWID ROW_ID
, APO.AUTOPOST_SET_ID AUTOPOST_SET_ID
, APO.ACTUAL_FLAG ACTUAL_FLAG
, APO.PERIOD_NAME PERIOD_NAME
, APO.LEDGER_ID LEDGER_ID
, DECODE(APO.LEDGER_ID
, -1234567890
, LK.MEANING
, LED.NAME) LEDGER_NAME
, APO.JE_SOURCE_NAME JE_SOURCE_NAME
, DECODE(APO.JE_SOURCE_NAME
, 'ALL'
, LK.MEANING
, SRC.USER_JE_SOURCE_NAME) USER_JE_SOURCE_NAME
, APO.JE_CATEGORY_NAME JE_CATEGORY_NAME
, DECODE(APO.JE_CATEGORY_NAME
, 'ALL'
, LK.MEANING
, CAT.USER_JE_CATEGORY_NAME) USER_JE_CATEGORY_NAME
, APO.POSTING_PRIORITY POSTING_PRIORITY
, APO.CREATION_DATE CREATION_DATE
, APO.CREATED_BY CREATED_BY
, APO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APO.LAST_UPDATED_BY LAST_UPDATED_BY
, APO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, APO.CONTEXT CONTEXT
, APO.ATTRIBUTE1 ATTRIBUTE1
, APO.ATTRIBUTE2 ATTRIBUTE2
, APO.ATTRIBUTE3 ATTRIBUTE3
, APO.ATTRIBUTE4 ATTRIBUTE4
, APO.ATTRIBUTE5 ATTRIBUTE5
, APO.ATTRIBUTE6 ATTRIBUTE6
, APO.ATTRIBUTE7 ATTRIBUTE7
, APO.ATTRIBUTE8 ATTRIBUTE8
, APO.ATTRIBUTE9 ATTRIBUTE9
, APO.ATTRIBUTE10 ATTRIBUTE10
, APO.ATTRIBUTE11 ATTRIBUTE11
, APO.ATTRIBUTE12 ATTRIBUTE12
, APO.ATTRIBUTE13 ATTRIBUTE13
, APO.ATTRIBUTE14 ATTRIBUTE14
, APO.ATTRIBUTE15 ATTRIBUTE15
FROM GL_LOOKUPS LK
, GL_LEDGERS LED
, GL_JE_SOURCES SRC
, GL_JE_CATEGORIES CAT
, GL_AUTOMATIC_POSTING_SETS SETS
, GL_AUTOMATIC_POSTING_OPTIONS APO
WHERE SETS.AUTOPOST_SET_ID = APO.AUTOPOST_SET_ID
AND LED.LEDGER_ID(+) = APO.LEDGER_ID
AND SRC.JE_SOURCE_NAME(+) = APO.JE_SOURCE_NAME
AND CAT.JE_CATEGORY_NAME(+) = APO.JE_CATEGORY_NAME
AND LK.LOOKUP_TYPE = 'LITERAL'
AND LK.LOOKUP_CODE(+) = 'ALL'

Columns