View: GL_ELIMINATION_HISTORY_V

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

View Text

SELECT H.ROWID ROW_ID
, H.ELIMINATION_RUN_ID ELIMINATION_RUN_ID
, H.REQUEST_ID REQUEST_ID
, S.ELIMINATION_SET_ID ELIMINATION_SET_ID
, DECODE(H.LEDGER_ID
, NULL
, S.LEDGER_ID
, H.LEDGER_ID) LEDGER_ID
, H.STATUS_CODE STATUS_CODE
, H.PERIOD_NAME PERIOD_NAME
, H.CREATION_DATE CREATION_DATE
, H.CREATED_BY CREATED_BY
, H.LAST_UPDATE_DATE LAST_UPDATE_DATE
, H.LAST_UPDATED_BY LAST_UPDATED_BY
, H.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, H.JE_BATCH_ID JE_BATCH_ID
, H.CONTEXT CONTEXT
, H.ATTRIBUTE1 ATTRIBUTE1
, H.ATTRIBUTE2 ATTRIBUTE2
, H.ATTRIBUTE3 ATTRIBUTE3
, H.ATTRIBUTE4 ATTRIBUTE4
, H.ATTRIBUTE5 ATTRIBUTE5
, H.ATTRIBUTE6 ATTRIBUTE6
, H.ATTRIBUTE7 ATTRIBUTE7
, H.ATTRIBUTE8 ATTRIBUTE8
, H.ATTRIBUTE9 ATTRIBUTE9
, H.ATTRIBUTE10 ATTRIBUTE10
, H.ATTRIBUTE11 ATTRIBUTE11
, H.ATTRIBUTE12 ATTRIBUTE12
, H.ATTRIBUTE13 ATTRIBUTE13
, H.ATTRIBUTE14 ATTRIBUTE14
, H.ATTRIBUTE15 ATTRIBUTE15
, S.NAME ELIMINATION_SET_NAME
, S.ELIMINATION_COMPANY ELIMINATION_COMPANY
, S.DESCRIPTION DESCRIPTION
, S.LAST_EXECUTED_PERIOD LAST_EXECUTED_PERIOD
, S.TRACK_ELIMINATION_STATUS_FLAG TRACK_ELIMINATION_STATUS_FLAG
, JB.ROWID JB_ROW_ID
, JB.CONTROL_TOTAL JB_CONTROL_TOTAL
, JB.RUNNING_TOTAL_DR JB_RUNNING_TOTAL_DR
, JB.RUNNING_TOTAL_CR JB_RUNNING_TOTAL_CR
, JB.NAME JB_NAME
, JB.CHART_OF_ACCOUNTS_ID JB_CHART_OF_ACCOUNTS_ID
, JB.STATUS JB_STATUS
, JB.STATUS_VERIFIED JB_STATUS_VERIFIED
, JB.ACTUAL_FLAG JB_ACTUAL_FLAG
, JB.BUDGETARY_CONTROL_STATUS JB_BUDGETARY_CONTROL_STATUS
, JB.DEFAULT_PERIOD_NAME JB_DEFAULT_PERIOD_NAME
, JB.POSTING_RUN_ID JB_POSTING_RUN_ID
, JB.REQUEST_ID JB_REQUEST_ID
, JB.APPROVAL_STATUS_CODE JB_APPROVAL_STATUS_CODE
, JB.LAST_UPDATE_DATE JB_LAST_UPDATE_DATE
, JB.LAST_UPDATED_BY JB_LAST_UPDATED_BY
, JB.LAST_UPDATE_LOGIN JB_LAST_UPDATE_LOGIN
, DECODE(S.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_ELIMINATION_SET_V'
, 'GL_DAS_ELIMINATION_SET'
, TO_CHAR(S.ELIMINATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(S.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_ELIMINATION_SET_U'
, 'GL_DAS_ELIMINATION_SET'
, TO_CHAR(S.ELIMINATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
FROM GL_JE_BATCHES JB
, GL_ELIMINATION_HISTORY H
, GL_ELIMINATION_SETS S
WHERE S.ELIMINATION_SET_ID = H.ELIMINATION_SET_ID(+)
AND H.PERIOD_NAME(+) = GL_CONS_WRK_PKG.GET_PERIOD AND(H.ELIMINATION_RUN_ID >= ( SELECT MAX(H2.ELIMINATION_RUN_ID)
FROM GL_ELIMINATION_HISTORY H2
WHERE H2.ELIMINATION_SET_ID = H.ELIMINATION_SET_ID
AND H2.LEDGER_ID = H.LEDGER_ID
AND H2.PERIOD_NAME = H.PERIOD_NAME ) OR H.ELIMINATION_RUN_ID IS NULL )
AND JB.JE_BATCH_ID(+) = H.JE_BATCH_ID
AND S.TRACK_ELIMINATION_STATUS_FLAG = 'Y'

Columns