VIEW: APPS.MST_FTE_MOVES_V

Source

View Text - Preformatted

SELECT cm.MOVE_ID MOVE_ID ,cm.PLANNED_FLAG PLANNED_FLAG ,cm.LANE_ID LANE_ID ,l.carrier_id CARRIER_ID ,cm.SERVICE_LEVEL SERVICE_LEVEL ,MST_SNAPSHOT_TASK_UTIL.getCMVehicleType(MOVE_ID) VEHICLE_TYPE_ID ,cs.carrier_service_id CARRIER_SERVICE_ID ,to_number(NULL) START_LOCATION_ID ,to_number(NULL) END_LOCATION_ID ,to_date(NULL) START_DATE ,to_date(NULL) END_DATE ,to_number(NULL) TOTAL_TRANSPORTATION_COST ,to_number(NULL) TOTAL_SAVING ,cm.created_by created_by ,cm.last_updated_by last_updated_by FROM FTE_MOVES cm ,FTE_LANES l ,wsh_Carrier_services cs WHERE cm.MOVE_TYPE_CODE = 'CONTINUOUS' and cm.PLANNED_FLAG = 'Y' and cm.LANE_ID = l.lane_id and cs.carrier_id = l.carrier_id and cs.service_level = cm.SERVICE_LEVEL and l.MODE_OF_TRANSPORTATION_CODE = cs.MODE_OF_TRANSPORT

View Text - HTML Formatted

SELECT CM.MOVE_ID MOVE_ID
, CM.PLANNED_FLAG PLANNED_FLAG
, CM.LANE_ID LANE_ID
, L.CARRIER_ID CARRIER_ID
, CM.SERVICE_LEVEL SERVICE_LEVEL
, MST_SNAPSHOT_TASK_UTIL.GETCMVEHICLETYPE(MOVE_ID) VEHICLE_TYPE_ID
, CS.CARRIER_SERVICE_ID CARRIER_SERVICE_ID
, TO_NUMBER(NULL) START_LOCATION_ID
, TO_NUMBER(NULL) END_LOCATION_ID
, TO_DATE(NULL) START_DATE
, TO_DATE(NULL) END_DATE
, TO_NUMBER(NULL) TOTAL_TRANSPORTATION_COST
, TO_NUMBER(NULL) TOTAL_SAVING
, CM.CREATED_BY CREATED_BY
, CM.LAST_UPDATED_BY LAST_UPDATED_BY
FROM FTE_MOVES CM
, FTE_LANES L
, WSH_CARRIER_SERVICES CS
WHERE CM.MOVE_TYPE_CODE = 'CONTINUOUS'
AND CM.PLANNED_FLAG = 'Y'
AND CM.LANE_ID = L.LANE_ID
AND CS.CARRIER_ID = L.CARRIER_ID
AND CS.SERVICE_LEVEL = CM.SERVICE_LEVEL
AND L.MODE_OF_TRANSPORTATION_CODE = CS.MODE_OF_TRANSPORT