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 MTL_SYSTEM_ITEMS

Line 245: MTL_SYSTEM_ITEMS it,

241: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id,219,
242: det.delivery_detail_id, da.delivery_id,
243: userIdIn, userIdIn,-1,sysdate, sysdate,3
244: FROM MST_DELIVERY_DETAILS det,
245: MTL_SYSTEM_ITEMS it,
246: MST_DELIVERY_ASSIGNMENTS da
247: WHERE det.plan_id = plan_idIn
248: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
249: AND det.delivery_detail_id = da.delivery_detail_id (+)

Line 294: MTL_SYSTEM_ITEMS IT

290: CURSOR c_pieces IS
291: SELECT det.delivery_detail_id,
292: IT.UNIT_LENGTH, IT.UNIT_WIDTH, IT.UNIT_HEIGHT, it.DIMENSION_UOM_CODE, it.inventory_item_id
293: FROM MST_DELIVERY_DETAILS DET,
294: MTL_SYSTEM_ITEMS IT
295: WHERE IT.INVENTORY_ITEM_ID = DET.INVENTORY_ITEM_ID
296: AND det.organization_id = it.organization_id
297: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
298: AND det.plan_id = plan_idIn;

Line 327: mtl_system_items_b si

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
331: AND vt.usable_width is not null

Line 342: mtl_system_items_b si2

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
346: AND vt2.usable_width is not null

Line 367: -- mtl_system_items_b si

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
371: -- OR usable_width IS NULL

Line 512: -- MTL_SYSTEM_ITEMS si

508: -- SELECT DELIVERY_DETAIL_ID, det.inventory_item_id,
509: -- net_weight, si.unit_length, si.unit_width, si.unit_height,
510: -- requested_quantity, si.weight_uom_code, si.dimension_uom_code
511: -- FROM MST_DELIVERY_DETAILS det,
512: -- MTL_SYSTEM_ITEMS si
513: -- WHERE det.PLAN_ID = plan_idIn
514: -- AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
515: -- AND det.requested_quantity = 1
516: -- AND det.inventory_item_id = si.inventory_item_id

Line 527: MTL_SYSTEM_ITEMS si,

523: SELECT det.delivery_detail_id, da.delivery_id,
524: NVL(det.net_weight,0) weight,
525: NVL(det.volume,0) volume
526: FROM MST_DELIVERY_DETAILS det,
527: MTL_SYSTEM_ITEMS si,
528: MST_DELIVERY_ASSIGNMENTS da
529: WHERE det.PLAN_ID = plan_idIn
530: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
531: AND det.delivery_detail_id = da.delivery_detail_id (+)

Line 569: mtl_system_items_b si

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
573: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

Line 583: mtl_system_items_b si

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
587: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

Line 674: MTL_SYSTEM_ITEMS si,

670: SELECT det.delivery_detail_id, da.delivery_id,
671: NVL(det.net_weight,0) weight,
672: NVL(det.volume,0) volume
673: FROM MST_DELIVERY_DETAILS det,
674: MTL_SYSTEM_ITEMS si,
675: MST_DELIVERY_ASSIGNMENTS da
676: WHERE det.PLAN_ID = plan_idIn
677: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
678: AND det.delivery_detail_id = da.delivery_detail_id (+)

Line 713: mtl_system_items_b si

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
717: from wsh_carriers carr, wsh_carrier_services serv, WSH_CARRIER_VEHICLE_TYPES carrVeh

Line 724: mtl_system_items_b si

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
728: from wsh_carriers carr, wsh_carrier_services serv, WSH_CARRIER_VEHICLE_TYPES carrVeh

Line 739: mtl_system_items_b si

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
743: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

Line 753: mtl_system_items_b si

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
757: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

Line 876: mtl_system_items_b si

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
880: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh

Line 890: mtl_system_items_b si

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
894: FROM wsh_carriers carr, wsh_carrier_services serv, wsh_carrier_vehicle_types carrVeh