CTO_CONFIG_REQ_LINES_GT

This tables used temporarily store the input payload to getconfigitem method which is used in matching pl/sql procedure

Details

• Schema: FUSION

• Object owner: CTO

• Object type: TABLE

• Tablespace: TEMP

Primary Key

Name	Columns
CTO_CONFIG_REQ_LINES_GT_PK	LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LINE_ID	VARCHAR2	50		Yes	Primary Key generated by system
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.
CONFIGURED_ITEM_ID	NUMBER		18		Matched Configured Item Identifier
INVENTORY_ITEM_ID	NUMBER		18	Yes	Input Inventory Item Identifier
SUB_ITEM_TYPE	VARCHAR2	30		Yes	Input Sub Item Type of the item
PARENT_LINE_ID	VARCHAR2	50			Input Parent Line Identifier for the line
ROOT_PARENT_LINE_ID	VARCHAR2	50			Input Root Parent Line Identifier
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
ORDER_QUANTITY	NUMBER				Order Quantity of the CTO item
ORDERED_UOM_CODE	VARCHAR2	3			Ordered Unit of measure Code
CONFIG_MODE	VARCHAR2	30			Configuration Mode for request
TOP_LEVEL_LINE_ID	NUMBER		18		Top level line id after matching
MATCH_KEY	VARCHAR2	400			Lock or match key for the ATO configuration.
ONE_TIME_CONFIG_FLAG	VARCHAR2	1			Contains Y or N. Y: Fulfill the item as a one-time configuration. N: Don't fulfill the item as a one-time configuration
CONFIG_ITEM_VERSION	NUMBER		9		Number that identifies the version of a one-time configured item

Indexes

Index	Uniqueness	Columns
CTO_CONFIG_REQ_LINES_GT_N1	Non Unique	PARENT_LINE_ID
CTO_CONFIG_REQ_LINES_GT_U1	Unique	LINE_ID