APPS.WMS_UT_PKG dependencies on MTL_SYSTEM_ITEMS

Line 347: FROM mtl_system_items

343: BEGIN
344: IF nvl(g_item,'@#') <> p_item THEN
345: SELECT inventory_item_id
346: INTO g_item_id
347: FROM mtl_system_items
348: WHERE organization_id = p_org_id
349: AND segment1 = p_item;
350: g_item := p_item;
351: END IF;

Line 571: FROM mtl_system_items

567:
568: if nvl(l_last_item,'@@@') <> l_item THEN
569: SELECT inventory_item_id, SERIAL_NUMBER_CONTROL_CODE, lot_control_code
570: INTO l_item_id, l_ser_ctrl, l_lot_ctrl
571: FROM mtl_system_items
572: WHERE organization_id = p_org_id
573: AND segment1 = l_item;
574:
575: l_last_item := l_item;

Line 987: FROM mtl_system_items

983:
984: print_debug('Rsv Dem Type :' || l_demand_source_type_id);
985: SELECT inventory_item_id
986: INTO l_inventory_item_id
987: FROM mtl_system_items
988: WHERE organization_id = p_org_id
989: AND segment1 = l_rsvs_lst(i)(2);
990: print_debug('Rsv Dem header :' || l_demand_source_header_id);
991:

Line 1091: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil

1087: mr.secondary_reservation_quantity || ', ' ||
1088: mr.secondary_uom_code || ', ' ||
1089: Nvl(mr.secondary_detailed_quantity,0) as p_text
1090: INTO l_rt
1091: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
1092: WHERE reservation_id = l_new_reservation_id
1093: AND msi.organization_id = mr.organization_id
1094: AND msi.inventory_item_id = mr.inventory_item_id
1095: AND mp.organization_id = mr.organization_id

Line 1255: FROM mtl_system_items

1251: l_ix := l_ix + 1;
1252: l_item := l_mo_orders(l_ix)(3);
1253: SELECT inventory_item_id
1254: INTO l_inventory_item_id
1255: FROM mtl_system_items
1256: WHERE segment1 = l_item
1257: AND organization_id = p_org_id;
1258:
1259: print_debug('Item : ' || l_inventory_item_id);

Line 2223: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil

2219: mr.secondary_reservation_quantity || ', ' ||
2220: mr.secondary_uom_code || ', ' ||
2221: Nvl(mr.secondary_detailed_quantity,0) as p_text,
2222: mr.reservation_id as reservation_id
2223: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
2224: WHERE
2225: Nvl(mr.supply_source_type_id, 13) = 13
2226: AND g_demand_tbl(p_di).demand_source_type_id = mr.demand_source_type_id
2227: AND nvl(g_demand_tbl(p_di).demand_source_header_id,-9999) = nvl(mr.demand_source_header_id, -9999)