QA_INSPECTION_PLANS

Details

Schema: FUSION
Object owner: QA
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
QA_INSPECTION_PLANS_B_PK	INSPECTION_PLAN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INSPECTION_PLAN_ID	NUMBER		18	Yes	Surrrogate identifier for inspection plan.
ASSET_ID	NUMBER		18		Value that uniquely identifies an asset.
ASSET_GROUP_ID	NUMBER		18		Value that uniquely identifies an asset group.
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.
ORGANIZATION_ID	NUMBER		18	Yes	Surrrogate identifier for organization in which the inspection plan is defined.
INSPECTION_PLAN_CODE	VARCHAR2	30		Yes	Indicates the user-defined code for the inspection plan.
VERSION_NUMBER	VARCHAR2	30		Yes	Indicates the user-defined version number of the inspection plan.
INSPECTION_PLAN_TYPE	VARCHAR2	30		Yes	Indicates the inspection plan type. Options are (1) Receipt from Suppliers (2) Receipt into Inventory (3) Work In Process (4) Resource.
INSPECTION_PLAN_STATUS	VARCHAR2	30		Yes	Indicates the status of the inspection plan. Options are (1) New (2) On Hold (3) Approved.
ENABLED_FLAG	VARCHAR2	1		Yes	Indicates whether the inspection plan is enabled for use. Options are (1)Y (2)N. Default value is Y.
EFFECTIVE_START_DATE	DATE				Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE	DATE				Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
INSPECTION_LEVEL_ID	NUMBER		18		Identifies the inspection level.
INVENTORY_ITEM_ID	NUMBER		18		Identifies the item for which the inspection plan is applicable for.
REVISION	VARCHAR2	18			Identifies the item version for which the inspection plan is applicable for. If the value is null, that means the inspection plan is applicable for all versions of the item.
CATEGORY_SET_ID	NUMBER		18		Identifies the item catalog for which the inspection plan is applicable for.
CATEGORY_ID	NUMBER		18		Identifies the item category for which the inspection plan is applicable for.
WORK_CENTER_ID	NUMBER		18		Identifies the work center for which the inspection plan is applicable for. This is available for user selection if the inspection plan type is resource.
RESOURCE_ID	NUMBER		18		Identifies the resource for which the inspection plan is applicable for. This is available for user selection if the inspection plan type is resource.
OWNER	VARCHAR2	100			Identifies the owner of the inspection plan and can be different from the user who created the inspection plan.
OPTIONAL_FLAG	VARCHAR2	1		Yes	Indicates whether the inspection plan is optional or mandatory. Options are (1) Y (2) N. Default value is N.
APPROVER	VARCHAR2	100			Identifies the user who approved the inspection plan and can be different from the user who created the inspection plan or the owner of the inspection plan.
ACTION_RULE_EXISTS_FLAG	VARCHAR2	1			Indicates whether the inspection plan has action rules or not. Options are (1) Y (2) N (3) Null.
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
QA_INSPECTION_PLANS_B_N1	Non Unique	DEFAULT	INSPECTION_LEVEL_ID, INSPECTION_PLAN_STATUS
QA_INSPECTION_PLANS_B_PK	Unique	FUSION_TS_TX_DATA	INSPECTION_PLAN_ID
QA_INSPECTION_PLANS_B_U1	Unique	FUSION_TS_TX_DATA	ORGANIZATION_ID, INSPECTION_PLAN_CODE, VERSION_NUMBER