[Home] [Help] [Dependency Information]
Object Name: | GME_BATCH_STEP_ITEMS_MIG |
---|---|
Object Type: | TABLE |
Owner: | GME |
FND Design Data: | GME.GME_BATCH_STEP_ITEMS_MIG |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GME_BATCH_STEP_ITEMS_MIG_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MAXIMUM_DELAY | NUMBER | The maximum delay in hours after the MTQ point | ||
MINIMUM_DELAY | NUMBER | The minimum delay in hours after the MTQ point | ||
MINIMUM_TRANSFER_QTY | NUMBER | The quantity based in the same UOM of the product that is being associated to the routing step | ||
MATERIAL_DETAIL_ID | NUMBER | (10) | Yes | Surrogate key to the batch line. |
BATCH_ID | NUMBER | (10) | Yes | Surrogate key to the batch |
BATCHSTEP_ID | NUMBER | (15) | Yes | Key to the batch step. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Columns | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Columns | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Columns |
CREATION_DATE | DATE | Yes | Standard WHO Columns | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Columns |
Cut, paste (and edit) the following text to query this object:
SELECT MAXIMUM_DELAY
, MINIMUM_DELAY
, MINIMUM_TRANSFER_QTY
, MATERIAL_DETAIL_ID
, BATCH_ID
, BATCHSTEP_ID
, TEXT_CODE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM GME.GME_BATCH_STEP_ITEMS_MIG;
GME.GME_BATCH_STEP_ITEMS_MIG does not reference any database object
GME.GME_BATCH_STEP_ITEMS_MIG is referenced by following:
|
|
|