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

Object Details

Object Name:	GMD_QC_E_ALL_SPEC_VRS_DISP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.GMD_QC_E_ALL_SPEC_VRS_DISP_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SPEC_VR_ID	NUMBER
SPEC_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
SPEC_TYPE	VARCHAR2	(1)
SPEC_TYPE_DISP	VARCHAR2	(80)	Yes
SPEC_NAME	VARCHAR2	(80)
SPEC_VERS	NUMBER	(10)
INVENTORY_ITEM_ID	NUMBER
REVISION	VARCHAR2	(3)
DESCRIPTION	VARCHAR2	(240)
GRADE_CODE	VARCHAR2	(150)
SPEC_STATUS	NUMBER	(5)
SPEC_STATUS_DESC	VARCHAR2	(80)
PARENT_LOT_NUMBER	VARCHAR2	(80)
LOT_NUMBER	VARCHAR2	(80)
SUBINVENTORY	VARCHAR2	(10)
LOCATOR	VARCHAR2	(1)
SPEC_VR_STATUS	NUMBER
SPEC_VR_STATUS_DESC	VARCHAR2	(80)
START_DATE	DATE
END_DATE	DATE
SAMPLING_PLAN_ID	NUMBER
SAMPLE_INV_TRANS_IND	VARCHAR2	(1)
SAMPLE_INV_TRANS_IND_DISP	VARCHAR2	(80)
CONTROL_LOT_ATTRIB_IND	VARCHAR2	(1)
CONTROL_LOT_ATTRIB_IND_DISP	VARCHAR2	(80)
OUT_OF_SPEC_LOT_STATUS_ID	NUMBER
OUT_OF_SPEC_LOT_STATUS_CODE	VARCHAR2	(80)
IN_SPEC_LOT_STATUS_ID	NUMBER
IN_SPEC_LOT_STATUS_CODE	VARCHAR2	(80)
CONTROL_BATCH_STEP_IND	VARCHAR2	(1)
CONTROL_BATCH_STEP_IND_DISP	VARCHAR2	(80)
LOT_OPTIONAL_ON_SAMPLE	VARCHAR2	(1)
DELAYED_LOT_ENTRY	VARCHAR2	(1)
COA_TYPE	VARCHAR2	(1)
COA_TYPE_DISP	VARCHAR2	(80)
COA_AT_SHIP_IND	VARCHAR2	(1)
COA_AT_SHIP_IND_DISP	VARCHAR2	(80)
COA_AT_INVOICE_IND	VARCHAR2	(1)
COA_AT_INVOICE_IND_DISP	VARCHAR2	(80)
COA_REQ_FROM_SUPL_IND	VARCHAR2	(1)
COA_REQ_FROM_SUPL_IND_DISP	VARCHAR2	(80)
AUTO_SAMPLE_IND	VARCHAR2	(1)
AUTO_SAMPLE_IND_DISP	VARCHAR2	(80)
BATCH_ID	NUMBER
RECIPE_ID	NUMBER
RECIPE_NO	VARCHAR2	(32)
RECIPE_VERSION	NUMBER
FORMULA_ID	NUMBER
FORMULALINE_ID	NUMBER
FORMULA_NO	VARCHAR2	(32)
FORMULA_VERS	NUMBER
ROUTING_ID	NUMBER
ROUTING_NO	VARCHAR2	(32)
ROUTING_VERS	NUMBER
STEP_ID	NUMBER
STEP_NO	NUMBER
OPRN_ID	NUMBER
OPRN_NO	VARCHAR2	(16)
OPRN_VERS	NUMBER
CHARGE	NUMBER
CUST_ID	NUMBER
ORDER_ID	NUMBER
ORDER_LINE	NUMBER
ORDER_LINE_ID	NUMBER
SHIP_TO_SITE_ID	NUMBER
ORG_ID	NUMBER
SUPPLIER_ID	NUMBER
SUPPLIER_SITE_ID	NUMBER
PO_HEADER_ID	NUMBER
PO_LINE_ID	NUMBER
RESOURCES	VARCHAR2	(16)
RESOURCE_INSTANCE_ID	NUMBER
DELETE_MARK	NUMBER	(5)
TEXT_CODE	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
DELAYED_LPN_ENTRY	VARCHAR2	(1)		This is the column for the delayed License Plate Number entry indicator

Query Text

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


SELECT SPEC_VR_ID
,      SPEC_ID
,      ORGANIZATION_CODE
,      SPEC_TYPE
,      SPEC_TYPE_DISP
,      SPEC_NAME
,      SPEC_VERS
,      INVENTORY_ITEM_ID
,      REVISION
,      DESCRIPTION
,      GRADE_CODE
,      SPEC_STATUS
,      SPEC_STATUS_DESC
,      PARENT_LOT_NUMBER
,      LOT_NUMBER
,      SUBINVENTORY
,      LOCATOR
,      SPEC_VR_STATUS
,      SPEC_VR_STATUS_DESC
,      START_DATE
,      END_DATE
,      SAMPLING_PLAN_ID
,      SAMPLE_INV_TRANS_IND
,      SAMPLE_INV_TRANS_IND_DISP
,      CONTROL_LOT_ATTRIB_IND
,      CONTROL_LOT_ATTRIB_IND_DISP
,      OUT_OF_SPEC_LOT_STATUS_ID
,      OUT_OF_SPEC_LOT_STATUS_CODE
,      IN_SPEC_LOT_STATUS_ID
,      IN_SPEC_LOT_STATUS_CODE
,      CONTROL_BATCH_STEP_IND
,      CONTROL_BATCH_STEP_IND_DISP
,      LOT_OPTIONAL_ON_SAMPLE
,      DELAYED_LOT_ENTRY
,      COA_TYPE
,      COA_TYPE_DISP
,      COA_AT_SHIP_IND
,      COA_AT_SHIP_IND_DISP
,      COA_AT_INVOICE_IND
,      COA_AT_INVOICE_IND_DISP
,      COA_REQ_FROM_SUPL_IND
,      COA_REQ_FROM_SUPL_IND_DISP
,      AUTO_SAMPLE_IND
,      AUTO_SAMPLE_IND_DISP
,      BATCH_ID
,      RECIPE_ID
,      RECIPE_NO
,      RECIPE_VERSION
,      FORMULA_ID
,      FORMULALINE_ID
,      FORMULA_NO
,      FORMULA_VERS
,      ROUTING_ID
,      ROUTING_NO
,      ROUTING_VERS
,      STEP_ID
,      STEP_NO
,      OPRN_ID
,      OPRN_NO
,      OPRN_VERS
,      CHARGE
,      CUST_ID
,      ORDER_ID
,      ORDER_LINE
,      ORDER_LINE_ID
,      SHIP_TO_SITE_ID
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      RESOURCES
,      RESOURCE_INSTANCE_ID
,      DELETE_MARK
,      TEXT_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DELAYED_LPN_ENTRY
FROM APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V;

Dependencies

[top of page]

APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V references the following:

APPS: FND_LOOKUP_VALUES_VL; GMD_ALL_SPEC_VRS

APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V is not referenced by any database object