InspectionPlans

The Inspection Plans resource manages inspection plan details.

Columns


Name	Type	Description
InspectionPlanId [KEY]	String	Value that uniquely identifies the inspection plan.
OrganizationId	String	Value that uniquely identifies the organization that the inspection plan references.
VersionNumber	String	Version number of the inspection plan.
Name	String	Name of the inspection plan.
Description	String	Indicates the translatable description of inspection plan version.
Type	String	Type of inspection plan. Valid values include Receiving, Inventory, Work in process, and Resource. A list of accepted values is defined in the lookup type ORA_QA_IP_TYPES.
Status	String	Status of the inspection plan. Valid values include New, On hold, Obsolete, and Approved. A list of accepted values is defined in the lookup type ORA_QA_IP_STATUSES. The default value is New.
EnabledFlag	Bool	Contains one of the following values: Yes or No. If Yes, then inspection plan is enabled. If No, then inspection plan is disabled. The default value is Yes.
EffectiveStartDate	Datetime	Start date and time when the inspection plan is in effect. The default value is the current system date and time.
EffectiveEndDate	Datetime	End date when the inspection plan is no longer in effect.
InspectionLevelId	String	Value that uniquely identifies the inspection level.
InventoryItemId	String	Value that uniquely identifies the item that the inspection plan references if the inspection plan type is one of the following values Receiving, Inventory, or Work in process.
ItemRevision	String	Value that identifies the revision of the item if the inspection plan type is one of the following values Receiving, Inventory, or Work in process. This attribute is optional.
CategorySetId	String	Value that uniquely identifies the catalog of the item to inspect if inspection plan type is one of the following values Receiving, Inventory, or Work in process.
CategoryId	String	Value that uniquely identifies the category of the item to inspect if inspection plan type is one of the following values Receiving, Inventory, or Work in process.
WorkCenterId	String	Value that uniquely identifies the work center to inspect if inspection plan type is Resource.
ResourceId	String	Value that uniquely identifies the resource under the work center to inspect if inspection plan type is Resource.
Owner	String	Name of the user who created the inspection plan.
OptionalFlag	Bool	Contains one of the following values: Yes or No. If Yes, then inspection plan is optional. If No, then inspection plan is mandatory. The default value is No.
Approver	String	Identifies the user who approved the plan.
OrganizationCode	String	Abbreviation that identifies the organization.
WorkCenter	String	Name of the work center to inspect if the inspection plan type is Resource.
ResourceName	String	Name of the resource under the work center to inspect if inspection plan type is Resource.
ItemNumber	String	Alphanumeric value that identifies the item that the inspection plan references if the inspection plan type is one of the following values Receiving, Inventory, or Work in process.
CatalogName	String	Name of the catalog to inspect if inspection plan type is one of the following values Receiving, Inventory, or Work in process.
CategoryName	String	Name of the category of the item to inspect if inspection plan type is one of the following values Receiving, Inventory, or Work in process.
InspectionLevelName	String	Name of the inspection level.
InspectionLevelDescription	String	Indicates the translatable description of inspection level.
CreatedBy	String	User who created the inspection plan.
CreationDate	Datetime	Date when the user created the inspection plan.
LastUpdateDate	Datetime	Date when the user most recently updated the inspection plan.
LastUpdatedBy	String	Name of the user who most recently updated the inspection plan.

JDBC Driver for Oracle SCM

InspectionPlans

Columns