APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_SYSTEM_ITEMS

Line 644: FROM rcv_serials_supply rss, rcv_supply rs , rcv_transactions rt , rcv_lots_supply rls, mtl_system_items msi -- for bug 14192301 added msi table

640: END IF;
641: --13722443
642: SELECT COUNT(distinct(rss.serial_num))
643: INTO l_serial_count
644: FROM rcv_serials_supply rss, rcv_supply rs , rcv_transactions rt , rcv_lots_supply rls, mtl_system_items msi -- for bug 14192301 added msi table
645: WHERE rs.rcv_transaction_id = rss.transaction_id
646: AND rs.rcv_transaction_id = rt.transaction_id
647: AND rt.inspection_status_code = l_inspection_status_code
648: AND rs.shipment_line_id = rss.shipment_line_id

Line 4173: FROM mtl_system_items

4169: SELECT lot_control_code
4170: , serial_number_control_code
4171: INTO l_lot_code
4172: , l_serial_code
4173: FROM mtl_system_items
4174: WHERE organization_id = p_org_id
4175: AND inventory_item_id = p_item_id;
4176:
4177:

Line 7496: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

7492: , l_item_id
7493: , l_sub
7494: , l_loc
7495: , l_lpn_id
7496: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
7497: WHERE mmtt.organization_id = l_org_id
7498: AND mmtt.transaction_temp_id = l_temp_id
7499: AND msi.organization_id = mmtt.organization_id
7500: AND msi.inventory_item_id = mmtt.inventory_item_id;

Line 8826: FROM mtl_system_items

8822:
8823: -- Get the item's primary uom code
8824: SELECT primary_uom_code
8825: INTO l_primary_uom_code
8826: FROM mtl_system_items
8827: WHERE inventory_item_id = v_mo_line.inventory_item_id
8828: AND organization_id = p_organization_id;
8829:
8830: IF (l_debug = 1) THEN

Line 9077: FROM mtl_system_items

9073: SELECT lot_control_code
9074: , serial_number_control_code
9075: INTO l_lot_control_code
9076: , l_serial_control_code
9077: FROM mtl_system_items
9078: WHERE inventory_item_id = l_item_id
9079: AND organization_id = p_organization_id;
9080:
9081: IF (l_debug = 1) THEN