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

TABLE: GMD.GMD_SAMPLING_EVENTS

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


OPM Quality Sampling Event


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMD_SAMPLING_EVENTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSAMPLING_EVENT_ID
Columns
Name Datatype Length Mandatory Comments
RECEIPT_ID NUMBER

Receipt Identification
PO_HEADER_ID NUMBER

Purchase Order Header Identification
SAMPLING_EVENT_ID NUMBER
Yes Sampling Event Identifier
ORIGINAL_SPEC_VR_ID NUMBER

Original Specification Validity Rule Identification
DISPOSITION VARCHAR2 (3) Yes This column contains final result value
SAMPLE_REQ_CNT NUMBER

Required number of sample to be taken
SAMPLE_TAKEN_CNT NUMBER

Current number of samples taken
SAMPLING_PLAN_ID NUMBER

Sampling Plan Identification
EVENT_TYPE_CODE VARCHAR2 (1)
Identifies the event triggering a sample to be taken, ex. Batch, Lot expiration
EVENT_ID NUMBER

Identifier of event triggering a sample to be taken.
SOURCE VARCHAR2 (1) Yes Valid values C, S, W, I, R (customer, supplier, WIP, inv, receiving)
ITEM_ID NUMBER

Item Identification
LOT_ID NUMBER

Lot Identifier
LOT_NO VARCHAR2 (32)
Lot Number
SUBLOT_NO VARCHAR2 (32)
Sublot Number
WHSE_CODE VARCHAR2 (4)
Warehouse
LOCATION VARCHAR2 (16)
Location
BATCH_ID NUMBER

Batch Identifier
RECIPE_ID NUMBER

Recipe Identifier
FORMULA_ID NUMBER

Formula Identifier
FORMULALINE_ID NUMBER

Formula Line Identifier
ROUTING_ID NUMBER

Routing Identifier
OPRN_ID NUMBER

Operation Identifier
CHARGE NUMBER

Charge
CUST_ID NUMBER

Customer Identifier
ORDER_ID NUMBER

Order Identifier
ORDER_LINE_ID NUMBER

Order Line Identifier
ORG_ID NUMBER

Organization Identifier
SUPPLIER_ID NUMBER

Supplier Identification
PO_LINE_ID NUMBER

Purchase Line Identifier
RECEIPT_LINE_ID NUMBER

Recipt Line Identifier
SUPPLIER_LOT_NO VARCHAR2 (32)
Supplier Lot Number
COMPLETE_IND VARCHAR2 (1)
Indicates if all samples for this instance of a specification are complete
SAMPLE_ID_TO_EVALUATE NUMBER

Sample Identifier to evaluate
COMPOSITE_ID_TO_EVALUATE NUMBER

Composite Identifier to evaluate
TEXT_CODE NUMBER (10)
Edit text code
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
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
SHIP_TO_SITE_ID NUMBER

Ship to site Identification
STEP_ID NUMBER

Step Identification
STEP_NO NUMBER

Routing Step Number
LOT_RETEST_IND VARCHAR2 (1)
Lot Retest Indicator
RECOMPOSITE_IND VARCHAR2 (1)
Indicates whether the sampling event needs to be recomposited.
SAMPLE_ACTIVE_CNT NUMBER

Number of active samples taken, samples not marked for purge, not canceled.
INSTANCE_ID NUMBER (32)
This is the resource instance being monitored
RESOURCES VARCHAR2 (16)
This is the resource being monitored
SAMPLE_TYPE VARCHAR2 (2) Yes This refers to whether a sample is an Item or Monitoring sample type
TIME_POINT_ID NUMBER (32)
This is time the sample is expected to remain within its specification
VARIANT_ID NUMBER (32)
This is the storage condition defined by a unique combination of the stability study's storage condition, test interval plan and package
ORGN_CODE VARCHAR2 (4)
This is the organization that owns the Sampling Event
ARCHIVED_TAKEN NUMBER

No of Archive samples taken for the sampling event
RESERVED_TAKEN NUMBER

No of Reserved samples taken for the sampling event
INVENTORY_ITEM_ID NUMBER

Item id
LOCATOR_ID NUMBER

Locator
LOT_NUMBER VARCHAR2 (80)
Lot
ORGANIZATION_ID NUMBER

Sample Organization
PARENT_LOT_NUMBER VARCHAR2 (80)
Parent Lot
REVISION VARCHAR2 (3)
Item Revision
SUBINVENTORY VARCHAR2 (10)
Subinventory
MIGRATED_IND NUMBER (1)
Indicates Status of the Migration of this table
PLAN_ID NUMBER (10)
This is part of the key for QA records for Receiving Inspection
COLLECTION_ID NUMBER (10)
This is part of the key for QA records for Receiving Inspection
OCCURRENCE NUMBER (10)
This is part of the key for QA records for Receiving Inspection
MATERIAL_DETAIL_ID NUMBER (10)
This is the material detail for batch
LPN_ID NUMBER

This is the column for the License Plate Number id
Query Text

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


SELECT RECEIPT_ID
,      PO_HEADER_ID
,      SAMPLING_EVENT_ID
,      ORIGINAL_SPEC_VR_ID
,      DISPOSITION
,      SAMPLE_REQ_CNT
,      SAMPLE_TAKEN_CNT
,      SAMPLING_PLAN_ID
,      EVENT_TYPE_CODE
,      EVENT_ID
,      SOURCE
,      ITEM_ID
,      LOT_ID
,      LOT_NO
,      SUBLOT_NO
,      WHSE_CODE
,      LOCATION
,      BATCH_ID
,      RECIPE_ID
,      FORMULA_ID
,      FORMULALINE_ID
,      ROUTING_ID
,      OPRN_ID
,      CHARGE
,      CUST_ID
,      ORDER_ID
,      ORDER_LINE_ID
,      ORG_ID
,      SUPPLIER_ID
,      PO_LINE_ID
,      RECEIPT_LINE_ID
,      SUPPLIER_LOT_NO
,      COMPLETE_IND
,      SAMPLE_ID_TO_EVALUATE
,      COMPOSITE_ID_TO_EVALUATE
,      TEXT_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SUPPLIER_SITE_ID
,      SHIP_TO_SITE_ID
,      STEP_ID
,      STEP_NO
,      LOT_RETEST_IND
,      RECOMPOSITE_IND
,      SAMPLE_ACTIVE_CNT
,      INSTANCE_ID
,      RESOURCES
,      SAMPLE_TYPE
,      TIME_POINT_ID
,      VARIANT_ID
,      ORGN_CODE
,      ARCHIVED_TAKEN
,      RESERVED_TAKEN
,      INVENTORY_ITEM_ID
,      LOCATOR_ID
,      LOT_NUMBER
,      ORGANIZATION_ID
,      PARENT_LOT_NUMBER
,      REVISION
,      SUBINVENTORY
,      MIGRATED_IND
,      PLAN_ID
,      COLLECTION_ID
,      OCCURRENCE
,      MATERIAL_DETAIL_ID
,      LPN_ID
FROM GMD.GMD_SAMPLING_EVENTS;

Dependencies

[top of page]

GMD.GMD_SAMPLING_EVENTS does not reference any database object

GMD.GMD_SAMPLING_EVENTS is referenced by following:

SchemaGMD
ViewGMD_SAMPLING_EVENTS#