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_RESULTS_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Comments
ORGANIZATION_CODE	VARCHAR2	(4)	OPM Organization Code
WAREHOUSE_CODE	VARCHAR2	(4)	OPM Warehouse Code
DOCUMENT_TYPE	VARCHAR2	(4)	Document Type
RESULT_DATE	DATE		Result Date
TEXT_RESULT	VARCHAR2	(16)	Text Result
NUM_RESULT	NUMBER		Numeric Result
ACCEPT_ANYWAY	VARCHAR2	(80)	Accept Anyway
FINAL_MARK	VARCHAR2	(80)	Final Mark
TEST_PROVIDER_CODE	VARCHAR2	(8)	Test Provider
LOCATION	VARCHAR2	(16)	Location
DELETE_MARK	NUMBER	(5)	Delete mark used for logical deletion in OPM
LAST_UPDATE_DATE	DATE		ROW WHO Column
VENDOR_SPECIFICATION	NUMBER		Vendor Specification
CUSTOMER_SPECIFICATION	NUMBER		Customer Specification
ASSAY_CODE	VARCHAR2	(16)	Assay Code
TEXT_SPEC	VARCHAR2	(16)	Text Spec
MIN_SPEC	NUMBER		MIN value allowed for Spec
MAX_SPEC	NUMBER		MAX value allowed for Spec
TARGET_SPEC	NUMBER		Target Sepc
QUALITY_CONTROL_UNIT_CODE	VARCHAR2	(4)	Quality Control Unit Code
FROM_DATE	DATE		From Date
CUSTOMER_NUMBER	VARCHAR2	(30)	Customer Number
CUSTOMER_NAME	VARCHAR2	(360)	Customer Name
VENDOR_NO	VARCHAR2	(32)	Vendor Number
VENDOR_NAME	VARCHAR2	(40)	Vendor Name
QUALITY_CONTROL_SPEC_ID	NUMBER		Quality Control Specification ID
ITEM_NUMBER	VARCHAR2	(32)	Item number
ITEM_DESCRIPTION	VARCHAR2	(70)	Item Description
LOT_NUMBER	VARCHAR2	(32)	Lot Number
SUB_LOT_NUMBER	VARCHAR2	(32)	Sub Lot Number
SAMPLE_NUMBER	VARCHAR2	(32)	Sample Number
BATCH_NUMBER	VARCHAR2	(32)	Production Batch Number
FORMULA_NUMBER	VARCHAR2	(32)	Formula Number
FORMULA_VERSION	NUMBER		Formula Version
ROUTING_NUMBER	VARCHAR2	(32)	Routing Number
ROUTING_VERSION	NUMBER	(5)	Routing Version
OPERATION_NUMBER	VARCHAR2	(16)	Operation Number
OPERATION_VERSION	NUMBER	(5)	Operation Version
ROUTING_STEP_NUMBER	NUMBER	(5)	Routing Step Number
CUSTOMER_ID	NUMBER	(15)	Customer ID
SHIP_TO_SITE_ID	NUMBER		Ship to Site ID

Query Text

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


SELECT ORGANIZATION_CODE
,      WAREHOUSE_CODE
,      DOCUMENT_TYPE
,      RESULT_DATE
,      TEXT_RESULT
,      NUM_RESULT
,      ACCEPT_ANYWAY
,      FINAL_MARK
,      TEST_PROVIDER_CODE
,      LOCATION
,      DELETE_MARK
,      LAST_UPDATE_DATE
,      VENDOR_SPECIFICATION
,      CUSTOMER_SPECIFICATION
,      ASSAY_CODE
,      TEXT_SPEC
,      MIN_SPEC
,      MAX_SPEC
,      TARGET_SPEC
,      QUALITY_CONTROL_UNIT_CODE
,      FROM_DATE
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      VENDOR_NO
,      VENDOR_NAME
,      QUALITY_CONTROL_SPEC_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      LOT_NUMBER
,      SUB_LOT_NUMBER
,      SAMPLE_NUMBER
,      BATCH_NUMBER
,      FORMULA_NUMBER
,      FORMULA_VERSION
,      ROUTING_NUMBER
,      ROUTING_VERSION
,      OPERATION_NUMBER
,      OPERATION_VERSION
,      ROUTING_STEP_NUMBER
,      CUSTOMER_ID
,      SHIP_TO_SITE_ID
FROM APPS.PMIFV_QC_RESULTS_V;

Dependencies

[top of page]

APPS.PMIFV_QC_RESULTS_V references the following:

APPS: FM_FORM_MST; FM_OPRN_MST; FM_ROUT_HDR; FND_GLOBAL - show dependent code; FND_LOOKUPS; GME_BATCH_HEADER; HZ_CUST_ACCOUNTS_ALL; HZ_PARTIES; IC_ITEM_MST; IC_LOTS_MST; PO_VEND_MST; QC_ASSY_TYP; QC_RSLT_MST; QC_SMPL_MST; QC_SPEC_MST

APPS.PMIFV_QC_RESULTS_V is not referenced by any database object