ACA_STRUCTURE_IMPL

Details

Schema: FUSION
Object owner: ACA
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
ACA_ITEM_WHEREUSED_STAGIN_PK	ITEM_ID, CURRENT_ITEM_ID, ITEM_ORG_ID, REVISION_ID, COMPONENT_SEQUENCE_ID, NODE_SEQUENCE, SORT_CODE, SEQUENCE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ITEM_ID	NUMBER		18	Yes	The Where Used identifier for the item
PARENT_ITEM_ID	NUMBER		18		WHERE USED Parent Item Identifier
CURRENT_ITEM_ID	NUMBER		18	Yes	Unique Identifier for Current Item
ITEM_ORG_ID	NUMBER		18	Yes	WHERE Used Item Organization Identifier
PARENT_ITEM_ORG_ID	NUMBER		18		Parent Item Organization Identifier
CURRENT_ITEM_ORG_ID	NUMBER		18		Current Item Organization Identifier
REVISION_ID	NUMBER		18	Yes	The Where Used identifier for the item revision
PARENT_ITEM_REVISION_ID	NUMBER		18		Parent Item Revision Identifier
CURRENT_ITEM_REVISION_ID	NUMBER		18		Current Item Revision Identifier
CURRENT_COMPONENT_BILL_SEQ_ID	NUMBER		18		Current Component Bill Sequence Identifier
PARENT_ITEM_BILL_SEQUENCE_ID	NUMBER		18		Parent Item Bill Sequence Identifier
COMPONENT_SEQUENCE_ID	NUMBER		18	Yes	WHERE Used Component Sequence Identifier
CURRENT_COMPONENT_SEQUENCE_ID	NUMBER		18		Current Component Bill Sequence Identifier
PLAN_LEVEL	NUMBER		18		The item plan level within the where used
TOP_ITEM_FLAG	NUMBER		1	Yes	The indicator that an item is the top-level item in a structure
NODE_SEQUENCE	NUMBER		18	Yes	The item node sequence in the structure
COMPONENT_PATH	VARCHAR2	4000			The item component path in the structure
SORT_CODE	VARCHAR2	2000		Yes	Sort code for Item Where Used Tree
PARENT_SORT_CODE	VARCHAR2	2000			Parent Structure Sort code for Item Where Used Tree
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	80			Alternate BOM Designator for Primary (non-primary) structures
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.
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_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
SEQUENCE_ID	NUMBER		18	Yes	Sequence Identifier to group the rows.
SUBSTITUTE_FOR_COMPONENT_ID	NUMBER				Inventory Item Id of the component, for which the current row is a substitute.
SUBSTITUTE_FOR_COMPONENT_NAME	VARCHAR2	300			Item Number of the component, for which the current row is a substitute.

Indexes

Index	Uniqueness	Tablespace	Columns
ACA_STRUCTURE_IMPL_STAGING_N1	Non Unique	Default	CURRENT_COMPONENT_SEQUENCE_ID
ACA_STRUCTURE_IMPL_STAGING_N2	Non Unique	Default	CURRENT_COMPONENT_BILL_SEQ_ID
ACA_STRUCTURE_IMPL_STAGING_N3	Non Unique	Default	CURRENT_ITEM_ID, CURRENT_ITEM_ORG_ID
ACA_STRUCTURE_IMPL_STAGING_N4	Non Unique	Default	PARENT_ITEM_ID, PARENT_ITEM_ORG_ID
ACA_STRUCTURE_IMPL_STAGING_N5	Non Unique	Default	REVISION_ID
ACA_STRUCTURE_IMPL_STAGING_U1	Unique	Default	ITEM_ID, CURRENT_ITEM_ID, ITEM_ORG_ID, REVISION_ID, COMPONENT_SEQUENCE_ID, NODE_SEQUENCE, SORT_CODE, SEQUENCE_ID