EGP_ITEM_PRESENCE_IND
EGP_ITEM_PRESENCE_IND stores information about existence of specific data for items including pending changes, quality issues, item structures, where used, item attachments, item supplier associations, related item relationships, manufacturer relationships, customer relationships, competitor relationships, supplier relationships, GTIN relationships, cross reference relationships, source system relationships, item category assignments, Product Development relationships, item rev attachments, start date and end date. There is one column for each of the item entities.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
EGP_ITEM_PRESENCE_IND_PK |
CHILD_PRESENCE_IND_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHILD_PRESENCE_IND_ID | NUMBER | 18 | Yes | A unique identifier which indicated child presence id. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Attribute indicating the unique identifier of the item. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | A organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. | |
| REVISION_ID | NUMBER | 18 | Identifies the revision of an item. | ||
| VERSION_ID | NUMBER | 18 | Yes | Version number to identify a version uniquely within a revision | |
| START_DATE | TIMESTAMP | Attribute indicating the effective start date for the item. | |||
| END_DATE | TIMESTAMP | Attribute indicating the effective end date for the item. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| PENDING_CHANGE_FLAG | VARCHAR2 | 1 | Attribute indicating whether pending changes exist. | ||
| QUALITY_ISSUE_FLAG | VARCHAR2 | 1 | Attribute indicating quality issues exist. | ||
| ITEM_STRUCTURE_FLAG | VARCHAR2 | 1 | Attribute indicating an item structure exists. | ||
| WHERE_USED_FLAG | VARCHAR2 | 1 | Attribute indicating the item is referenced in a where used query. | ||
| ITEM_ATTACHMENT_FLAG | VARCHAR2 | 1 | Attribute indicating an item attachment exists. | ||
| ITEM_SUPP_ASSOC_FLAG | VARCHAR2 | 1 | Attribute indicating an item supplier association exists. | ||
| RELATED_ITEM_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Attribute indicating a related item relationship exists. | ||
| MFG_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Attribute Indicating whether MFG relationship is enabled or created for an item. | ||
| CUSTOMER_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Attribute indicating an item customer relationship exists. | ||
| COMPETITOR_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Attribute indicating an item competitor relationship exists. | ||
| SUPPLIER_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Attribute indicating an item supplier relationship exists. | ||
| GTIN_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Attribute indicating an item GTIN relationship exists. | ||
| CROSS_REF_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Attribute indicating an item cross reference relationship exists. | ||
| SOURCE_SYS_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Attribute indicating an item source system relationship exists. | ||
| CATEGORY_ASSIGNMENT_FLAG | VARCHAR2 | 1 | Attribute indicating an item category assignment exists. | ||
| PD_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Attribute indicating Product Development relationship exists. | ||
| ITEM_PACK_FLAG | VARCHAR2 | 1 | Attribute indicating an item pack exists. | ||
| ITEM_REV_ATTACHMENTS_FLAG | VARCHAR2 | 1 | Attribute indicating an item revision attachment exists. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGP_ITEM_PRESENCE_IND_N1 | Non Unique | FUSION_TS_TX_IDX | REQUEST_ID |
| EGP_ITEM_PRESENCE_IND_N2 | Non Unique | FUSION_TS_TX_IDX | REVISION_ID, VERSION_ID |
| EGP_ITEM_PRESENCE_IND_U1 | Unique | FUSION_TS_TX_IDX | CHILD_PRESENCE_IND_ID |
| EGP_ITEM_PRESENCE_IND_U2 | Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID, REVISION_ID, VERSION_ID, ORGANIZATION_ID |