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.PMIBV_QCRESULT_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
RESULT_DATE	DATE
RESULT	VARCHAR2	(40)
RESULTS_QCUNIT_CODE	VARCHAR2	(4)	Yes
ACCEPT	NUMBER	(5)	Yes
CERTI_OF_ANALYSIS	NUMBER	(5)	Yes
TEST_PROVIDER_CODE	VARCHAR2	(8)
ASSAY_TESTER	VARCHAR2	(30)
WF_RESPONSE	VARCHAR2	(240)
ASSAY_RETEST_FLAG	NUMBER	(5)
QCASSY_TYP_ID	NUMBER	(15)	Yes
QC_RESULT_ID	NUMBER	(10)	Yes
QC_SPEC_ID	NUMBER	(10)
ORGN_CODE	VARCHAR2	(4)	Yes
SAMPLE_ID	NUMBER	(10)	Yes
SAMPLE_NO	VARCHAR2	(32)	Yes
SAMPLE_DESC	VARCHAR2	(70)
SAMPLE_STATUS	VARCHAR2	(80)	Yes
SAMPLE_STATUS_MEANING	VARCHAR2	(80)
ASSAY_CODE	VARCHAR2	(16)	Yes
ASSAY_DESC	VARCHAR2	(40)	Yes
ITEM_ID	NUMBER	(10)	Yes
LOT_ID	NUMBER	(10)
WHSE_CODE	VARCHAR2	(4)
LOCATION	VARCHAR2	(16)
FORMULA_ID	NUMBER	(10)
FORMULALINE_ID	NUMBER	(10)
ROUTING_ID	NUMBER	(10)
ROUTINGSTEP_ID	NUMBER	(10)
OPRN_ID	NUMBER	(10)
CUST_ID	NUMBER	(15)
SHIP_TO_SITE_ID	NUMBER
VENDOR_ID	NUMBER	(10)
BATCH_ID	NUMBER	(10)
ROUTINGSTEP_NO	NUMBER	(5)
ITEM_NUMBER	VARCHAR2	(32)	Yes
ITEM_DESCRIPTION	VARCHAR2	(70)	Yes
ITEM_UOM	VARCHAR2	(4)	Yes
ITEM_UOM2	VARCHAR2	(4)
DOC_TYPE	VARCHAR2	(4)
DOC_ID	NUMBER	(10)
DOCLINE_ID	NUMBER	(10)
CUST_SPECIFICATION	NUMBER	(5)
CUST_CERTIFICATION	NUMBER	(5)
VENDOR_SPECIFICATION	NUMBER	(5)
VENDOR_CERTIFICATION	NUMBER	(5)
TEXT_SPEC	VARCHAR2	(16)
TARGET_SPEC	NUMBER
MIN_SPEC	NUMBER
MAX_SPEC	NUMBER
SPEC_QCUNIT_CODE	VARCHAR2	(4)
FROM_DATE	DATE
TO_DATE	DATE
OUTACTION_CODE	VARCHAR2	(4)
OUTACTION_INTERVAL	NUMBER
PREFERENCE	NUMBER	(5)
PRINT_COA_SHIPPED	NUMBER	(5)
PRINT_COA_INVOICED	NUMBER	(5)
VENDOR_COA_REQUIRED	NUMBER	(5)
TEST_OPRN_ID	NUMBER	(10)
TEST_OPRN_LINE_ID	NUMBER	(10)
CUSTOMER_NO	VARCHAR2	(30)
CUSTOMER_NAME	VARCHAR2	(360)
VENDOR_NO	VARCHAR2	(32)
VENDOR_NAME	VARCHAR2	(40)
ACCEPT_ANYWAY	NUMBER	(5)	Yes
LOT_NO	VARCHAR2	(32)
SUBLOT_NO	VARCHAR2	(32)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes

Query Text

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


SELECT RESULT_DATE
,      RESULT
,      RESULTS_QCUNIT_CODE
,      ACCEPT
,      CERTI_OF_ANALYSIS
,      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.PMIBV_QCRESULT_V;

Dependencies

[top of page]

APPS.PMIBV_QCRESULT_V references the following:

APPS: HZ_CUST_ACCOUNTS_ALL; HZ_PARTIES; IC_ITEM_MST; IC_LOTS_MST; PMI_COST_ANALZ_PACK - show dependent code; PMI_SECURITY_PKG - show dependent code; PO_VEND_MST; QC_ASSY_TYP; QC_RSLT_MST; QC_SMPL_MST; QC_SPEC_MST; SY_ORGN_MST

APPS.PMIBV_QCRESULT_V is not referenced by any database object