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 FTE_VEHICLE_TYPES

Line 326: FROM fte_vehicle_types vt,

322: NVL(CONV_TO_UOM(vt.usable_length, si.dimension_uom_code, tp_dimension_uom, si.inventory_item_id),-99),
323: NVL(CONV_TO_UOM(vt.usable_width, si.dimension_uom_code, tp_dimension_uom, si.inventory_item_id),-99),
324: NVL(CONV_TO_UOM(vt.usable_height, si.dimension_uom_code, tp_dimension_uom, si.inventory_item_id),-99)
325: INTO length, width, height
326: FROM fte_vehicle_types vt,
327: mtl_system_items_b si
328: WHERE vt.inventory_item_id = si.inventory_item_id
329: AND vt.organization_id = si.organization_id
330: AND vt.usable_length is not null

Line 341: FROM fte_vehicle_types vt2,

337: AND serv.mode_of_transport like 'TRUCK'
338: AND carrVeh.carrier_id = carr.carrier_id)
339: AND NVL(CONV_TO_UOM(si.internal_volume, si.volume_uom_code, tp_volume_uom, si.inventory_item_id),0) =
340: (SELECT MAX(NVL(CONV_TO_UOM(si2.internal_volume, si2.volume_uom_code, tp_volume_uom, si2.inventory_item_id),0))
341: FROM fte_vehicle_types vt2,
342: mtl_system_items_b si2
343: WHERE vt2.inventory_item_id = si2.inventory_item_id
344: AND vt2.organization_id = si2.organization_id
345: AND vt2.usable_length is not null

Line 364: --determine how many rows in fte_vehicle_types contain null in at least one of the dimension fields

360: height := -99;
361: END;
362:
363:
364: --determine how many rows in fte_vehicle_types contain null in at least one of the dimension fields
365: -- SELECT COUNT(*) INTO total
366: -- FROM fte_vehicle_types vt,
367: -- mtl_system_items_b si
368: -- WHERE vt.inventory_item_id = si.inventory_item_id

Line 366: -- FROM fte_vehicle_types vt,

362:
363:
364: --determine how many rows in fte_vehicle_types contain null in at least one of the dimension fields
365: -- SELECT COUNT(*) INTO total
366: -- FROM fte_vehicle_types vt,
367: -- mtl_system_items_b si
368: -- WHERE vt.inventory_item_id = si.inventory_item_id
369: -- AND vt.organization_id = si.organization_id
370: -- AND (usable_length IS NULL

Line 568: FROM fte_vehicle_types vt,

564:
565: --find vehicle with the biggest volume
566: SELECT MAX(NVL(CONV_TO_UOM(si.internal_volume, si.volume_uom_code, tp_volume_uom, si.inventory_item_id),0)) as volume
567: INTO maxVolumeV
568: FROM fte_vehicle_types vt,
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

Line 582: FROM fte_vehicle_types vt,

578:
579: --find vehicle with the biggest weight
580: SELECT MAX(NVL(CONV_TO_UOM(si.maximum_load_weight, si.weight_uom_code,tp_weight_uom, si.inventory_item_id),0)) as load_weight
581: INTO maxWeightV
582: FROM fte_vehicle_types vt,
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

Line 712: FROM fte_vehicle_types vt,

708:
709:
710: /* Debug query
711: SELECT si.internal_volume as volume, si.volume_uom_code, VEHICLE_TYPE_ID, vt.inventory_item_id , vt.organization_id
712: FROM fte_vehicle_types vt,
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

Line 723: FROM fte_vehicle_types vt,

719: and serv.mode_of_transport like 'TRUCK'
720: and carrVeh.carrier_id = carr.carrier_id)
721: AND si.internal_volume =
722: (SELECT MAX(si.internal_volume) as volume
723: FROM fte_vehicle_types vt,
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

Line 738: FROM fte_vehicle_types vt,

734:
735: --find vehicle with the biggest volume
736: SELECT MAX(NVL(CONV_TO_UOM(si.internal_volume, si.volume_uom_code, tp_volume_uom, si.inventory_item_id),0)) as volume
737: INTO maxVolumeV
738: FROM fte_vehicle_types vt,
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

Line 752: FROM fte_vehicle_types vt,

748:
749: --find vehicle with the biggest weight
750: SELECT MAX(NVL(CONV_TO_UOM(si.maximum_load_weight, si.weight_uom_code,tp_weight_uom, si.inventory_item_id),0)) as load_weight
751: INTO maxWeightV
752: FROM fte_vehicle_types vt,
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

Line 875: FROM fte_vehicle_types vt,

871:
872: --find vehicle with the biggest volume
873: SELECT MAX(NVL(CONV_TO_UOM(si.internal_volume, si.volume_uom_code, tp_volume_uom, si.inventory_item_id),0)) as volume
874: INTO maxVolumeV
875: FROM fte_vehicle_types vt,
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

Line 889: FROM fte_vehicle_types vt,

885:
886: --find vehicle with the biggest weight
887: SELECT MAX(NVL(CONV_TO_UOM(si.maximum_load_weight, si.weight_uom_code,tp_weight_uom, si.inventory_item_id),0)) as load_weight
888: INTO maxWeightV
889: FROM fte_vehicle_types vt,
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