Product: | WMS - Warehouse Management |
---|---|
Description: | This view represents the MLS database entity WMS_CROSSDOCK_CRITERIA. |
Implementation/DBA Data: | APPS.WMS_CROSSDOCK_CRITERIA_VL |
SELECT B.ROWID ROW_ID
, B.CRITERION_ID
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATE_LOGIN
, B.CRITERION_TYPE
, B.WINDOW_INTERVAL
, B.WINDOW_UOM
, B.BUFFER_INTERVAL
, B.BUFFER_UOM
, B.PROCESSING_INTERVAL
, B.PROCESSING_UOM
, B.PAST_DUE_INTERVAL
, B.PAST_DUE_UOM
, B.CROSSDOCK_GOAL
, B.PRIORITIZE_DOCUMENTS_FLAG
, B.ALLOW_SUPPLY_RESCHEDULE_FLAG
, B.ALLOW_DEMAND_RESCHEDULE_FLAG
, B.SUPPLY_SCHEDULE_METHOD
, B.DEMAND_SCHEDULE_METHOD
, T.CRITERION_NAME
, T.DESCRIPTION
, B.UOM_INTEGRITY_FLAG
FROM WMS_CROSSDOCK_CRITERIA_TL T
, WMS_CROSSDOCK_CRITERIA_B B
WHERE B.CRITERION_ID = T.CRITERION_ID
AND T.LANGUAGE = USERENV('LANG')