eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GL_ELIMINATION_HISTORY_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'