eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MST_AGG_PKG dependencies on WSH_LOCATION_OWNERS

Line 732: FROM WSH_LOCATION_OWNERS wlo

728: AND mt.plan_id = mts.plan_id
729: AND mt.trip_id = mts.trip_id
730: AND mts.stop_location_id in
731: (SELECT wlo.wsh_location_id
732: FROM WSH_LOCATION_OWNERS wlo
733: WHERE wlo.owner_party_id = mt.carrier_id) );
734: */
735: -- ----------------------------------------------------------------------------
736: -- As per bug#3546059 and 3546163, We need to consider all the trips that touch

Line 754: FROM wsh_location_owners wlo

750: AND mdl.plan_id = mts.plan_id
751: AND mdl.pick_up_stop_id = mts.stop_id
752: AND EXISTS
753: (SELECT 1
754: FROM wsh_location_owners wlo
755: WHERE wlo.owner_party_id = p_carrier_id
756: AND wlo.owner_type = CARRIER
757: AND wlo.wsh_location_id = mts.stop_location_id) );
758: l_carrier_weight_tmp := NVL(l_carrier_weight,0);

Line 775: FROM wsh_location_owners wlo

771: AND mdl.plan_id = mts.plan_id
772: AND mdl.drop_off_stop_id = mts.stop_id
773: AND EXISTS
774: (SELECT 1
775: FROM wsh_location_owners wlo
776: WHERE wlo.owner_party_id = p_carrier_id
777: AND wlo.owner_type = CARRIER
778: AND wlo.wsh_location_id = mts.stop_location_id) );
779:

Line 813: FROM WSH_LOCATION_OWNERS wlo

809: AND mt.plan_id = mts.plan_id
810: AND mt.trip_id = mts.trip_id
811: AND mts.stop_location_id in
812: (SELECT wlo.wsh_location_id
813: FROM WSH_LOCATION_OWNERS wlo
814: WHERE wlo.owner_party_id = mt.carrier_id) );
815: **************************/
816: -- ----------------------------------------------------------------------------
817: -- As per bug#3546059 and 3546163, We need to consider all the trips that touch

Line 835: FROM wsh_location_owners wlo

831: AND mdl.plan_id = mts.plan_id
832: AND mdl.pick_up_stop_id = mts.stop_id
833: AND EXISTS
834: (SELECT 1
835: FROM wsh_location_owners wlo
836: WHERE wlo.owner_party_id = p_carrier_id
837: AND wlo.owner_type = CARRIER
838: AND wlo.wsh_location_id = mts.stop_location_id) );
839: l_carrier_volume_tmp := NVL(l_carrier_volume,0);

Line 856: FROM wsh_location_owners wlo

852: AND mdl.plan_id = mts.plan_id
853: AND mdl.drop_off_stop_id = mts.stop_id
854: AND EXISTS
855: (SELECT 1
856: FROM wsh_location_owners wlo
857: WHERE wlo.owner_party_id = p_carrier_id
858: AND wlo.owner_type = CARRIER
859: AND wlo.wsh_location_id = mts.stop_location_id) );
860:

Line 895: FROM WSH_LOCATION_OWNERS wlo

891: AND mt.plan_id = mts.plan_id
892: AND mt.trip_id = mts.trip_id
893: AND mts.stop_location_id in
894: (SELECT wlo.wsh_location_id
895: FROM WSH_LOCATION_OWNERS wlo
896: WHERE wlo.owner_party_id = mt.carrier_id) );
897: **************************/
898: -- ----------------------------------------------------------------------------
899: -- As per bug#3546059 and 3546163, We need to consider all the trips that touch

Line 917: FROM wsh_location_owners wlo

913: AND mdl.plan_id = mts.plan_id
914: AND mdl.pick_up_stop_id = mts.stop_id
915: AND EXISTS
916: (SELECT 1
917: FROM wsh_location_owners wlo
918: WHERE wlo.owner_party_id = p_carrier_id
919: AND wlo.owner_type = CARRIER
920: AND wlo.wsh_location_id = mts.stop_location_id) );
921: l_carrier_pallets_tmp := NVL(l_carrier_pallets,0);

Line 938: FROM wsh_location_owners wlo

934: AND mdl.plan_id = mts.plan_id
935: AND mdl.drop_off_stop_id = mts.stop_id
936: AND EXISTS
937: (SELECT 1
938: FROM wsh_location_owners wlo
939: WHERE wlo.owner_party_id = p_carrier_id
940: AND wlo.owner_type = CARRIER
941: AND wlo.wsh_location_id = mts.stop_location_id) );
942:

Line 976: FROM WSH_LOCATION_OWNERS wlo

972: AND mt.plan_id = mts.plan_id
973: AND mt.trip_id = mts.trip_id
974: AND mts.stop_location_id in
975: (SELECT wlo.wsh_location_id
976: FROM WSH_LOCATION_OWNERS wlo
977: WHERE wlo.owner_party_id = mt.carrier_id) );
978: **************************/
979: -- ----------------------------------------------------------------------------
980: -- As per bug#3546059 and 3546163, We need to consider all the trips that touch

Line 998: FROM wsh_location_owners wlo

994: AND mdl.plan_id = mts.plan_id
995: AND mdl.pick_up_stop_id = mts.stop_id
996: AND EXISTS
997: (SELECT 1
998: FROM wsh_location_owners wlo
999: WHERE wlo.owner_party_id = p_carrier_id
1000: AND wlo.owner_type = CARRIER
1001: AND wlo.wsh_location_id = mts.stop_location_id) );
1002: l_carrier_pieces_tmp := NVL(l_carrier_pieces,0);

Line 1019: FROM wsh_location_owners wlo

1015: AND mdl.plan_id = mts.plan_id
1016: AND mdl.drop_off_stop_id = mts.stop_id
1017: AND EXISTS
1018: (SELECT 1
1019: FROM wsh_location_owners wlo
1020: WHERE wlo.owner_party_id = p_carrier_id
1021: AND wlo.owner_type = CARRIER
1022: AND wlo.wsh_location_id = mts.stop_location_id) );
1023:

Line 1067: FROM WSH_LOCATION_OWNERS wlo

1063: AND TS.TRIP_ID = T.TRIP_ID
1064: AND T.CARRIER_ID = P_CARRIER_ID
1065: AND ts.stop_location_id in
1066: (SELECT wlo.wsh_location_id
1067: FROM WSH_LOCATION_OWNERS wlo
1068: WHERE wlo.owner_party_id = t.carrier_id))
1069: AND MDA.PLAN_ID = MDD.PLAN_ID
1070: AND MDA.DELIVERY_DETAIL_ID = MDD.DELIVERY_DETAIL_ID
1071: AND MD.PLAN_ID = P_PLAN_ID;

Line 1098: FROM wsh_location_owners wlo

1094: AND mdl.plan_id = mts.plan_id
1095: AND mdl.pick_up_stop_id = mts.stop_id
1096: AND EXISTS
1097: (SELECT 1
1098: FROM wsh_location_owners wlo
1099: WHERE wlo.owner_party_id = p_carrier_id
1100: AND wlo.owner_type = CARRIER
1101: AND wlo.wsh_location_id = mts.stop_location_id) );
1102: l_carrier_orders_tmp := NVL(l_carrier_orders,0);

Line 1125: FROM wsh_location_owners wlo

1121: AND mdl.plan_id = mts.plan_id
1122: AND mdl.drop_off_stop_id = mts.stop_id
1123: AND EXISTS
1124: (SELECT 1
1125: FROM wsh_location_owners wlo
1126: WHERE wlo.owner_party_id = p_carrier_id
1127: AND wlo.owner_type = CARRIER
1128: AND wlo.wsh_location_id = mts.stop_location_id) );
1129:

Line 4144: --FROM wsh_location_owners wlo

4140: --CURSOR partner_trips(p_location_id IN NUMBER) IS
4141:
4142: --CURSOR get_carrier_facilities IS
4143: --SELECT wlo.wsh_location_id
4144: --FROM wsh_location_owners wlo
4145: --WHERE owner_party_id = p_carrier_id
4146: --AND owner_type = 3; -- 'carrier'
4147:
4148: CURSOR carrier_trips IS

Line 4158: wsh_location_owners wlo

4154:
4155: CURSOR stop_locations(p_trip_id IN NUMBER) IS
4156: SELECT ts.stop_location_id
4157: FROM mst_trip_stops ts,
4158: wsh_location_owners wlo
4159: WHERE plan_id = p_plan_id
4160: AND ts.trip_id = p_trip_id
4161: AND ts.stop_location_id = wlo.wsh_location_id
4162: AND owner_party_id = p_carrier_id

Line 4237: FROM wsh_location_owners wlo

4233: p_carrier_id IN NUMBER ) RETURN VARCHAR2 IS
4234:
4235: CURSOR get_carrier_facilities IS
4236: SELECT wlo.wsh_location_id
4237: FROM wsh_location_owners wlo
4238: WHERE owner_party_id = p_carrier_id
4239: AND owner_type = CARRIER;
4240:
4241: CURSOR trips_to_location(p_location_id IN NUMBER) IS

Line 4324: FROM wsh_location_owners wlo

4320: AND mt.plan_id = mts.plan_Id
4321: AND mt.trip_id = mts.trip_id
4322: AND mt.carrier_id = p_carrier_id
4323: AND EXISTS (SELECT 1
4324: FROM wsh_location_owners wlo
4325: WHERE wlo.owner_party_id = mt.carrier_id
4326: AND wlo.wsh_location_id = mts.stop_location_id
4327: AND wlo.owner_type = CARRIER);*/
4328:

Line 4350: FROM wsh_location_owners wlo

4346: AND mt.trip_id = mdl.trip_id
4347: AND mt.plan_id = mts.plan_Id
4348: AND mt.trip_id = mts.trip_id
4349: AND EXISTS (SELECT 1
4350: FROM wsh_location_owners wlo
4351: WHERE wlo.owner_party_id = p_carrier_id
4352: AND wlo.wsh_location_id = mts.stop_location_id
4353: AND wlo.owner_type = CARRIER);
4354: l_total_cost NUMBER;