VIEW: APPS.MST_REL_PLAN_V

Source

View Text - Preformatted

SELECT mp.plan_id , mp.compile_designator , mp.description , mp.start_date , mp.cutoff_date , mp.plan_start_date , substr(to_char(mp.start_date, 'hh24:mi'), 1, 5) , substr(to_char(mp.cutoff_date, 'hh24:mi'), 1, 5) , substr(to_char(mp.plan_start_date, 'hh24:mi'), 1, 5) , MST_AGG_PKG.get_total_direct_tls(mp.plan_id) , MST_AGG_PKG.get_total_direct_mstop_tls(mp.plan_id) , MST_AGG_PKG.get_trip_count(mp.plan_id, 'LTL') , MST_AGG_PKG.get_trip_count(mp.plan_id, 'PARCEL') , MST_AGG_PKG.get_cm_count(mp.plan_id) , mp.total_weight , mp.weight_uom , mp.total_volume , mp.volume_uom , mp.total_pallets , mp.total_pieces , mp.total_orders , nvl(mp.total_plan_cost, 0) , nvl(mp.total_cost_no_consolidation, 0) , nvl(mp.total_cost_no_consolidation, 0) - nvl(mp.total_plan_cost, 0) , MST_AGG_PKG.get_total_tls_in_cms(mp.plan_id) , mp.currency_uom , MST_AGG_PKG.get_total_excp_in_plan(mp.plan_id) from mst_plans mp

View Text - HTML Formatted

SELECT MP.PLAN_ID
, MP.COMPILE_DESIGNATOR
, MP.DESCRIPTION
, MP.START_DATE
, MP.CUTOFF_DATE
, MP.PLAN_START_DATE
, SUBSTR(TO_CHAR(MP.START_DATE
, 'HH24:MI')
, 1
, 5)
, SUBSTR(TO_CHAR(MP.CUTOFF_DATE
, 'HH24:MI')
, 1
, 5)
, SUBSTR(TO_CHAR(MP.PLAN_START_DATE
, 'HH24:MI')
, 1
, 5)
, MST_AGG_PKG.GET_TOTAL_DIRECT_TLS(MP.PLAN_ID)
, MST_AGG_PKG.GET_TOTAL_DIRECT_MSTOP_TLS(MP.PLAN_ID)
, MST_AGG_PKG.GET_TRIP_COUNT(MP.PLAN_ID
, 'LTL')
, MST_AGG_PKG.GET_TRIP_COUNT(MP.PLAN_ID
, 'PARCEL')
, MST_AGG_PKG.GET_CM_COUNT(MP.PLAN_ID)
, MP.TOTAL_WEIGHT
, MP.WEIGHT_UOM
, MP.TOTAL_VOLUME
, MP.VOLUME_UOM
, MP.TOTAL_PALLETS
, MP.TOTAL_PIECES
, MP.TOTAL_ORDERS
, NVL(MP.TOTAL_PLAN_COST
, 0)
, NVL(MP.TOTAL_COST_NO_CONSOLIDATION
, 0)
, NVL(MP.TOTAL_COST_NO_CONSOLIDATION
, 0) - NVL(MP.TOTAL_PLAN_COST
, 0)
, MST_AGG_PKG.GET_TOTAL_TLS_IN_CMS(MP.PLAN_ID)
, MP.CURRENCY_UOM
, MST_AGG_PKG.GET_TOTAL_EXCP_IN_PLAN(MP.PLAN_ID)
FROM MST_PLANS MP