[Home] [Help] [Dependency Information]
Object Name: | EGO_ITEM_ASSOCIATIONS_INTF |
---|---|
Object Type: | TABLE |
Owner: | EGO |
FND Design Data: | EGO.EGO_ITEM_ASSOCIATIONS_INTF |
Subobject Name: | |
Status: | VALID |
This table is used to store the interface records for item associations
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EGO_ITEM_ASSOCIATIONS_INTF_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | BATCH_ID |
EGO_ITEM_ASSOCIATIONS_INTF_N10 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | BUNDLE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | Refers to the batch which needs to be processed | |
ITEM_NUMBER | VARCHAR2 | (700) | Refers to concatenated_segments from mtl_system_items_b_kfv | |
INVENTORY_ITEM_ID | NUMBER | Refers to inventory item identifier in mtl_system_items_b | ||
ORGANIZATION_ID | NUMBER | Refers to organization_id from mtl_paramteres | ||
PK1_VALUE | NUMBER | Refers to pk1_value of the associated entity | ||
PK2_VALUE | NUMBER | Refers to pk2_value of the associated entity | ||
PK3_VALUE | NUMBER | Refers to pk3_value of the associated entity | ||
PK4_VALUE | NUMBER | Refers to pk4_value of the associated entity | ||
PK5_VALUE | NUMBER | Refers to pk5_value of the associated entity | ||
DATA_LEVEL_ID | NUMBER | Refers to data level identifier of the association. Column in ego_data_level_b | ||
PRIMARY_FLAG | VARCHAR2 | (1) | Indicates whether this association is Primary for the item or not | |
STATUS_CODE | NUMBER | Refers to status of the association | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Refers to organization_code from mtl_parameters | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Yes | Indicates the action user wants to perform on the Production Data |
PROCESS_FLAG | NUMBER | Indicates the status of the record | ||
TRANSACTION_ID | NUMBER | Unique key to identify a record in this table | ||
ASSOCIATION_ID | NUMBER | Refers to association_id in ego_item_associations | ||
CREATED_BY | NUMBER | (15) | One of the five standard "WHO" columns | |
CREATION_DATE | DATE | One of the five standard "WHO" columns | ||
LAST_UPDATED_BY | NUMBER | (15) | One of the five standard "WHO" columns | |
LAST_UPDATE_DATE | DATE | One of the five standard "WHO" columns | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | One of the five standard "WHO" columns | |
REQUEST_ID | NUMBER | Refers to the concurrent request id of this import process | ||
PROGRAM_APPLICATION_ID | NUMBER | One of the concurrent request "WHO" column | ||
PROGRAM_ID | NUMBER | One of the concurrent request "WHO" column | ||
PROGRAM_UPDATE_DATE | DATE | One of the concurrent request "WHO" column | ||
SUPPLIER_NAME | VARCHAR2 | (360) | This column identifies to which supplier name the association is created for. References party_name from hz_parties for the party_id in ap_suppliers | |
SUPPLIER_NUMBER | VARCHAR2 | (30) | This column identifies the supplier number for which the association is created for. | |
SUPPLIER_SITE_NAME | VARCHAR2 | (15) | This column identifies to which supplier site name the association is created for. References vendor_site_code in ap_supplier_sites_all | |
DATA_LEVEL_NAME | VARCHAR2 | (30) | Refers to data_level_name of the association. References data_level_name from ego_data_level_b. | |
STYLE_ITEM_FLAG | VARCHAR2 | (1) | Style Item flag of the corresponding item. For internal use only | |
STYLE_ITEM_ID | NUMBER | Style Item Identifier of the corresponding item. For internal use only. | ||
BUNDLE_ID | NUMBER | Bundle Id. | ||
SOURCE_SYSTEM_ID | NUMBER | Source System Id for incoming item. | ||
SOURCE_SYSTEM_REFERENCE | VARCHAR2 | (255) | Source System Reference for incoming item. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, ITEM_NUMBER
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, DATA_LEVEL_ID
, PRIMARY_FLAG
, STATUS_CODE
, ORGANIZATION_CODE
, TRANSACTION_TYPE
, PROCESS_FLAG
, TRANSACTION_ID
, ASSOCIATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SUPPLIER_NAME
, SUPPLIER_NUMBER
, SUPPLIER_SITE_NAME
, DATA_LEVEL_NAME
, STYLE_ITEM_FLAG
, STYLE_ITEM_ID
, BUNDLE_ID
, SOURCE_SYSTEM_ID
, SOURCE_SYSTEM_REFERENCE
FROM EGO.EGO_ITEM_ASSOCIATIONS_INTF;
EGO.EGO_ITEM_ASSOCIATIONS_INTF does not reference any database object
EGO.EGO_ITEM_ASSOCIATIONS_INTF is referenced by following:
|
|
|