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_QCRESULT_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Comments
RESULT_DATE	DATE		Result posted date
RESULT	VARCHAR2	(80)	Result
RESULTS_QCUNIT_CODE	VARCHAR2	(25)	Result Quality Control Unit Code
ACCEPT	VARCHAR2	(1)	Accept
FINAL_MARK	VARCHAR2	(1)	Final Mark
TEST_PROVIDER_CODE	VARCHAR2	(8)	Test Provider Code
ASSAY_TESTER	VARCHAR2	(30)	Assay Tester
WF_RESPONSE	VARCHAR2	(1)	Workflow Response
ASSAY_RETEST_FLAG	NUMBER	(8)	Retest Flag
QCASSY_TYP_ID	NUMBER		Assay Type ID
QC_RESULT_ID	NUMBER		Result ID
QC_SPEC_ID	NUMBER		Spec ID
ORGN_CODE	VARCHAR2	(4)	Organization Code
SAMPLE_ID	NUMBER		Sample ID
SAMPLE_NO	VARCHAR2	(80)	Sample Number
SAMPLE_DESC	VARCHAR2	(80)	Sample Description
SAMPLE_STATUS	VARCHAR2	(30)	Sample Status
SAMPLE_STATUS_MEANING	VARCHAR2	(80)	Sample Status meaning
ASSAY_CODE	VARCHAR2	(80)	Assay Code
ASSAY_DESC	VARCHAR2	(240)	Assay Description
ITEM_ID	NUMBER		Item ID
LOT_ID	NUMBER		Lot ID
WHSE_CODE	VARCHAR2	(4)	Warehouse
LOCATION	VARCHAR2	(16)	Location
FORMULA_ID	NUMBER		Formula ID
FORMULALINE_ID	NUMBER		Formula Line ID
ROUTING_ID	NUMBER		Routing ID
ROUTINGSTEP_ID	NUMBER		Routing Step ID
OPRN_ID	NUMBER		Operation ID
CUST_ID	NUMBER		Customer ID
SHIP_TO_SITE_ID	NUMBER
VENDOR_ID	NUMBER		Vendor ID
BATCH_ID	NUMBER		Batch ID
ROUTINGSTEP_NO	NUMBER		Routing Step Number
ITEM_NUMBER	VARCHAR2	(32)	Item Number
ITEM_DESCRIPTION	VARCHAR2	(70)	Item Description
ITEM_UOM	VARCHAR2	(4)	Primary UOM
ITEM_UOM2	VARCHAR2	(4)	Secondary UOM
DOC_TYPE	VARCHAR2	(0)	Document Type
DOC_ID	VARCHAR2	(0)	Document ID
DOCLINE_ID	VARCHAR2	(0)	Document Line ID
CUST_SPECIFICATION	VARCHAR2	(0)	Customer Specification
CUST_CERTIFICATION	VARCHAR2	(0)	Customer Certification
VENDOR_SPECIFICATION	VARCHAR2	(0)	Vendor Specification
VENDOR_CERTIFICATION	VARCHAR2	(0)	Vendor Certification
TEXT_SPEC	VARCHAR2	(16)	Text Spec
TARGET_SPEC	VARCHAR2	(40)	Target Spec
MIN_SPEC	VARCHAR2	(40)	Min Spec
MAX_SPEC	VARCHAR2	(40)	Max Spec
SPEC_QCUNIT_CODE	VARCHAR2	(25)	Spec Quality Control Unit Code
FROM_DATE	DATE		From Date
TO_DATE	DATE		To Date
OUTACTION_CODE	VARCHAR2	(32)	Out Of Action Code
OUTACTION_INTERVAL	NUMBER		Out Of Action Interval
PREFERENCE	VARCHAR2	(0)	Preference
PRINT_COA_SHIPPED	VARCHAR2	(1)	To Indentify whether Certificate of Analysis need to be sent with shipment Flag
PRINT_COA_INVOICED	VARCHAR2	(1)	Print Certificate of Analysis Flag
VENDOR_COA_REQUIRED	VARCHAR2	(1)	Vendor Certificate of Analysis Required Flag
TEST_OPRN_ID	NUMBER		Test Operation ID
TEST_OPRN_LINE_ID	NUMBER		Test Operation Line ID
CUSTOMER_NO	VARCHAR2	(30)	Customer Number
CUSTOMER_NAME	VARCHAR2	(360)	Customer Name
VENDOR_NO	VARCHAR2	(32)	VEndor Number
VENDOR_NAME	VARCHAR2	(40)	Vendor Name
ACCEPT_ANYWAY	VARCHAR2	(1)	Accept Anyway
LOT_NO	VARCHAR2	(32)	Lot Number
SUBLOT_NO	VARCHAR2	(32)	Sublot Number
CREATED_BY	NUMBER	(15)	ROW WHO Column
CREATION_DATE	DATE		ROW WHO Column
LAST_UPDATE_DATE	DATE		ROW WHO Column
LAST_UPDATED_BY	NUMBER	(15)	ROW WHO Column

Query Text

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


SELECT RESULT_DATE
,      RESULT
,      RESULTS_QCUNIT_CODE
,      ACCEPT
,      FINAL_MARK
,      TEST_PROVIDER_CODE
,      ASSAY_TESTER
,      WF_RESPONSE
,      ASSAY_RETEST_FLAG
,      QCASSY_TYP_ID
,      QC_RESULT_ID
,      QC_SPEC_ID
,      ORGN_CODE
,      SAMPLE_ID
,      SAMPLE_NO
,      SAMPLE_DESC
,      SAMPLE_STATUS
,      SAMPLE_STATUS_MEANING
,      ASSAY_CODE
,      ASSAY_DESC
,      ITEM_ID
,      LOT_ID
,      WHSE_CODE
,      LOCATION
,      FORMULA_ID
,      FORMULALINE_ID
,      ROUTING_ID
,      ROUTINGSTEP_ID
,      OPRN_ID
,      CUST_ID
,      SHIP_TO_SITE_ID
,      VENDOR_ID
,      BATCH_ID
,      ROUTINGSTEP_NO
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ITEM_UOM
,      ITEM_UOM2
,      DOC_TYPE
,      DOC_ID
,      DOCLINE_ID
,      CUST_SPECIFICATION
,      CUST_CERTIFICATION
,      VENDOR_SPECIFICATION
,      VENDOR_CERTIFICATION
,      TEXT_SPEC
,      TARGET_SPEC
,      MIN_SPEC
,      MAX_SPEC
,      SPEC_QCUNIT_CODE
,      FROM_DATE
,      TO_DATE
,      OUTACTION_CODE
,      OUTACTION_INTERVAL
,      PREFERENCE
,      PRINT_COA_SHIPPED
,      PRINT_COA_INVOICED
,      VENDOR_COA_REQUIRED
,      TEST_OPRN_ID
,      TEST_OPRN_LINE_ID
,      CUSTOMER_NO
,      CUSTOMER_NAME
,      VENDOR_NO
,      VENDOR_NAME
,      ACCEPT_ANYWAY
,      LOT_NO
,      SUBLOT_NO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.PMIFV_QCRESULT_V;

Dependencies

[top of page]

APPS.PMIFV_QCRESULT_V references the following:

APPS: GEM_LOOKUPS; GMD_ALL_SPEC_VRS; GMD_EVENT_SPEC_DISP; GMD_QC_TESTS_VL; GMD_RESULTS; GMD_SAMPLES; GMD_SAMPLE_SPEC_DISP; GMD_SPEC_RESULTS; GMD_SPEC_TESTS; HZ_CUST_ACCOUNTS_ALL; HZ_PARTIES; IC_ITEM_MST; IC_LOTS_MST; PMI_SECURITY_PKG - show dependent code; PO_VEND_MST; SY_ORGN_MST

APPS.PMIFV_QCRESULT_V is not referenced by any database object