CSE_OM_ORDER_FLINES_INT

The interface entity that holds pending order fulfillment lines that are to be interfaced to the Installed Base application.

Details

• Schema: FUSION

• Object owner: CSE

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
CSE_OM_ORDER_FLINES_INT_PK	INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INTERFACE_ROW_ID	NUMBER		18	Yes	Interface Row Identifier. The primary key column of this table.
PARENT_INTERFACE_ROW_ID	NUMBER		18	Yes	The foreign key to the interface row of the cse_om_orders_int table.
LINE_ID	NUMBER		18		The orchestration order line identifier.
FULFILL_LINE_ID	NUMBER		18	Yes	The orchestration order fulfillment line identifier.
ERROR_TEXT	VARCHAR2	2000			Error text captured from the processing of this order fulfill line to Installed Base.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP				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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
CSE_OM_ORDER_FLINES_INT_N01	Non Unique	Default	PARENT_INTERFACE_ROW_ID
CSE_OM_ORDER_FLINES_INT_U01	Unique	Default	INTERFACE_ROW_ID