[Home] [Help] [Dependency Information]
Object Name: | GMO_DISPENSE_CONFIG |
---|---|
Object Type: | TABLE |
Owner: | GMO |
FND Design Data: | GMO.GMO_DISPENSE_CONFIG |
Subobject Name: | |
Status: | VALID |
GMO Dispense Configuration
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMO_DISPENSE_CONFIG_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CONFIG_ID |
GMO_DISPENSE_CONFIG_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ORGANIZATION_ID RECIPE_ID START_DATE END_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONFIG_ID | NUMBER | (15) | Yes | Configuration ID |
INVENTORY_ITEM_ID | NUMBER | (10) | Yes | Inventory Item ID |
ORGANIZATION_ID | NUMBER | Organization ID | ||
RECIPE_ID | NUMBER | Recipe ID | ||
DISPENSE_UOM | VARCHAR2 | (4) | Yes | Dispense UOM |
TOLERANCE_TYPE | VARCHAR2 | (7) | Tolerance Type | |
HIGH_TOLERANCE | NUMBER | (15) | Higher Tolerance | |
LOW_TOLERANCE | NUMBER | (15) | Low Tolerance | |
DISPENSE_REQUIRED_FLAG | VARCHAR2 | (1) | Dispense Required Flag | |
ERECORD_ID | NUMBER | E-record ID | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
END_DATE | DATE | 'This is the start date when the dispense setup configuration becomes active.' | ||
START_DATE | DATE | Yes | 'This is the end date when the dispense setup configuration becomes inactive.' | |
SECURECODE_REQUIRED_FLAG | VARCHAR2 | (1) | This flag is to identify Security Tag information Required or Not | |
DISPENSE_EXPIRATION_FENCE | VARCHAR2 | (10) | Dispense Expiration Time Fence | |
LEAD_TIME | VARCHAR2 | (10) | Leadtime Required to Dispense the Item (Not Used) |
Cut, paste (and edit) the following text to query this object:
SELECT CONFIG_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, RECIPE_ID
, DISPENSE_UOM
, TOLERANCE_TYPE
, HIGH_TOLERANCE
, LOW_TOLERANCE
, DISPENSE_REQUIRED_FLAG
, ERECORD_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, END_DATE
, START_DATE
, SECURECODE_REQUIRED_FLAG
, DISPENSE_EXPIRATION_FENCE
, LEAD_TIME
FROM GMO.GMO_DISPENSE_CONFIG;
GMO.GMO_DISPENSE_CONFIG does not reference any database object
GMO.GMO_DISPENSE_CONFIG is referenced by following:
|
|
|