[Home] [Help] [Dependency Information]
Object Name: | WMS_CROSSDOCK_CRITERIA_B |
---|---|
Object Type: | TABLE |
Owner: | WMS |
FND Design Data: | WMS.WMS_CROSSDOCK_CRITERIA_B |
Subobject Name: | |
Status: | VALID |
WMS_CROSSDOCK_CRITERIA_B stores WMS Crossdock Criteria.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_CROSSDOCK_CRITERIA_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CRITERION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRITERION_ID | NUMBER | Yes | Criterion identifier | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
CRITERION_TYPE | NUMBER | Yes | Crossdock criterion type | |
WINDOW_INTERVAL | NUMBER | Yes | Interval of time for crossdock window | |
WINDOW_UOM | VARCHAR2 | (10) | Yes | Unit of measure for WINDOW_INTERVAL |
BUFFER_INTERVAL | NUMBER | Buffer time interval between end of crossdock window and start of order processing | ||
BUFFER_UOM | VARCHAR2 | (10) | Unit of measure for BUFFER_INTERVAL | |
PROCESSING_INTERVAL | NUMBER | Time required to process order | ||
PROCESSING_UOM | VARCHAR2 | (10) | Unit of measure for PROCESSING_INTERVAL | |
PAST_DUE_INTERVAL | NUMBER | Past due supply cutoff time | ||
PAST_DUE_UOM | VARCHAR2 | (10) | Unit of measure for PAST_DUE_INTERVAL | |
CROSSDOCK_GOAL | NUMBER | Yes | Prioritization method for eligible sources | |
PRIORITIZE_DOCUMENTS_FLAG | NUMBER | Yes | Order by source priority before crossdocking goal or vice versa | |
ALLOW_SUPPLY_RESCHEDULE_FLAG | NUMBER | Yes | Allow supply reschedule on promised date when no dock appointment | |
ALLOW_DEMAND_RESCHEDULE_FLAG | NUMBER | Yes | Allow demand reschedule on shipment date when no dock appointment | |
SUPPLY_SCHEDULE_METHOD | NUMBER | Yes | Scheduling method for supply with dock appointment | |
DEMAND_SCHEDULE_METHOD | NUMBER | Yes | Scheduling method for demand with dock appointment | |
UOM_INTEGRITY_FLAG | NUMBER | Yes | Disallow crossdocking of fractional quantities if checked |
Cut, paste (and edit) the following text to query this object:
SELECT CRITERION_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, CRITERION_TYPE
, WINDOW_INTERVAL
, WINDOW_UOM
, BUFFER_INTERVAL
, BUFFER_UOM
, PROCESSING_INTERVAL
, PROCESSING_UOM
, PAST_DUE_INTERVAL
, PAST_DUE_UOM
, CROSSDOCK_GOAL
, PRIORITIZE_DOCUMENTS_FLAG
, ALLOW_SUPPLY_RESCHEDULE_FLAG
, ALLOW_DEMAND_RESCHEDULE_FLAG
, SUPPLY_SCHEDULE_METHOD
, DEMAND_SCHEDULE_METHOD
, UOM_INTEGRITY_FLAG
FROM WMS.WMS_CROSSDOCK_CRITERIA_B;
WMS.WMS_CROSSDOCK_CRITERIA_B does not reference any database object
WMS.WMS_CROSSDOCK_CRITERIA_B is referenced by following:
|
|
|