[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EGO_IMPORT_BATCH_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  EGO.EGO_IMPORT_BATCH_DETAILS_V
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
View EGO_IMPORT_BATCH_DETAILS_V provides detailed information (including translatable information) about import batches. Each row of this view provides the name, description, status, type, id, asignee, organization, source system id, and detailed information such as matching rules, change order options, and structure 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 | Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B | |
| SOURCE_SYSTEM_ID | NUMBER | Yes | Id of the source system. | |
| SOURCE_SYSTEM_NAME | VARCHAR2 | (80) | Name of the source system | |
| BATCH_TYPE | VARCHAR2 | (30) | Yes | Type of the batch (Structure, Item etc) |
| BATCH_TYPE_MEANING | VARCHAR2 | (240) | Meaning of the type | |
| ASSIGNEE | NUMBER | Identifier of Person this batch is assigned to. | ||
| ASSIGNEE_NAME | VARCHAR2 | (4000) | name of the person this batch assigned to | |
| BATCH_STATUS | VARCHAR2 | (1) | Yes | status of the batch (A, ..etc) |
| BATCH_STATUS_MEANING | VARCHAR2 | (4000) | Meaning of the batch status (Active, .. etc) | |
| BATCH_NAME | VARCHAR2 | (80) | Yes | Name of the batch |
| BATCH_DESCRIPTION | VARCHAR2 | (240) | Description of the batch | |
| 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. | ||
| CREATED_BY | NUMBER | Yes | Standard WHO column | |
| CREATOR_NAME | VARCHAR2 | (4000) | Name of the creator of batch | |
| 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 | ||
| DEF_MATCH_RULE_CUST_APP_ID | NUMBER | Default Match Rule Information | ||
| DEF_MATCH_RULE_CUST_CODE | VARCHAR2 | (30) | Default Match Rule Information | |
| DEF_MATCH_RULE_RN_APP_ID | NUMBER | Default Match Rule Information | ||
| DEF_MATCH_RULE_RN_CODE | VARCHAR2 | (30) | Default Match Rule Information | |
| DEFAULT_MATCH_RULE_MEANING | VARCHAR2 | (80) | Default Match Rule Information | |
| OPTION_SET_ID | NUMBER | Yes | Id of the option set. | |
| APPLY_DEF_MATCH_RULE_ALL | VARCHAR2 | (1) | Apply the default match rule to all records from this source system. | |
| APPLY_DEFMATCHRULEALL_MEANING | VARCHAR2 | (4000) | Apply the default match rule to all records from this source system. | |
| MATCH_ON_DATA_LOAD | VARCHAR2 | (1) | Automatically match on data load. | |
| MATCH_ON_DATA_LOAD_MEANING | VARCHAR2 | (4000) | Automatically match on data load. | |
| CONFIRM_SINGLE_MATCH | VARCHAR2 | (1) | Automatically confirm single matches. | |
| CONFIRM_SINGLE_MATCH_MEANING | VARCHAR2 | (4000) | Automatically confirm single matches. | |
| IMPORT_ON_DATA_LOAD | VARCHAR2 | (1) | Automatically import on data load | |
| IMPORT_ON_DATA_LOAD_MEANING | VARCHAR2 | (4000) | Automatically import on data load | |
| REVISION_IMPORT_POLICY | VARCHAR2 | (30) | Revision import policy, e.g. L for update latest, or N for create new. | |
| REVISION_IMPORT_POLICY_MEANING | VARCHAR2 | (4000) | Meaning of Revision policy | |
| IMPORT_XREF_ONLY | VARCHAR2 | (1) | Import cross reference only. | |
| IMPORT_XREF_ONLY_MEANING | VARCHAR2 | (4000) | Meaning of the cross reference only | |
| STRUCTURE_TYPE_ID | NUMBER | Id of the structure type.(FK of BOM_STRUCTURE_TYPES_B. STRUCTURE_TYPE_ID) | ||
| STRUCTURE_TYPE_DISPLAY_NAME | VARCHAR2 | (80) | Display name of the structure type | |
| STRUCTURE_NAME | VARCHAR2 | (10) | Internal code of the structure name. | |
| STRUCTURE_DISPLAY_NAME | VARCHAR2 | (4000) | Display name of the structure name. | |
| STRUCTURE_EFFECTIVITY_TYPE | NUMBER | Effectivity control type of the structure. | ||
| STRUCTURE_EFF_TYPE_MEANING | VARCHAR2 | (80) | Meaning of Effectivity control type. | |
| EFFECTIVITY_DATE | DATE | Effectivity date. | ||
| FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Overloaded column to store information for serial number or unit effectivity. | |
| STRUCTURE_CONTENT | VARCHAR2 | (30) | Structure contains changed components only. | |
| STRUCTURE_CONTENT_MEANING | VARCHAR2 | (4000) | Structure content Meaning | |
| CHANGE_ORDER_CREATION | VARCHAR2 | (30) | Create new change order or add to existing change order. | |
| CHANGE_ORDER_CREATION_MEANING | VARCHAR2 | (4000) | Change order Creation Meaning | |
| ADD_ALL_TO_CHANGE_FLAG | VARCHAR2 | (1) | Add all imported items to change order. | |
| ADD_ALL_TO_CHANGE_FLAG_MEANING | VARCHAR2 | (4000) | ADD_ALL_TO_CHANGE_FLAG Meaning | |
| CHANGE_MGMT_TYPE_CODE | VARCHAR2 | (30) | Change Management Type Code. | |
| CHANGE_MGMT_TYPE_MEANING | VARCHAR2 | (80) | CHANGE_MGMT_TYPE_CODE Meaning | |
| CHANGE_TYPE_ID | NUMBER | Change order type. | ||
| CHANGE_TYPE_NAME | VARCHAR2 | (80) | Change order type name. | |
| CHANGE_NOTICE | VARCHAR2 | (10) | Change order number. | |
| CHANGE_NAME | VARCHAR2 | (240) | Change order name. | |
| CHANGE_DESCRIPTION | VARCHAR2 | (2000) | Change order description. | |
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Version number for concurrency control purpose. | |
| OBJECT_VERSION_NUMBER1 | NUMBER | Yes | Version number for concurrency control purpose. | |
| NIR_OPTION | VARCHAR2 | (1) | This column provides the New Item Request creation option. Valid values are N (None), C (One per item catalog category), I (One per Item). | |
| NIR_OPTION_MEANING | VARCHAR2 | (4000) | This column provides the New Item Request Meaning. Possible values are 'None' and 'One per Item'. | |
| SCHEDULED_REQUEST_ID | NUMBER | This column provides the scheduled request identifier | ||
| IMPORT_SCHEDULE_DATE | DATE | This column provides the import scheduled request date | ||
| ENABLED_FOR_DATA_POOL | VARCHAR2 | (1) | This column provides whether batch/source system is enabled for Data Pool or not. If a batch is enabled for data pool, then only it can be used for inbound messages. | |
| ENABLED_FOR_DATA_POOL_MEANING | VARCHAR2 | (4000) | This column provides the enabled for data pool meaning. Possible values include 'Yes' and 'No'. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, ORGANIZATION_ID
, SOURCE_SYSTEM_ID
, SOURCE_SYSTEM_NAME
, BATCH_TYPE
, BATCH_TYPE_MEANING
, ASSIGNEE
, ASSIGNEE_NAME
, BATCH_STATUS
, BATCH_STATUS_MEANING
, BATCH_NAME
, BATCH_DESCRIPTION
, LAST_MATCH_REQUEST_ID
, LAST_IMPORT_REQUEST_ID
, CREATED_BY
, CREATOR_NAME
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DEF_MATCH_RULE_CUST_APP_ID
, DEF_MATCH_RULE_CUST_CODE
, DEF_MATCH_RULE_RN_APP_ID
, DEF_MATCH_RULE_RN_CODE
, DEFAULT_MATCH_RULE_MEANING
, OPTION_SET_ID
, APPLY_DEF_MATCH_RULE_ALL
, APPLY_DEFMATCHRULEALL_MEANING
, MATCH_ON_DATA_LOAD
, MATCH_ON_DATA_LOAD_MEANING
, CONFIRM_SINGLE_MATCH
, CONFIRM_SINGLE_MATCH_MEANING
, IMPORT_ON_DATA_LOAD
, IMPORT_ON_DATA_LOAD_MEANING
, REVISION_IMPORT_POLICY
, REVISION_IMPORT_POLICY_MEANING
, IMPORT_XREF_ONLY
, IMPORT_XREF_ONLY_MEANING
, STRUCTURE_TYPE_ID
, STRUCTURE_TYPE_DISPLAY_NAME
, STRUCTURE_NAME
, STRUCTURE_DISPLAY_NAME
, STRUCTURE_EFFECTIVITY_TYPE
, STRUCTURE_EFF_TYPE_MEANING
, EFFECTIVITY_DATE
, FROM_END_ITEM_UNIT_NUMBER
, STRUCTURE_CONTENT
, STRUCTURE_CONTENT_MEANING
, CHANGE_ORDER_CREATION
, CHANGE_ORDER_CREATION_MEANING
, ADD_ALL_TO_CHANGE_FLAG
, ADD_ALL_TO_CHANGE_FLAG_MEANING
, CHANGE_MGMT_TYPE_CODE
, CHANGE_MGMT_TYPE_MEANING
, CHANGE_TYPE_ID
, CHANGE_TYPE_NAME
, CHANGE_NOTICE
, CHANGE_NAME
, CHANGE_DESCRIPTION
, OBJECT_VERSION_NUMBER
, OBJECT_VERSION_NUMBER1
, NIR_OPTION
, NIR_OPTION_MEANING
, SCHEDULED_REQUEST_ID
, IMPORT_SCHEDULE_DATE
, ENABLED_FOR_DATA_POOL
, ENABLED_FOR_DATA_POOL_MEANING
FROM APPS.EGO_IMPORT_BATCH_DETAILS_V;
APPS
AK_CUSTOMIZATIONS_TL
BOM_ALTERNATE_DESIGNATORS_TL
BOM_GLOBALS
- show dependent code
BOM_STRUCTURE_TYPES_TL
EGO_IMPORT_BATCHES_VL
EGO_IMPORT_OPTION_SETS
EGO_ITEM_UTIL_PVT
- show dependent code
ENG_CHANGE_ORDER_TYPES
ENG_CHANGE_ORDER_TYPES_TL
FND_CONCURRENT_REQUESTS
FND_OBJECTS_VL
HZ_ORIG_SYSTEMS_TL
MFG_LOOKUPS
APPS
EGO_IMPORT_PVT
- show dependent code
|
|
|
|