VIEW: APPS.MST_CARRIER_FACILITIES_V

Source

View Text - Preformatted

SELECT WLO.OWNER_PARTY_ID CARRIER_ID, MP.PLAN_ID , MP.COMPILE_DESIGNATOR , MP.DESCRIPTION , WL.WSH_LOCATION_ID , WL.LOCATION_SOURCE_CODE, SUBSTR(MST_WB_UTIL.GET_NAME (WL.WSH_LOCATION_ID), 1,80) COMPANY, WL.ADDRESS1 ADDRESS, WL.ADDRESS2, WL.ADDRESS3, WL.ADDRESS4, WL.CITY, WL.STATE, WL.COUNTY, WL.COUNTRY, WL.PROVINCE, WL.POSTAL_CODE , MST_WB_UTIL.GET_CONTACT_NAME(FLP.FACILITY_CONTACT_ID) CONTACT, MST_WB_UTIL.GET_PHONE_NUMBER(FLP.FACILITY_CONTACT_ID) PHONE, FLP.FACILITY_ID, FLP.FACILITY_CODE , FLP.DESCRIPTION FACILITY_DESCRIPTION, MST_AGG_PKG.get_total_weight_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'L', NULL) TOTAL_WEIGHT_LOAD, MST_AGG_PKG.get_total_Cube_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'L', NULL) TOTAL_CUBE_LOAD, MST_AGG_PKG.get_tot_Pal_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'L', NULL) TOTAL_PALLETS_LOAD, MST_AGG_PKG.get_tot_Pieces_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'L', NULL) TOTAL_PIECES_LOAD, MST_AGG_PKG.get_tot_Orders_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'L', NULL) TOTAL_ORDERS_LOAD, MST_AGG_PKG.get_direct_tls_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'L', 'DTL') DIRECT_TLS_LOAD, MST_AGG_PKG.get_direct_tls_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'L', 'MTL') MULTI_STOP_TLS_LOAD, MST_AGG_PKG.get_tot_trips_carr_Facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'L', 'LTL') LTLS_LOAD, MST_AGG_PKG.get_tot_trips_carr_Facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'L', 'PARCEL') PARCELS_LOAD, MST_AGG_PKG.get_total_weight_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'U', NULL) TOTAL_WEIGHT_UNLOAD, MST_AGG_PKG.get_total_Cube_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'U', NULL) TOTAL_CUBE_UNLOAD, MST_AGG_PKG.get_tot_Pal_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'U', NULL) TOTAL_PALLETS_UNLOAD, MST_AGG_PKG.get_tot_Pieces_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'U', NULL) TOTAL_PIECES_UNLOAD, MST_AGG_PKG.get_tot_Orders_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'U', NULL) TOTAL_ORDERS_UNLOAD, MST_AGG_PKG.get_direct_tls_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'U', 'DTL') DIRECT_TLS_UNLOAD, MST_AGG_PKG.get_direct_tls_carr_facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'U', 'MTL') MULTI_STOP_TLS_UNLOAD, MST_AGG_PKG.get_tot_trips_carr_Facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'U', 'LTL') LTLS_UNLOAD, MST_AGG_PKG.get_tot_trips_carr_Facility (MP.PLAN_ID, WLO.OWNER_PARTY_ID, WL.WSH_LOCATION_ID, 'U', 'PARCEL') PARCELS_UNLOAD, MP.WEIGHT_UOM, MP.VOLUME_UOM FROM MST_PLANS MP, WSH_LOCATION_OWNERS WLO, WSH_LOCATIONS WL, FTE_LOCATION_PARAMETERS FLP WHERE FLP.LOCATION_ID = WL.WSH_LOCATION_ID AND WL.WSH_LOCATION_ID = WLO.WSH_LOCATION_ID

View Text - HTML Formatted

SELECT WLO.OWNER_PARTY_ID CARRIER_ID
, MP.PLAN_ID
, MP.COMPILE_DESIGNATOR
, MP.DESCRIPTION
, WL.WSH_LOCATION_ID
, WL.LOCATION_SOURCE_CODE
, SUBSTR(MST_WB_UTIL.GET_NAME (WL.WSH_LOCATION_ID)
, 1
, 80) COMPANY
, WL.ADDRESS1 ADDRESS
, WL.ADDRESS2
, WL.ADDRESS3
, WL.ADDRESS4
, WL.CITY
, WL.STATE
, WL.COUNTY
, WL.COUNTRY
, WL.PROVINCE
, WL.POSTAL_CODE
, MST_WB_UTIL.GET_CONTACT_NAME(FLP.FACILITY_CONTACT_ID) CONTACT
, MST_WB_UTIL.GET_PHONE_NUMBER(FLP.FACILITY_CONTACT_ID) PHONE
, FLP.FACILITY_ID
, FLP.FACILITY_CODE
, FLP.DESCRIPTION FACILITY_DESCRIPTION
, MST_AGG_PKG.GET_TOTAL_WEIGHT_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'L'
, NULL) TOTAL_WEIGHT_LOAD
, MST_AGG_PKG.GET_TOTAL_CUBE_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'L'
, NULL) TOTAL_CUBE_LOAD
, MST_AGG_PKG.GET_TOT_PAL_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'L'
, NULL) TOTAL_PALLETS_LOAD
, MST_AGG_PKG.GET_TOT_PIECES_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'L'
, NULL) TOTAL_PIECES_LOAD
, MST_AGG_PKG.GET_TOT_ORDERS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'L'
, NULL) TOTAL_ORDERS_LOAD
, MST_AGG_PKG.GET_DIRECT_TLS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'L'
, 'DTL') DIRECT_TLS_LOAD
, MST_AGG_PKG.GET_DIRECT_TLS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'L'
, 'MTL') MULTI_STOP_TLS_LOAD
, MST_AGG_PKG.GET_TOT_TRIPS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'L'
, 'LTL') LTLS_LOAD
, MST_AGG_PKG.GET_TOT_TRIPS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'L'
, 'PARCEL') PARCELS_LOAD
, MST_AGG_PKG.GET_TOTAL_WEIGHT_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'U'
, NULL) TOTAL_WEIGHT_UNLOAD
, MST_AGG_PKG.GET_TOTAL_CUBE_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'U'
, NULL) TOTAL_CUBE_UNLOAD
, MST_AGG_PKG.GET_TOT_PAL_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'U'
, NULL) TOTAL_PALLETS_UNLOAD
, MST_AGG_PKG.GET_TOT_PIECES_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'U'
, NULL) TOTAL_PIECES_UNLOAD
, MST_AGG_PKG.GET_TOT_ORDERS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'U'
, NULL) TOTAL_ORDERS_UNLOAD
, MST_AGG_PKG.GET_DIRECT_TLS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'U'
, 'DTL') DIRECT_TLS_UNLOAD
, MST_AGG_PKG.GET_DIRECT_TLS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'U'
, 'MTL') MULTI_STOP_TLS_UNLOAD
, MST_AGG_PKG.GET_TOT_TRIPS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'U'
, 'LTL') LTLS_UNLOAD
, MST_AGG_PKG.GET_TOT_TRIPS_CARR_FACILITY (MP.PLAN_ID
, WLO.OWNER_PARTY_ID
, WL.WSH_LOCATION_ID
, 'U'
, 'PARCEL') PARCELS_UNLOAD
, MP.WEIGHT_UOM
, MP.VOLUME_UOM
FROM MST_PLANS MP
, WSH_LOCATION_OWNERS WLO
, WSH_LOCATIONS WL
, FTE_LOCATION_PARAMETERS FLP
WHERE FLP.LOCATION_ID = WL.WSH_LOCATION_ID
AND WL.WSH_LOCATION_ID = WLO.WSH_LOCATION_ID