InspectionFlagCommonParams

The Inspection Parameters resource manages inspection details.

Columns


Name	Type	Description
InspectionPlanId	String	Value that uniquely identifies the returned inspection plan.
OrganizationId	String	Value that uniquely identifies the organization.
InventoryItemId	String	Value that uniquely identifies the inventory item.
Revision	String	Revision of the item.
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.
SubinventoryCode	String	Abbreviation that identifies the subinventory.
LocatorId	String	Value that uniquely identifies the locator.
OperationCode	String	Abbreviation that identifies the operation.
DispatchStatus	String	Status of the dispatch in the work order operation. A list of accepted values include Ready and Reject.
OperationSequenceNumber	Long	Sequence number of the work order operation that occurs during manufacturing inspection.
WorkOrderQuantity	String	Work order quantity.
InspectionCheckValue	String	Contains one of the following values. N: The application does not require an inspection because it cannot find the inspection plan. O: The application found the inspection plan, and the inspection is optional.
DocumentType	String	Type of document for the inspection event where inspection plan type is Receiving. Valid values include Purchase order, Transfer order, In-transit shipment, and Return material authorization. A list of accepted values is defined in the lookup type ORA_QA_IP_DOC_TYPES.
SupplierId	String	Value that uniquely identifies the supplier.
SupplierSiteId	String	Value that uniquely identifies the supplier site.
SourceOrganizationId	String	Value that uniquely identifies the source organization.
ReceiptQuantity	String	Quantity received.
SourceProductCode	String	Abbreviation that identifies the source product. Valid values include WIP and RCV. If WIP, the source product is work in progress. If RCV, the source product is in receiving.
InspectionQuantity	String	Number of samples or serials inspected.
InspectionPlanName	String	Name of the inspection plan.
ReturnStatus	String	Return status of the service call.
ErrorMessage	String	Error details, if an error occurs.
OrganizationCode	String	Abbreviation that identifies the organization.
ItemNumber	String	Number that identifies the item inspected.
Locator	String	Abbreviation that identifies the locator where the material resides.
SubinventoryId	String	Value that uniquely identifies the subinventory.
WorkCenter	String	Abbreviation that identifies the work center.
ResourceId	String	Value that uniquely identifies the resource.
ResourceCode	String	Abbreviation that identifies the resource.
WorkCenterId	String	Value that uniquely identifies the work center.
InspPlanVersion	String	Version number of the inspection plan.
OptionalFlag	Bool	Contains one of the following values: true or false. If true, then the returned inspection plan is optional. If false, then the plan is not optional. The default value is false.
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.
Description	String	Indicates the translatable description of inspection plan version.
InspectionDate	Datetime	Date and time when the plan was inspected.
SourceOrganizationCode	String	Abbreviation that uniquely identifies the source organization.
Supplier	String	Abbreviation that identifies the supplier.
SupplierSite	String	Abbreviation that identifies the supplier site.

JDBC Driver for Oracle SCM

InspectionFlagCommonParams

Columns