[Home] [Help] [Dependency Information]
Object Name: | WMS_CROSSDOCK_CRITERIA_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WMS.WMS_CROSSDOCK_CRITERIA_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view represents the MLS database entity WMS_CROSSDOCK_CRITERIA.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row indentifier | |
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 promise 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 | Supply scheduling method with dock appointment | |
DEMAND_SCHEDULE_METHOD | NUMBER | Yes | Demand scheduling method with dock appointment | |
CRITERION_NAME | VARCHAR2 | (80) | Yes | Name of crossdock criterion |
DESCRIPTION | VARCHAR2 | (240) | Description of crossdock criterion | |
UOM_INTEGRITY_FLAG | NUMBER | Yes | Disallow crossdocking of fractional quantities if checked |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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
, CRITERION_NAME
, DESCRIPTION
, UOM_INTEGRITY_FLAG
FROM APPS.WMS_CROSSDOCK_CRITERIA_VL;
|
|
|