[Home] [Help] [Dependency Information]
Object Name: | EGO_IMPORT_BATCHES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_IMPORT_BATCHES_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View EGO_IMPORT_BATCHES_VL provides all information (including translatable information) related to import batches. Each row of this view provides the name, description, status, type, id, asignee, organization, and source system id (among other pieces of information) for a given batch. The unique identifier for each row is BATCH_ID.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | Id of the batch. | |
ORGANIZATION_ID | NUMBER | Yes | Master Organization Id for this batch | |
SOURCE_SYSTEM_ID | NUMBER | Yes | Id of Source System | |
BATCH_TYPE | VARCHAR2 | (30) | Yes | Type of the record, e.g. Item or Structure |
ASSIGNEE | NUMBER | Assignee of the batch | ||
BATCH_STATUS | VARCHAR2 | (1) | Yes | Status of the batch |
NAME | VARCHAR2 | (80) | Yes | Name of the batch |
DESCRIPTION | VARCHAR2 | (240) | Description of this batch | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Version number for concurrency control purpose. | |
LAST_MATCH_REQUEST_ID | NUMBER | This column holds the latest concurrent request id of matching concurrent program ran for this batch. | ||
LAST_IMPORT_REQUEST_ID | NUMBER | This column holds the latest concurrent request id of import concurrent program ran for this batch. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, ORGANIZATION_ID
, SOURCE_SYSTEM_ID
, BATCH_TYPE
, ASSIGNEE
, BATCH_STATUS
, NAME
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, LAST_MATCH_REQUEST_ID
, LAST_IMPORT_REQUEST_ID
FROM APPS.EGO_IMPORT_BATCHES_VL;
|
|
|