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_ALL_SPEC_VRS_VL

Object Details

Object Name:	GMD_ALL_SPEC_VRS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.GMD_ALL_SPEC_VRS_VL
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	Comments
SPEC_VR_ID	NUMBER		Specification validity rule identifier; db-seq
SPEC_ID	NUMBER		Specification identifier
ORGANIZATION_ID	NUMBER		This is organization ID
ORGANIZATION_CODE	VARCHAR2	(3)
SPEC_TYPE	VARCHAR2	(1)
SPEC_NAME	VARCHAR2	(80)
SPEC_VERS	NUMBER	(10)
OWNER_ORGANIZATION_ID	NUMBER
OWNER_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
ITEM_NUMBER	VARCHAR2	(40)
DESCRIPTION	VARCHAR2	(240)
REVISION	VARCHAR2	(3)
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_ID	NUMBER
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)
CONTROL_LOT_ATTRIB_IND	VARCHAR2	(1)
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)
LOT_OPTIONAL_ON_SAMPLE	VARCHAR2	(1)
DELAYED_LOT_ENTRY	VARCHAR2	(1)
COA_TYPE	VARCHAR2	(1)
COA_AT_SHIP_IND	VARCHAR2	(1)
COA_AT_INVOICE_IND	VARCHAR2	(1)
COA_REQ_FROM_SUPL_IND	VARCHAR2	(1)
AUTO_SAMPLE_IND	VARCHAR2	(1)
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)
MATERIAL_DETAIL_ID	NUMBER

Query Text

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


SELECT SPEC_VR_ID
,      SPEC_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SPEC_TYPE
,      SPEC_NAME
,      SPEC_VERS
,      OWNER_ORGANIZATION_ID
,      OWNER_ID
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      DESCRIPTION
,      REVISION
,      GRADE_CODE
,      SPEC_STATUS
,      SPEC_STATUS_DESC
,      PARENT_LOT_NUMBER
,      LOT_NUMBER
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATOR
,      SPEC_VR_STATUS
,      SPEC_VR_STATUS_DESC
,      START_DATE
,      END_DATE
,      SAMPLING_PLAN_ID
,      SAMPLE_INV_TRANS_IND
,      CONTROL_LOT_ATTRIB_IND
,      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
,      LOT_OPTIONAL_ON_SAMPLE
,      DELAYED_LOT_ENTRY
,      COA_TYPE
,      COA_AT_SHIP_IND
,      COA_AT_INVOICE_IND
,      COA_REQ_FROM_SUPL_IND
,      AUTO_SAMPLE_IND
,      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
,      MATERIAL_DETAIL_ID
FROM APPS.GMD_ALL_SPEC_VRS_VL;