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

TABLE: GMD.GMD_WIP_SPEC_VRS

Object Details
Object Name: GMD_WIP_SPEC_VRS
Object Type: TABLE
Owner: GMD
FND Design Data: TableGMD.GMD_WIP_SPEC_VRS
Subobject Name:
Status: VALID


OPM Work-in-Process Specification validity rules


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMD_WIP_SPEC_VRS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPEC_VR_ID
GMD_WIP_SPEC_VRS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPEC_ID
Columns
Name Datatype Length Mandatory Comments
SPEC_VR_ID NUMBER
Yes Specification validity rule identifier; db-seq
SPEC_ID NUMBER
Yes Specification identifier
ORGN_CODE VARCHAR2 (4)
Organization
BATCH_ID NUMBER

Batch Identification
RECIPE_ID NUMBER

Recipe Identification
RECIPE_NO VARCHAR2 (32)
Recipe number
RECIPE_VERSION NUMBER (5)
Recipe Version
FORMULA_ID NUMBER

Formula Identification
FORMULALINE_ID NUMBER

Formula Line
FORMULA_NO VARCHAR2 (32)
Formula Number
FORMULA_VERS NUMBER (5)
Formula Version
ROUTING_ID NUMBER

Routing Identification
ROUTING_NO VARCHAR2 (32)
Routing No
ROUTING_VERS NUMBER (5)
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 (5)
Operation Version
CHARGE NUMBER

Charges
SPEC_VR_STATUS NUMBER
Yes Specification Validity Rule
START_DATE DATE
Yes Start date
END_DATE DATE

End Date
SAMPLING_PLAN_ID NUMBER

Sampling Plan ID
SAMPLE_INV_TRANS_IND VARCHAR2 (1)
Indicates an inv trans is created for the sample amt.Y = Yes, Null = No
LOT_OPTIONAL_ON_SAMPLE VARCHAR2 (1)
Lot optional on sample
CONTROL_LOT_ATTRIB_IND VARCHAR2 (1)
A = Auto, W = WorkFlow Null = No
OUT_OF_SPEC_LOT_STATUS VARCHAR2 (4)
Outside specification lot status
IN_SPEC_LOT_STATUS VARCHAR2 (4)
In specification lot status
COA_TYPE VARCHAR2 (1)
Certificate of Analysis type
CONTROL_BATCH_STEP_IND VARCHAR2 (1)
Control batch step indicator
COA_AT_SHIP_IND VARCHAR2 (1)
Certificate of Analysis type
COA_AT_INVOICE_IND VARCHAR2 (1)
Certificate of Analysis invoice indicator
COA_REQ_FROM_SUPL_IND VARCHAR2 (1)
Certificate of Analysis from supplier
DELETE_MARK NUMBER (5) Yes Logical delete
TEXT_CODE NUMBER (10)
Edit Text
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure ID
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE16 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE17 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE18 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE19 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE20 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE21 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE22 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE23 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE24 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE25 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE26 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE27 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE28 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE29 VARCHAR2 (240)
Descriptive Flexfield column
ATTRIBUTE30 VARCHAR2 (240)
Descriptive Flexfield column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
AUTO_SAMPLE_IND VARCHAR2 (1)
Auto Sample Creation Indicator
DELAYED_LOT_ENTRY VARCHAR2 (1)
If this column is set to Yes then the lot/sublot columns for samples created with this spec vr may be entered when the final disposition is entered
ORGANIZATION_ID NUMBER

This is organization ID
OUT_OF_SPEC_LOT_STATUS_ID NUMBER

This is OUT OF spec lot status ID
IN_SPEC_LOT_STATUS_ID NUMBER

This is In spec lot status ID
ERECORD_SPEC_VR_ID NUMBER

Original Erec key for record this was created from
MIGRATED_IND NUMBER (1)
Indicates Status of the Migration of this table
MATERIAL_DETAIL_ID NUMBER (10)
'This is the material detail for batch
AUTO_COMPLETE_BATCH_STEP VARCHAR2 (1)
Auto Complete Batch Step Indicator
BATCH_FREQUENCY NUMBER

Batch Freuency
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
,      ORGN_CODE
,      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
,      SPEC_VR_STATUS
,      START_DATE
,      END_DATE
,      SAMPLING_PLAN_ID
,      SAMPLE_INV_TRANS_IND
,      LOT_OPTIONAL_ON_SAMPLE
,      CONTROL_LOT_ATTRIB_IND
,      OUT_OF_SPEC_LOT_STATUS
,      IN_SPEC_LOT_STATUS
,      COA_TYPE
,      CONTROL_BATCH_STEP_IND
,      COA_AT_SHIP_IND
,      COA_AT_INVOICE_IND
,      COA_REQ_FROM_SUPL_IND
,      DELETE_MARK
,      TEXT_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      AUTO_SAMPLE_IND
,      DELAYED_LOT_ENTRY
,      ORGANIZATION_ID
,      OUT_OF_SPEC_LOT_STATUS_ID
,      IN_SPEC_LOT_STATUS_ID
,      ERECORD_SPEC_VR_ID
,      MIGRATED_IND
,      MATERIAL_DETAIL_ID
,      AUTO_COMPLETE_BATCH_STEP
,      BATCH_FREQUENCY
,      DELAYED_LPN_ENTRY
FROM GMD.GMD_WIP_SPEC_VRS;

Dependencies

[top of page]

GMD.GMD_WIP_SPEC_VRS does not reference any database object

GMD.GMD_WIP_SPEC_VRS is referenced by following:

SchemaGMD
ViewGMD_WIP_SPEC_VRS#