VIEW: APPS.EGO_IMPORT_BATCHES_VL

Source

View Text - Preformatted

SELECT B.BATCH_ID BATCH_ID ,B.ORGANIZATION_ID ORGANIZATION_ID ,B.SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID ,B.BATCH_TYPE BATCH_TYPE ,B.ASSIGNEE ASSIGNEE ,B.BATCH_STATUS BATCH_STATUS ,TL.NAME NAME ,TL.DESCRIPTION DESCRIPTION ,B.CREATED_BY CREATED_BY ,B.CREATION_DATE CREATION_DATE ,B.LAST_UPDATED_BY LAST_UPDATED_BY ,B.LAST_UPDATE_DATE LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,B.LAST_MATCH_REQUEST_ID LAST_MATCH_REQUEST_ID ,B.LAST_IMPORT_REQUEST_ID LAST_IMPORT_REQUEST_ID FROM EGO_IMPORT_BATCHES_B B, EGO_IMPORT_BATCHES_TL TL WHERE B.BATCH_ID = TL.BATCH_ID AND TL.LANGUAGE = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT B.BATCH_ID BATCH_ID
, B.ORGANIZATION_ID ORGANIZATION_ID
, B.SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID
, B.BATCH_TYPE BATCH_TYPE
, B.ASSIGNEE ASSIGNEE
, B.BATCH_STATUS BATCH_STATUS
, TL.NAME NAME
, TL.DESCRIPTION DESCRIPTION
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, B.LAST_MATCH_REQUEST_ID LAST_MATCH_REQUEST_ID
, B.LAST_IMPORT_REQUEST_ID LAST_IMPORT_REQUEST_ID
FROM EGO_IMPORT_BATCHES_B B
, EGO_IMPORT_BATCHES_TL TL
WHERE B.BATCH_ID = TL.BATCH_ID
AND TL.LANGUAGE = USERENV('LANG') WITH READ ONLY