VIEW: APPS.GL_JE_BATCHES_POST_V

Source

View Text - Preformatted

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 ) ) )

View Text - HTML Formatted

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 ) ) )