View: GL_JE_BATCHES_POST_V

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

View Text

SELECT JB.ROWID ROW_ID
, JB.JE_BATCH_ID JE_BATCH_ID
, JB.NAME NAME
, JB.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, JB.PERIOD_SET_NAME PERIOD_SET_NAME
, JB.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, JB.ACTUAL_FLAG ACTUAL_FLAG
, JB.STATUS STATUS
, JB.STATUS_VERIFIED STATUS_VERIFIED
, JB.DEFAULT_PERIOD_NAME DEFAULT_PERIOD_NAME
, JB.DEFAULT_EFFECTIVE_DATE DEFAULT_EFFECTIVE_DATE
, JB.BUDGETARY_CONTROL_STATUS BUDGETARY_CONTROL_STATUS
, JB.APPROVAL_STATUS_CODE APPROVAL_STATUS_CODE
, JB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JB.LAST_UPDATED_BY LAST_UPDATED_BY
, JB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JB.CONTROL_TOTAL CONTROL_TOTAL
, JB.RUNNING_TOTAL_DR RUNNING_TOTAL_DR
, JB.RUNNING_TOTAL_CR RUNNING_TOTAL_CR
, JB.POSTING_RUN_ID POSTING_RUN_ID
, JB.REQUEST_ID REQUEST_ID
, PER.PERIOD_YEAR PERIOD_YEAR
, PER.PERIOD_NUM PERIOD_NUM
FROM GL_JE_BATCHES JB
, GL_PERIODS PER
WHERE ( JB.STATUS < 'P' OR JB.STATUS > 'P')
AND PER.PERIOD_SET_NAME = JB.PERIOD_SET_NAME
AND PER.PERIOD_TYPE = JB.ACCOUNTED_PERIOD_TYPE
AND PER.PERIOD_NAME = JB.DEFAULT_PERIOD_NAME
AND NOT EXISTS ( SELECT NVL ( AL.ACCESS_PRIVILEGE_CODE
, 'X')
FROM GL_JE_HEADERS JH
, GL_ACCESS_SET_LEDGERS AL
WHERE JH.JE_BATCH_ID = JB.JE_BATCH_ID
AND NVL ( JH.DISPLAY_ALC_JOURNAL_FLAG
, 'Y') = 'Y'
AND AL.LEDGER_ID ( + ) = JH.LEDGER_ID
AND AL.ACCESS_SET_ID ( + ) = GL_JE_BATCHES_POST_PKG.GET_ACCESS_SET_ID
AND NVL ( AL.ACCESS_PRIVILEGE_CODE
, 'R') = 'R'
AND TRUNC ( JB.DEFAULT_EFFECTIVE_DATE ) BETWEEN TRUNC ( NVL ( AL.START_DATE
, JB.DEFAULT_EFFECTIVE_DATE ) )
AND TRUNC ( NVL ( AL.END_DATE
, JB.DEFAULT_EFFECTIVE_DATE ) ) )

Columns