VIEW: APPS.GLFV_ENCUMB_JOURNAL_BATCHES

Source

View Text - Preformatted

SELECT ENCUMB_JOURNAL_BATCH1.JE_BATCH_ID, ENCUMB_JOURNAL_BATCH1.NAME, TO_NUMBER(NULL), 'Obsolete', '_LA:ENCUMB_JOURNAL_BATCH1.STATUS:GL_LOOKUPS:BATCH_STATUS:DESCRIPTION', ENCUMB_JOURNAL_BATCH1.DEFAULT_PERIOD_NAME, ENCUMB_JOURNAL_BATCH1.POSTED_DATE, ENCUMB_JOURNAL_BATCH1.DATE_CREATED, ENCUMB_JOURNAL_BATCH1.DESCRIPTION, '_LA:ENCUMB_JOURNAL_BATCH1.BUDGETARY_CONTROL_STATUS:GL_LOOKUPS:JE_BATCH_BC_STATUS:MEANING', '_LA:ENCUMB_JOURNAL_BATCH1.APPROVAL_STATUS_CODE:GL_LOOKUPS:JE_BATCH_APPROVAL_STATUS:MEANING', ENCUMB_JOURNAL_BATCH1.CONTROL_TOTAL, ENCUMB_JOURNAL_BATCH1.RUNNING_TOTAL_DR, ENCUMB_JOURNAL_BATCH1.RUNNING_TOTAL_CR, TO_NUMBER(NULL), 'Obsolete', ENCUMB_JOURNAL_BATCH1.APPROVER_EMPLOYEE_ID, (select employee_name from gl_hr_employees_current_v where employee_id = ENCUMB_JOURNAL_BATCH1.APPROVER_EMPLOYEE_ID), ENCUMB_JOURNAL_BATCH1.POSTED_BY, (select user_name from fnd_user where user_id = ENCUMB_JOURNAL_BATCH1.POSTED_BY), '_DF:SQLGL:GL_JE_BATCHES:ENCUMB_JOURNAL_BATCH1' FROM GL_JE_BATCHES ENCUMB_JOURNAL_BATCH1 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 = ENCUMB_JOURNAL_BATCH1.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))) AND ENCUMB_JOURNAL_BATCH1.ACTUAL_FLAG = 'E' WITH READ ONLY

View Text - HTML Formatted

SELECT ENCUMB_JOURNAL_BATCH1.JE_BATCH_ID
, ENCUMB_JOURNAL_BATCH1.NAME
, TO_NUMBER(NULL)
, 'OBSOLETE'
, '_LA:ENCUMB_JOURNAL_BATCH1.STATUS:GL_LOOKUPS:BATCH_STATUS:DESCRIPTION'
, ENCUMB_JOURNAL_BATCH1.DEFAULT_PERIOD_NAME
, ENCUMB_JOURNAL_BATCH1.POSTED_DATE
, ENCUMB_JOURNAL_BATCH1.DATE_CREATED
, ENCUMB_JOURNAL_BATCH1.DESCRIPTION
, '_LA:ENCUMB_JOURNAL_BATCH1.BUDGETARY_CONTROL_STATUS:GL_LOOKUPS:JE_BATCH_BC_STATUS:MEANING'
, '_LA:ENCUMB_JOURNAL_BATCH1.APPROVAL_STATUS_CODE:GL_LOOKUPS:JE_BATCH_APPROVAL_STATUS:MEANING'
, ENCUMB_JOURNAL_BATCH1.CONTROL_TOTAL
, ENCUMB_JOURNAL_BATCH1.RUNNING_TOTAL_DR
, ENCUMB_JOURNAL_BATCH1.RUNNING_TOTAL_CR
, TO_NUMBER(NULL)
, 'OBSOLETE'
, ENCUMB_JOURNAL_BATCH1.APPROVER_EMPLOYEE_ID
, (SELECT EMPLOYEE_NAME
FROM GL_HR_EMPLOYEES_CURRENT_V
WHERE EMPLOYEE_ID = ENCUMB_JOURNAL_BATCH1.APPROVER_EMPLOYEE_ID)
, ENCUMB_JOURNAL_BATCH1.POSTED_BY
, (SELECT USER_NAME
FROM FND_USER
WHERE USER_ID = ENCUMB_JOURNAL_BATCH1.POSTED_BY)
, '_DF:SQLGL:GL_JE_BATCHES:ENCUMB_JOURNAL_BATCH1'
FROM GL_JE_BATCHES ENCUMB_JOURNAL_BATCH1
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 = ENCUMB_JOURNAL_BATCH1.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)))
AND ENCUMB_JOURNAL_BATCH1.ACTUAL_FLAG = 'E' WITH READ ONLY