VIEW: APPS.CSI_MASS_EDIT_ENTRIES_VL

Source

View Text - Preformatted

SELECT MEB.ENTRY_ID, MET.NAME, MEB.TXN_LINE_ID, MEB.STATUS_CODE, MEB.SCHEDULE_DATE, MEB.START_DATE, MEB.END_DATE, MEB.CREATED_BY, MEB.CREATION_DATE, MEB.LAST_UPDATED_BY, MEB.LAST_UPDATE_DATE, MEB.LAST_UPDATE_LOGIN, MEB.OBJECT_VERSION_NUMBER, MEB.BATCH_TYPE, MEB.REQUEST_ID, MEB.PROGRAM_APPLICATION_ID, MEB.PROGRAM_ID, MEB.PROGRAM_UPDATE_DATE, MET.DESCRIPTION, MEB.SYSTEM_CASCADE FROM CSI_MASS_EDIT_ENTRIES_B MEB, CSI_MASS_EDIT_ENTRIES_TL MET WHERE MEB.ENTRY_ID = MET.ENTRY_ID AND MET.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT MEB.ENTRY_ID
, MET.NAME
, MEB.TXN_LINE_ID
, MEB.STATUS_CODE
, MEB.SCHEDULE_DATE
, MEB.START_DATE
, MEB.END_DATE
, MEB.CREATED_BY
, MEB.CREATION_DATE
, MEB.LAST_UPDATED_BY
, MEB.LAST_UPDATE_DATE
, MEB.LAST_UPDATE_LOGIN
, MEB.OBJECT_VERSION_NUMBER
, MEB.BATCH_TYPE
, MEB.REQUEST_ID
, MEB.PROGRAM_APPLICATION_ID
, MEB.PROGRAM_ID
, MEB.PROGRAM_UPDATE_DATE
, MET.DESCRIPTION
, MEB.SYSTEM_CASCADE
FROM CSI_MASS_EDIT_ENTRIES_B MEB
, CSI_MASS_EDIT_ENTRIES_TL MET
WHERE MEB.ENTRY_ID = MET.ENTRY_ID
AND MET.LANGUAGE = USERENV('LANG')