Product: | EGO - Advanced Product Catalog |
---|---|
Description: | This view contains information about batches |
Implementation/DBA Data: | APPS.EGO_IMPORT_BATCHES_VL |
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