Inspection Plans

The Inspection Plans view object consolidates common information for the inspection plan, such as plan name, description, inventory organization, item, start date, end date, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.QaBiccExtractAM.InspectionPlansExtractPVO

Primary Keys : InspectionPlansTLRptPEOInspectionPlanId, InspectionPlansTLRptPEOLanguage

Initial Extract Date : InspectionPlansTLRptPEOCreationDate

Incremental Extract Date : InspectionPlansTLRptPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
InspectionPlansBaseRptPEOApprover	User who approved the plan.
InspectionPlansBaseRptPEOAssetGroupId	Value that uniquely identifies the asset group of the asset to inspect if inspection plan type is Asset.
InspectionPlansBaseRptPEOAssetId	Value that uniquely identifies the asset number to inspect if inspection plan type is Asset.
InspectionPlansBaseRptPEOCategoryId	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.
InspectionPlansBaseRptPEOCategorySetId	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.
InspectionPlansBaseRptPEOEffectiveEndDate	Date when the inspection plan is no longer in effect.
InspectionPlansBaseRptPEOEffectiveStartDate	Date and time when the inspection plan is in effect. The default value is the current system date and time.
InspectionPlansBaseRptPEOEnabledFlag	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.
InspectionPlansBaseRptPEOInspectionLevelId	Value that uniquely identifies the inspection level.
InspectionPlansBaseRptPEOInspectionPlanId	Value that uniquely identifies the inspection plan.
InspectionPlansBaseRptPEOInspectionPlanStatus	Status of inspection plan. A list of accepted values is defined in the lookup type ORA_QA_IP_STATUSES. It can have four possible values New, On hold, Obsolete, and Approved. The default value is New.
InspectionPlansBaseRptPEOInspectionPlanType	Type of inspection plan. A list of accepted values is defined in the lookup type ORA_QA_IP_TYPES. It can have four possible values: Receiving, Inventory, Work in Process, and Resource. This attribute doesn't have a default value.
InspectionPlansBaseRptPEOInventoryItemId	Value that uniquely identifies the item that the inspection plan references if the InspectionPlanType is one of the following values Receiving, Inventory, or Work in Process.
InspectionPlansBaseRptPEOOptionalFlag	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.
InspectionPlansBaseRptPEOOrganizationId	Value that uniquely identifies the organization that the inspection plan references.
InspectionPlansBaseRptPEOOwner	Name of the user who created the inspection plan.
InspectionPlansBaseRptPEOResourceId	Value that uniquely identifies the resource under the work center to inspect if inspection plan type is Resource.
InspectionPlansBaseRptPEORevision	Value that uniquely identifies the revision of the item if inspection plan type is one of the following values: Receiving, Inventory, or Work in Process. This attribute is optional.
InspectionPlansBaseRptPEOVersionNumber	Value that uniquely identifies the version of the inspection plan.
InspectionPlansBaseRptPEOWorkCenterId	Value that uniquely identifies the work center to inspect if inspection plan type is Resource.
InspectionPlansTLRptPEOCreatedBy	User who created the inspection plan.
InspectionPlansTLRptPEOCreationDate	Date when the user created the inspection plan.
InspectionPlansTLRptPEODescription	Translatable description of the inspection plan version.
InspectionPlansTLRptPEOInspectionPlanId	Value that uniquely identifies the inspection plan.
InspectionPlansTLRptPEOLanguage	Code that identifies the language into which the contents of the translatable columns are translated.
InspectionPlansTLRptPEOLastUpdateDate	Date when the inspection plan was last updated.
InspectionPlansTLRptPEOLastUpdateLogin	Session login associated with the user who last updated the inspection plan.
InspectionPlansTLRptPEOLastUpdatedBy	User who last updated the inspection plan.
InspectionPlansTLRptPEOName	Name of the inspection plan.
InspectionPlansTLRptPEOSourceLang	Code that identifies the language in which the contents of the translatable columns were originally created.