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

TABLE: GMD.GMD_INVENTORY_SPEC_VRS

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


OPM Quality Inventory Specification Validity Rules


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMD_INVENTORY_SPEC_VRS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPEC_VR_ID
GMD_INVENTORY_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
LOT_ID NUMBER

Lot Identification
LOT_NO VARCHAR2 (32)
Lot Number
SUBLOT_NO VARCHAR2 (32)
Sublot
WHSE_CODE VARCHAR2 (4)
Warehouse
LOCATION VARCHAR2 (16)
Location
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
CONTROL_LOT_ATTRIB_IND VARCHAR2 (1)
A = Auto, W = WorkFlow Null = No
LOT_OPTIONAL_ON_SAMPLE VARCHAR2 (1)
Lot optional on sample
IN_SPEC_LOT_STATUS VARCHAR2 (4)
In specification lot status
OUT_OF_SPEC_LOT_STATUS VARCHAR2 (4)
Outside specification lot status
CONTROL_BATCH_STEP_IND VARCHAR2 (1)
Control batch step indicator
COA_TYPE VARCHAR2 (1)
Certificate of Analysis type
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
PARENT_LOT_NUMBER VARCHAR2 (80)
This is parent lot number
LOT_NUMBER VARCHAR2 (80)
This is lot number
SUBINVENTORY VARCHAR2 (10)
This is subinventory
LOCATOR_ID NUMBER

This is locator 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
Query Text

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


SELECT SPEC_VR_ID
,      SPEC_ID
,      ORGN_CODE
,      LOT_ID
,      LOT_NO
,      SUBLOT_NO
,      WHSE_CODE
,      LOCATION
,      SPEC_VR_STATUS
,      START_DATE
,      END_DATE
,      SAMPLING_PLAN_ID
,      SAMPLE_INV_TRANS_IND
,      CONTROL_LOT_ATTRIB_IND
,      LOT_OPTIONAL_ON_SAMPLE
,      IN_SPEC_LOT_STATUS
,      OUT_OF_SPEC_LOT_STATUS
,      CONTROL_BATCH_STEP_IND
,      COA_TYPE
,      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
,      PARENT_LOT_NUMBER
,      LOT_NUMBER
,      SUBINVENTORY
,      LOCATOR_ID
,      OUT_OF_SPEC_LOT_STATUS_ID
,      IN_SPEC_LOT_STATUS_ID
,      ERECORD_SPEC_VR_ID
,      MIGRATED_IND
FROM GMD.GMD_INVENTORY_SPEC_VRS;

Dependencies

[top of page]

GMD.GMD_INVENTORY_SPEC_VRS does not reference any database object

GMD.GMD_INVENTORY_SPEC_VRS is referenced by following:

SchemaAPPS
SynonymGMD_INVENTORY_SPEC_VRS