DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GMD_COM_SPEC_VRS_VL

Object Details
Object Name: GMD_COM_SPEC_VRS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMD.GMD_COM_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 Mandatory Comments
SPEC_VR_ID NUMBER

Specification validity rule Identification
SPEC_ID NUMBER

Specification Identification
ORGANIZATION_ID NUMBER

Organization Identification
SPEC_TYPE VARCHAR2 (1)
Specification type internal for view
PARENT_LOT_NUMBER VARCHAR2 (80)
Parent Lot Number
LOT_NUMBER VARCHAR2 (80)
Lot Number
SUBINVENTORY VARCHAR2 (10)
Subinventory
LOCATOR_ID NUMBER

Locator Identification
SPEC_VR_STATUS NUMBER

Specification validity rule status
START_DATE DATE

Start Date
END_DATE DATE

End Date
SAMPLING_PLAN_ID NUMBER

Sampling Plan Identification
SAMPLE_INV_TRANS_IND VARCHAR2 (1)
Indicates an inv trans is created for the sample amt.Y = Yes, Null = No
CONTROL_LOT_ATTRIB_IND VARCHAR2 (1)
A = Auto, W = WorkFlow Null = No
OUT_OF_SPEC_LOT_STATUS_ID NUMBER

Outside specification lot status Identification
IN_SPEC_LOT_STATUS_ID NUMBER

In specification lot status Identification
CONTROL_BATCH_STEP_IND VARCHAR2 (1)
Control batch step indicator
LOT_OPTIONAL_ON_SAMPLE VARCHAR2 (1)
Lot optional on sample
DELAYED_LOT_ENTRY VARCHAR2 (1)
If this column is set to Yes then the parent_lot/lot columns for samples created with this spec vr may be entered when the final disposition is entered
COA_TYPE VARCHAR2 (1)
Certificate of Analysis type
COA_AT_SHIP_IND VARCHAR2 (1)
Certificate of Analysis shipment indicator
COA_AT_INVOICE_IND VARCHAR2 (1)
Certificate of Analysis invoice indicator
COA_REQ_FROM_SUPL_IND VARCHAR2 (1)
Certificate of Analysis from supplier
AUTO_SAMPLE_IND VARCHAR2 (1)
Auto Sample Creation Indicator
BATCH_ID NUMBER

Batch Identification
RECIPE_ID NUMBER

Recipe Identification
RECIPE_NO VARCHAR2 (32)
Recipe Number
RECIPE_VERSION NUMBER

Recipe Version
FORMULA_ID NUMBER

Formula Identification
FORMULALINE_ID NUMBER

Formula Line
FORMULA_NO VARCHAR2 (32)
Formula Number
FORMULA_VERS NUMBER

Formula Version
ROUTING_ID NUMBER

Routing Identification
ROUTING_NO VARCHAR2 (32)
Routing No
ROUTING_VERS NUMBER

Routing Version
STEP_ID NUMBER

Step Identification
STEP_NO NUMBER

Step Number
OPRN_ID NUMBER

Operation Identification
OPRN_NO VARCHAR2 (16)
Operation Number
OPRN_VERS NUMBER

Operation Version
CHARGE NUMBER

Charges
CUST_ID NUMBER

Customer Identification
ORDER_ID NUMBER

Order Identification
ORDER_LINE NUMBER

Order Line
ORDER_LINE_ID NUMBER

Order Line Identification
SHIP_TO_SITE_ID NUMBER

Customer Location
ORG_ID NUMBER

Operating Unit
SUPPLIER_ID NUMBER

Supplier Identification
SUPPLIER_SITE_ID NUMBER

Supplier Site Identification
PO_HEADER_ID NUMBER

Purchase Order Number
PO_LINE_ID NUMBER

Purchase Order Line identification
RESOURCES VARCHAR2 (16)
Resources
RESOURCE_INSTANCE_ID NUMBER

Resource Instance ID
DELETE_MARK NUMBER (5)
Logical Delete
TEXT_CODE NUMBER

Text
CREATION_DATE DATE

Standard WHO Column
CREATED_BY NUMBER (15)
Standard WHO Column
LAST_UPDATED_BY NUMBER (15)
Standard WHO Column
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
MATERIAL_DETAIL_ID NUMBER

Material Detail id
Query Text

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


SELECT SPEC_VR_ID
,      SPEC_ID
,      ORGANIZATION_ID
,      SPEC_TYPE
,      PARENT_LOT_NUMBER
,      LOT_NUMBER
,      SUBINVENTORY
,      LOCATOR_ID
,      SPEC_VR_STATUS
,      START_DATE
,      END_DATE
,      SAMPLING_PLAN_ID
,      SAMPLE_INV_TRANS_IND
,      CONTROL_LOT_ATTRIB_IND
,      OUT_OF_SPEC_LOT_STATUS_ID
,      IN_SPEC_LOT_STATUS_ID
,      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_COM_SPEC_VRS_VL;

Dependencies

[top of page]

APPS.GMD_COM_SPEC_VRS_VL references the following:

SchemaAPPS
SynonymGMD_CUSTOMER_SPEC_VRS
SynonymGMD_INVENTORY_SPEC_VRS
SynonymGMD_MONITORING_SPEC_VRS
SynonymGMD_STABILITY_SPEC_VRS
SynonymGMD_SUPPLIER_SPEC_VRS
SynonymGMD_WIP_SPEC_VRS
APPS.GMD_COM_SPEC_VRS_VL is referenced by following:

SchemaAPPS
Package BodyGMD_COA_DATA_OM_NEW - show dependent code
Package BodyGMD_QMSED - show dependent code
Package BodyGMD_QMSMC - show dependent code
Package BodyGMD_RESULTS_GRP - show dependent code