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_SPECIFICATIONS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length
QUALITY_CONTROL_SPEC_ID	NUMBER	(10)
ASSAY_TYPE_ID	NUMBER	(15)
ORGANIZATION_CODE	VARCHAR2	(4)
WAREHOUSE_CODE	VARCHAR2	(4)
LOCATION	VARCHAR2	(16)
DOCUMENT_TYPE	VARCHAR2	(4)
VENDOR_SPECIFICATION	NUMBER	(5)
VENDOR_CERTIFICATION	NUMBER	(5)
CUSTOMER_SPECIFICATION	NUMBER	(5)
CUSTOMER_CERTIFICATION	NUMBER	(5)
ASSAY_CODE	VARCHAR2	(16)
TEXT_SPEC	VARCHAR2	(16)
MIN_SPEC	NUMBER
MAX_SPEC	NUMBER
TARGET_SPEC	NUMBER
QUALITY_CONTROL_UNIT_CODE	VARCHAR2	(4)
FROM_DATE	DATE
TO_DATE	DATE
OUT_OF_ACTION_CODE	VARCHAR2	(4)
OUT_OF_ACTION_INTERVAL	NUMBER
PREFERENCE	NUMBER	(5)
PRINT_COA_SHIPPED	NUMBER	(5)
PRINT_COA_INVOICED	NUMBER	(5)
VENDOR_COA_REQUIRED	VARCHAR2	(80)
DELETE_MARK	NUMBER	(5)
ROUTING_STEP_NUMBER	NUMBER	(5)
CUSTOMER_NUMBER	VARCHAR2	(30)
CUSTOMER_NAME	VARCHAR2	(360)
ITEM_NUMBER	VARCHAR2	(32)
ITEM_DESCRIPTION	VARCHAR2	(70)
VENDOR_ID	NUMBER	(10)
VENDOR_NUMBER	VARCHAR2	(32)
VENDOR_NAME	VARCHAR2	(40)
FORMULA_NUMBER	CHAR	(1)
FORMULA_VERSION	NUMBER
LOT_NUMBER	VARCHAR2	(32)
SUB_LOT_NUMBER	VARCHAR2	(32)
BATCH_NUMBER	CHAR	(1)
ROUTING_NUMBER	CHAR	(1)
ROUTING_VERSION	NUMBER
OPERATION_NUMBER	CHAR	(1)
OPERATION_VERSION	NUMBER
EFFECTIVE	VARCHAR2	(80)
CUSTOMER_ID	NUMBER	(15)
SHIP_TO_SITE_ID	NUMBER

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_NUMBER
,      FORMULA_VERSION
,      LOT_NUMBER
,      SUB_LOT_NUMBER
,      BATCH_NUMBER
,      ROUTING_NUMBER
,      ROUTING_VERSION
,      OPERATION_NUMBER
,      OPERATION_VERSION
,      EFFECTIVE
,      CUSTOMER_ID
,      SHIP_TO_SITE_ID
FROM APPS.PMIFV_QC_SPECIFICATIONS_V;

Dependencies

[top of page]

APPS.PMIFV_QC_SPECIFICATIONS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_CUST_ACCOUNTS_ALL; HZ_PARTIES; IC_ITEM_MST; IC_LOTS_MST; PO_VEND_MST; QC_SPEC_MST

APPS.PMIFV_QC_SPECIFICATIONS_V is not referenced by any database object