VIEW: APPS.WMS_CROSSDOCK_CRITERIA_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')