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_AUDIT_REP_EXCP dependencies on WSH_CARRIERS

Line 334: FROM wsh_carriers carr, wsh_carrier_services serv,

330: AND vt.usable_length is not null
331: AND vt.usable_width is not null
332: AND vt.usable_height is not null
333: AND vt.vehicle_type_id IN (SELECT distinct vehicle_type_id
334: FROM wsh_carriers carr, wsh_carrier_services serv,
335: wsh_carrier_vehicle_types carrVeh
336: WHERE carr.carrier_id = serv.carrier_id
337: AND serv.mode_of_transport like 'TRUCK'
338: AND carrVeh.carrier_id = carr.carrier_id)

Line 349: FROM wsh_carriers carr, wsh_carrier_services serv,

345: AND vt2.usable_length is not null
346: AND vt2.usable_width is not null
347: AND vt2.usable_height is not null
348: AND vt2.vehicle_type_id IN (SELECT distinct vehicle_type_id
349: FROM wsh_carriers carr, wsh_carrier_services serv,
350: wsh_carrier_vehicle_types carrVeh
351: WHERE carr.carrier_id = serv.carrier_id
352: AND serv.mode_of_transport like 'TRUCK'
353: AND carrVeh.carrier_id = carr.carrier_id))

Line 573: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

569: mtl_system_items_b si
570: WHERE vt.inventory_item_id = si.inventory_item_id
571: AND vt.organization_id = si.organization_id
572: AND vt.vehicle_type_id IN (SELECT distinct vehicle_type_id
573: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh
574: WHERE carr.carrier_id = serv.carrier_id
575: AND serv.mode_of_transport like 'TRUCK'
576: AND carrVeh.carrier_id = carr.carrier_id);
577:

Line 587: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

583: mtl_system_items_b si
584: WHERE vt.inventory_item_id = si.inventory_item_id
585: AND vt.organization_id = si.organization_id
586: AND vt.vehicle_type_id IN (SELECT distinct vehicle_type_id
587: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh
588: WHERE carr.carrier_id = serv.carrier_id
589: AND serv.mode_of_transport like 'TRUCK'
590: AND carrVeh.carrier_id = carr.carrier_id);
591:

Line 717: from wsh_carriers carr, wsh_carrier_services serv, WSH_CARRIER_VEHICLE_TYPES carrVeh

713: mtl_system_items_b si
714: WHERE vt.inventory_item_id = si.inventory_item_id
715: AND vt.organization_id = si.organization_id
716: AND vt.vehicle_type_id in (select distinct vehicle_type_id
717: from wsh_carriers carr, wsh_carrier_services serv, WSH_CARRIER_VEHICLE_TYPES carrVeh
718: where carr.carrier_id = serv.carrier_id
719: and serv.mode_of_transport like 'TRUCK'
720: and carrVeh.carrier_id = carr.carrier_id)
721: AND si.internal_volume =

Line 728: from wsh_carriers carr, wsh_carrier_services serv, WSH_CARRIER_VEHICLE_TYPES carrVeh

724: mtl_system_items_b si
725: WHERE vt.inventory_item_id = si.inventory_item_id
726: AND vt.organization_id = si.organization_id
727: AND vt.vehicle_type_id in (select distinct vehicle_type_id
728: from wsh_carriers carr, wsh_carrier_services serv, WSH_CARRIER_VEHICLE_TYPES carrVeh
729: where carr.carrier_id = serv.carrier_id
730: and serv.mode_of_transport like 'TRUCK'
731: and carrVeh.carrier_id = carr.carrier_id))
732: AND ROWNUM = 1;

Line 743: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

739: mtl_system_items_b si
740: WHERE vt.inventory_item_id = si.inventory_item_id
741: AND vt.organization_id = si.organization_id
742: AND vt.vehicle_type_id IN (SELECT distinct vehicle_type_id
743: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh
744: WHERE carr.carrier_id = serv.carrier_id
745: AND serv.mode_of_transport like 'TRUCK'
746: AND carrVeh.carrier_id = carr.carrier_id);
747:

Line 757: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

753: mtl_system_items_b si
754: WHERE vt.inventory_item_id = si.inventory_item_id
755: AND vt.organization_id = si.organization_id
756: AND vt.vehicle_type_id IN (SELECT distinct vehicle_type_id
757: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh
758: WHERE carr.carrier_id = serv.carrier_id
759: AND serv.mode_of_transport like 'TRUCK'
760: AND carrVeh.carrier_id = carr.carrier_id);
761:

Line 880: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

876: mtl_system_items_b si
877: WHERE vt.inventory_item_id = si.inventory_item_id
878: AND vt.organization_id = si.organization_id
879: AND vt.vehicle_type_id IN (SELECT distinct vehicle_type_id
880: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh
881: WHERE carr.carrier_id = serv.carrier_id
882: AND serv.mode_of_transport like 'TRUCK'
883: AND carrVeh.carrier_id = carr.carrier_id);
884:

Line 894: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

890: mtl_system_items_b si
891: WHERE vt.inventory_item_id = si.inventory_item_id
892: AND vt.organization_id = si.organization_id
893: AND vt.vehicle_type_id IN (SELECT distinct vehicle_type_id
894: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh
895: WHERE carr.carrier_id = serv.carrier_id
896: AND serv.mode_of_transport like 'TRUCK'
897: AND carrVeh.carrier_id = carr.carrier_id);
898: