eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PMIFV_QC_PRODUCTION_SPEC_V

Object Details

Object Name:	PMIFV_QC_PRODUCTION_SPEC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIFV_QC_PRODUCTION_SPEC_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Comments
QUALITY_CONTROL_SPEC_ID	NUMBER	(10)	Quality Control Spec ID
ASSAY_TYPE_ID	NUMBER	(15)	Assay Type ID
ORGANIZATION_CODE	VARCHAR2	(4)	OPM Organization Code
WAREHOUSE_CODE	VARCHAR2	(4)	OPM Warehouse Code
LOCATION	VARCHAR2	(16)	Location
DOCUMENT_TYPE	VARCHAR2	(4)	Document Type
VENDOR_SPECIFICATION	NUMBER	(5)	Vendor Specification
VENDOR_CERTIFICATION	NUMBER	(5)	Vendor Certification
CUSTOMER_SPECIFICATION	NUMBER	(5)	Customer Specification
CUSTOMER_CERTIFICATION	NUMBER	(5)	Customer Certification
ASSAY_CODE	VARCHAR2	(16)	Assay Code
TEXT_SPEC	VARCHAR2	(16)	Text Spec
MIN_SPEC	NUMBER		MIN Spec
MAX_SPEC	NUMBER		MAX Spec
TARGET_SPEC	NUMBER		Target Spec
QUALITY_CONTROL_UNIT_CODE	VARCHAR2	(4)	Quality Control Unit Code
FROM_DATE	DATE		From Date
TO_DATE	DATE		To Date
OUT_OF_ACTION_CODE	VARCHAR2	(4)	Out Of Action Code
OUT_OF_ACTION_INTERVAL	NUMBER		Out Of Action Interval
PREFERENCE	NUMBER	(5)	Preference
PRINT_COA_SHIPPED	NUMBER	(5)	Print COA Shipped
PRINT_COA_INVOICED	NUMBER	(5)	Print COA Invoiced
VENDOR_COA_REQUIRED	NUMBER	(5)	Vendor COA Required
DELETE_MARK	NUMBER	(5)	Delete Mark is used mark record for logical deletion
ROUTING_STEP_NUMBER	NUMBER	(5)	Routing Step Number
CUSTOMER_NUMBER	CHAR	(1)	Customer Number
CUSTOMER_NAME	CHAR	(1)	Customer Name
ITEM_NUMBER	VARCHAR2	(32)	Item Number
ITEM_DESCRIPTION	VARCHAR2	(70)	Item Description
VENDOR_ID	NUMBER		Vendor ID
VENDOR_NUMBER	CHAR	(1)	Vendor Number
VENDOR_NAME	CHAR	(1)	Vendor Name
FORMULA_ID	NUMBER	(10)	Formula Id
FORMULA_NUMBER	VARCHAR2	(32)	Formula Number
FORMULA_VERSION	NUMBER		Formula Version
LOT_NUMBER	VARCHAR2	(32)	Lot Number
SUB_LOT_NUMBER	VARCHAR2	(32)	Sub Lot Number
BATCH_NUMBER	VARCHAR2	(32)	Batch Number
ROUTING_ID	NUMBER	(10)	Routing Id
ROUTING_NUMBER	VARCHAR2	(32)	Routing Number
ROUTING_VERSION	NUMBER	(5)	Routing Version
OPERATION_ID	NUMBER	(10)	Operation Id
OPERATION_NUMBER	VARCHAR2	(16)	Operation Number
OPERATION_VERSION	NUMBER	(5)	Operation Version
EFFECTIVE	VARCHAR2	(80)	Effective

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUALITY_CONTROL_SPEC_ID
,      ASSAY_TYPE_ID
,      ORGANIZATION_CODE
,      WAREHOUSE_CODE
,      LOCATION
,      DOCUMENT_TYPE
,      VENDOR_SPECIFICATION
,      VENDOR_CERTIFICATION
,      CUSTOMER_SPECIFICATION
,      CUSTOMER_CERTIFICATION
,      ASSAY_CODE
,      TEXT_SPEC
,      MIN_SPEC
,      MAX_SPEC
,      TARGET_SPEC
,      QUALITY_CONTROL_UNIT_CODE
,      FROM_DATE
,      TO_DATE
,      OUT_OF_ACTION_CODE
,      OUT_OF_ACTION_INTERVAL
,      PREFERENCE
,      PRINT_COA_SHIPPED
,      PRINT_COA_INVOICED
,      VENDOR_COA_REQUIRED
,      DELETE_MARK
,      ROUTING_STEP_NUMBER
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
,      FORMULA_ID
,      FORMULA_NUMBER
,      FORMULA_VERSION
,      LOT_NUMBER
,      SUB_LOT_NUMBER
,      BATCH_NUMBER
,      ROUTING_ID
,      ROUTING_NUMBER
,      ROUTING_VERSION
,      OPERATION_ID
,      OPERATION_NUMBER
,      OPERATION_VERSION
,      EFFECTIVE
FROM APPS.PMIFV_QC_PRODUCTION_SPEC_V;

Dependencies

[top of page]

APPS.PMIFV_QC_PRODUCTION_SPEC_V references the following:

APPS: FM_FORM_MST; FM_OPRN_MST; FM_ROUT_HDR; FND_GLOBAL - show dependent code; FND_LOOKUPS; GME_BATCH_HEADER; IC_ITEM_MST; IC_LOTS_MST; QC_SPEC_MST

APPS.PMIFV_QC_PRODUCTION_SPEC_V is not referenced by any database object