[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

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

FND_LOOKUP_VALUES_VL

GMD_ALL_SPEC_VRS

APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V is not referenced by any database object