VIEW: APPS.MST_CONTINUOUS_MOVES_V

Source

View Text - Preformatted

SELECT P.PLAN_ID, P.COMPILE_DESIGNATOR PLAN_NAME, P.DESCRIPTION, CMT.ROWID ROW_ID, CMT.CM_TRIP_NUMBER, CMT.CONTINUOUS_MOVE_ID, CMT.CARRIER_ID, WC.FREIGHT_CODE CARRIER, CMT.SERVICE_LEVEL SERVICE, SUBSTR(MST_WB_UTIL.GET_MEANING ('WSH_SERVICE_LEVELS', CMT.SERVICE_LEVEL, 'WSH'),1,80) SERVICE_DESC, CMT.VEHICLE_TYPE_ID, MSI.CONCATENATED_SEGMENTS VEHICLE, CMT.TOTAL_TRANSPORTATION_COST, CMT.TOTAL_SAVING, MST_WB_UTIL.GET_CONT_MOVE_TOTAL_LOADS (CMT.PLAN_ID,CMT.CONTINUOUS_MOVE_ID) TOTAL_LOADS, MST_WB_UTIL.GET_CONT_MOVE_DISTANCE (CMT.PLAN_ID,CMT.CONTINUOUS_MOVE_ID) TOTAL_DISTANCE, P.DISTANCE_UOM, P.CURRENCY_UOM CURRENCY_UOM1, P.CURRENCY_UOM CURRENCY_UOM2, CMT.PLANNED_FLAG FIRM_STATUS, CMT.RELEASE_STATUS, SUBSTR(MST_WB_UTIL.GET_MEANING ('MST_CM_RELEASE_STATUS', CMT.RELEASE_STATUS, 'MFG'),1,80) RELEASE_STATUS_DESC, CMT.RELEASE_DATE RELEASED, fnd_date.date_to_chardt(CMT.RELEASE_DATE), CMT.SELECTED_FOR_RELEASE RELEASE, CMT.CHANGED_BY_USER, CMT.LOCKED_FOR_IMPACT FROM MST_PLANS P, MST_CM_TRIPS CMT, WSH_CARRIERS WC, MTL_SYSTEM_ITEMS_KFV MSI, FTE_VEHICLE_TYPES FVT WHERE P.PLAN_ID = CMT.PLAN_ID AND WC.CARRIER_ID = CMT.CARRIER_ID AND CMT.VEHICLE_TYPE_ID = FVT.VEHICLE_TYPE_ID AND MSI.INVENTORY_ITEM_ID = FVT.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = FVT.ORGANIZATION_ID

View Text - HTML Formatted

SELECT P.PLAN_ID
, P.COMPILE_DESIGNATOR PLAN_NAME
, P.DESCRIPTION
, CMT.ROWID ROW_ID
, CMT.CM_TRIP_NUMBER
, CMT.CONTINUOUS_MOVE_ID
, CMT.CARRIER_ID
, WC.FREIGHT_CODE CARRIER
, CMT.SERVICE_LEVEL SERVICE
, SUBSTR(MST_WB_UTIL.GET_MEANING ('WSH_SERVICE_LEVELS'
, CMT.SERVICE_LEVEL
, 'WSH')
, 1
, 80) SERVICE_DESC
, CMT.VEHICLE_TYPE_ID
, MSI.CONCATENATED_SEGMENTS VEHICLE
, CMT.TOTAL_TRANSPORTATION_COST
, CMT.TOTAL_SAVING
, MST_WB_UTIL.GET_CONT_MOVE_TOTAL_LOADS (CMT.PLAN_ID
, CMT.CONTINUOUS_MOVE_ID) TOTAL_LOADS
, MST_WB_UTIL.GET_CONT_MOVE_DISTANCE (CMT.PLAN_ID
, CMT.CONTINUOUS_MOVE_ID) TOTAL_DISTANCE
, P.DISTANCE_UOM
, P.CURRENCY_UOM CURRENCY_UOM1
, P.CURRENCY_UOM CURRENCY_UOM2
, CMT.PLANNED_FLAG FIRM_STATUS
, CMT.RELEASE_STATUS
, SUBSTR(MST_WB_UTIL.GET_MEANING ('MST_CM_RELEASE_STATUS'
, CMT.RELEASE_STATUS
, 'MFG')
, 1
, 80) RELEASE_STATUS_DESC
, CMT.RELEASE_DATE RELEASED
, FND_DATE.DATE_TO_CHARDT(CMT.RELEASE_DATE)
, CMT.SELECTED_FOR_RELEASE RELEASE
, CMT.CHANGED_BY_USER
, CMT.LOCKED_FOR_IMPACT
FROM MST_PLANS P
, MST_CM_TRIPS CMT
, WSH_CARRIERS WC
, MTL_SYSTEM_ITEMS_KFV MSI
, FTE_VEHICLE_TYPES FVT
WHERE P.PLAN_ID = CMT.PLAN_ID
AND WC.CARRIER_ID = CMT.CARRIER_ID
AND CMT.VEHICLE_TYPE_ID = FVT.VEHICLE_TYPE_ID
AND MSI.INVENTORY_ITEM_ID = FVT.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = FVT.ORGANIZATION_ID