DBA Data[Home] [Help]

APPS.MST_REPORTS_PKG dependencies on WSH_CARRIERS

Line 6150: , wsh_carriers wc

6146: , mst_reports_pkg.get_carr_movements(p_plan_id,p_report_for,p_report_for_id,mt.carrier_id)
6147: , mst_reports_pkg.get_carr_cost(p_plan_id,p_report_for,p_report_for_id,mt.carrier_id)
6148: , mt.mode_of_transport
6149: from mst_trips mt
6150: , wsh_carriers wc
6151: WHERE mt.carrier_id = wc.carrier_id
6152: and mt.plan_id = p_plan_id
6153: and decode ( p_report_for, 3, mt.carrier_id, p_report_for_id ) = p_report_for_id
6154: group by mt.plan_id