View: GLBV_JOURNAL_BATCHES

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

View Text

SELECT JOURNAL_BATCH.JE_BATCH_ID
, JOURNAL_BATCH.NAME
, TO_NUMBER(NULL)
, '_LA:JOURNAL_BATCH.STATUS:GL_LOOKUPS:BATCH_STATUS:DESCRIPTION'
, '_LA:JOURNAL_BATCH.ACTUAL_FLAG:GL_LOOKUPS:BATCH_TYPE:DESCRIPTION'
, JOURNAL_BATCH.DEFAULT_PERIOD_NAME
, JOURNAL_BATCH.POSTED_DATE
, JOURNAL_BATCH.DATE_CREATED
, JOURNAL_BATCH.DESCRIPTION
, '_LA:JOURNAL_BATCH.AVERAGE_JOURNAL_FLAG:GL_LOOKUPS:AB_JOURNAL_TYPE:MEANING'
, '_LA:JOURNAL_BATCH.BUDGETARY_CONTROL_STATUS:GL_LOOKUPS:JE_BATCH_BC_STATUS:MEANING'
, '_LA:JOURNAL_BATCH.APPROVAL_STATUS_CODE:GL_LOOKUPS:JE_BATCH_APPROVAL_STATUS:MEANING'
, JOURNAL_BATCH.CONTROL_TOTAL
, JOURNAL_BATCH.RUNNING_TOTAL_DR
, JOURNAL_BATCH.RUNNING_TOTAL_CR
, JOURNAL_BATCH.RUNNING_TOTAL_ACCOUNTED_DR
, JOURNAL_BATCH.RUNNING_TOTAL_ACCOUNTED_CR
, TO_NUMBER(NULL)
, JOURNAL_BATCH.APPROVER_EMPLOYEE_ID
, (SELECT EMPLOYEE_NAME
FROM GL_HR_EMPLOYEES_CURRENT_V
WHERE EMPLOYEE_ID = JOURNAL_BATCH.APPROVER_EMPLOYEE_ID)
, JOURNAL_BATCH.POSTED_BY
, (SELECT USER_NAME
FROM FND_USER
WHERE USER_ID = JOURNAL_BATCH.POSTED_BY)
FROM GL_JE_BATCHES JOURNAL_BATCH
WHERE EXISTS (SELECT 'ACCESS TO JOURNAL'
FROM GL_JE_HEADERS JEH
, GL_ACCESS_SETS ACC
, GL_ACCESS_SET_LEDGERS LGR
WHERE JEH.JE_BATCH_ID = JOURNAL_BATCH.JE_BATCH_ID
AND ACC.ACCESS_SET_ID = GL_SECURITY_PKG.LOGIN_ACCESS_ID
AND LGR.ACCESS_SET_ID = ACC.ACCESS_SET_ID
AND LGR.LEDGER_ID = JEH.LEDGER_ID
AND (ACC.SECURITY_SEGMENT_CODE = 'F' OR LGR.ACCESS_PRIVILEGE_CODE = 'F' OR EXISTS (SELECT 'ACCESS TO BSV/MSV'
FROM GL_JE_SEGMENT_VALUES SV
, GL_ACCESS_SET_ASSIGNMENTS ASA
WHERE SV.JE_HEADER_ID = JEH.JE_HEADER_ID
AND SV.SEGMENT_TYPE_CODE = ACC.SECURITY_SEGMENT_CODE
AND ASA.ACCESS_SET_ID = ACC.ACCESS_SET_ID
AND ASA.LEDGER_ID = JEH.LEDGER_ID
AND ASA.SEGMENT_VALUE = SV.SEGMENT_VALUE))) WITH READ ONLY

Columns