[Home] [Help] [Dependency Information]
Object Name: | EGO_ATTR_GRPS_ASSOC_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | EGO |
FND Design Data: | EGO.EGO_ATTR_GRPS_ASSOC_INTERFACE |
Subobject Name: | |
Status: | VALID |
Interface Table for associating Attribute Group to an ICC
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_CATALOG_GROUP_ID | NUMBER | Identifier for the Item Catalog Group id ( foreign key to MTL_ITEM_CATALOG_GROUPS_B) | ||
ITEM_CATALOG_NAME | VARCHAR2 | (819) | Identifier for the Item Catalog Group name | |
DATA_LEVEL | VARCHAR2 | (240) | Lookup indicating the level of granularity at which the Attribute Group is to be associated to the Object. Column not used currently. | |
DATA_LEVEL_ID | NUMBER | Data Level identifier. | ||
ATTR_GROUP_NAME | VARCHAR2 | (30) | Attribute Group to be associated to the Object | |
ATTR_GROUP_ID | NUMBER | (10) | Identifier for the Attribute Group to be associated to the Object (foreign key to EGO_FND_DSC_FLX_CTX_EXT) | |
SET_PROCESS_ID | NUMBER | (15) | Batch identifier in this table | |
TRANSACTION_ID | NUMBER | (15) | ID column used to tie back the record from mtl_interface_errors table | |
PROCESS_STATUS | NUMBER | (15) | Initial(1) , Error ( 3), Success (7) | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Identifies whether the record is for CREATE,UPDATE, OR SYNC | |
REQUEST_ID | NUMBER | (15) | Standard concurrent request id | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard program application id | |
PROGRAM_ID | NUMBER | (15) | Standard program id | |
PROGRAM_UPDATE_DATE | DATE | Standard program update date | ||
CREATED_BY | NUMBER | (15) | Standard "WHO" column | |
CREATION_DATE | DATE | Standard "WHO" column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard "WHO" column | |
LAST_UPDATE_DATE | DATE | Standard "WHO" column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard "WHO" column | |
ASSOCIATION_ID | NUMBER | Identifier for the Attribute Group to be associated to the Object (foreign key to EGO_FND_DSC_FLX_CTX_EXT) |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_CATALOG_GROUP_ID
, ITEM_CATALOG_NAME
, DATA_LEVEL
, DATA_LEVEL_ID
, ATTR_GROUP_NAME
, ATTR_GROUP_ID
, SET_PROCESS_ID
, TRANSACTION_ID
, PROCESS_STATUS
, TRANSACTION_TYPE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ASSOCIATION_ID
FROM EGO.EGO_ATTR_GRPS_ASSOC_INTERFACE;
EGO.EGO_ATTR_GRPS_ASSOC_INTERFACE does not reference any database object
EGO.EGO_ATTR_GRPS_ASSOC_INTERFACE is referenced by following:
|
|
|