VIEW: APPS.MST_CARRIER_DETAILS_V

Source

View Text - Preformatted

SELECT MP.PLAN_ID, WLO.OWNER_PARTY_ID CARRIER_ID, HZP.PARTY_NAME CARRIER_NAME, MP.COMPILE_DESIGNATOR , MP.DESCRIPTION , substr(MST_AGG_PKG.get_total_trips_carrier (MP.PLAN_ID, WLO.OWNER_PARTY_ID),1,80) LOAD_COUNT_STR, MST_AGG_PKG.get_total_cost_carrier (MP.PLAN_ID, WLO.OWNER_PARTY_ID) TOTAL_COST, MST_AGG_PKG.get_carrier_weight (MP.PLAN_ID, WLO.OWNER_PARTY_ID ) TOTAL_WEIGHT, MST_AGG_PKG.get_carrier_volume (MP.PLAN_ID, WLO.OWNER_PARTY_ID ) TOTAL_CUBE, MST_AGG_PKG.get_carrier_pallets (MP.PLAN_ID, WLO.OWNER_PARTY_ID) TOTAL_PALLETS, MST_AGG_PKG.get_carrier_pieces (MP.PLAN_ID, WLO.OWNER_PARTY_ID) TOTAL_PIECES, MST_AGG_PKG.get_carrier_orders (MP.PLAN_ID, WLO.OWNER_PARTY_ID) TOTAL_ORDERS, MP.CURRENCY_UOM, MP.WEIGHT_UOM, MP.VOLUME_UOM FROM MST_PLANS MP, WSH_LOCATIONS WL, wsh_location_owners wlo, HZ_PARTIES HZP WHERE WL.WSH_LOCATION_ID = WLO.WSH_LOCATION_ID AND HZP.PARTY_ID = WLO.OWNER_PARTY_ID AND WLO.OWNER_TYPE = 3 AND WLO.OWNER_PARTY_ID IN (SELECT T.CARRIER_ID FROM MST_TRIPS T WHERE T.PLAN_ID = MP.PLAN_ID)

View Text - HTML Formatted

SELECT MP.PLAN_ID
, WLO.OWNER_PARTY_ID CARRIER_ID
, HZP.PARTY_NAME CARRIER_NAME
, MP.COMPILE_DESIGNATOR
, MP.DESCRIPTION
, SUBSTR(MST_AGG_PKG.GET_TOTAL_TRIPS_CARRIER (MP.PLAN_ID
, WLO.OWNER_PARTY_ID)
, 1
, 80) LOAD_COUNT_STR
, MST_AGG_PKG.GET_TOTAL_COST_CARRIER (MP.PLAN_ID
, WLO.OWNER_PARTY_ID) TOTAL_COST
, MST_AGG_PKG.GET_CARRIER_WEIGHT (MP.PLAN_ID
, WLO.OWNER_PARTY_ID ) TOTAL_WEIGHT
, MST_AGG_PKG.GET_CARRIER_VOLUME (MP.PLAN_ID
, WLO.OWNER_PARTY_ID ) TOTAL_CUBE
, MST_AGG_PKG.GET_CARRIER_PALLETS (MP.PLAN_ID
, WLO.OWNER_PARTY_ID) TOTAL_PALLETS
, MST_AGG_PKG.GET_CARRIER_PIECES (MP.PLAN_ID
, WLO.OWNER_PARTY_ID) TOTAL_PIECES
, MST_AGG_PKG.GET_CARRIER_ORDERS (MP.PLAN_ID
, WLO.OWNER_PARTY_ID) TOTAL_ORDERS
, MP.CURRENCY_UOM
, MP.WEIGHT_UOM
, MP.VOLUME_UOM
FROM MST_PLANS MP
, WSH_LOCATIONS WL
, WSH_LOCATION_OWNERS WLO
, HZ_PARTIES HZP
WHERE WL.WSH_LOCATION_ID = WLO.WSH_LOCATION_ID
AND HZP.PARTY_ID = WLO.OWNER_PARTY_ID
AND WLO.OWNER_TYPE = 3
AND WLO.OWNER_PARTY_ID IN (SELECT T.CARRIER_ID
FROM MST_TRIPS T
WHERE T.PLAN_ID = MP.PLAN_ID)