MSC_NPI_DEF

Table stores the New Product Definitions, primary records

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MSC_NPI_DEF_PK	NPI_DEF_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
NPI_DEF_ID	NUMBER		18	Yes	The unique identifier of the New Product definition.
PLAN_ID	NUMBER		18	Yes	The unique identifier of the plan.
SOURCE_PRODUCT_ID	NUMBER		18	Yes	The identifier of the product from which the new product was created by the Manage Product Launch process.
NEW_PRODUCT_ID	NUMBER		18	Yes	The unique identifier of the new product created by the Manage Product Launch process.
STATUS	NUMBER		1	Yes	STATUS 1=In Progress,2=Active,3=Completed
LAST_COPY_DATE	DATE				The date the data was last copied from the source to the target product.
ADD_DEL_FLAG	NUMBER		1		Add or Delete Flag , 0 = Default , 1= Add/ Changed, 2 = Deleted
SOURCE_CUS_ORG_FLAG	NUMBER		1		Indicates whether all source product customer sites and organizations were selected for the new product launch request. The valid values are 1, 2, and NULL. When the value is 1, all source product customer sites and organizations were selected. When the value is 2 or NULL, specific source product customer sites and organizations were selected for the launch request.
PROCESS_END_DATE_FLAG	NUMBER		1		Indicates whether all customer sites and organizations selected for the new product launch request will have the same process end date. The valid values are 0, 1, and NULL. When the value is 1, all customer sites and organizations will have the same process end date. When the value is 0 or NULL, customer sites and organizations may have different process end dates.
COPY_MEASURE_DATA_FLAG	NUMBER		1		Indicates whether selection of measures to be copied from the source product to the new product combinations is allowed. The valid values are 0, 1, and NULL. When the value is 1 or NULL, selection of measures to be copied from the source product to the new product combinations is allowed. When the value is 0, measure selection is not allowed for the product launch request.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_NPI_DEF_U1	Unique	Default	NPI_DEF_ID