APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_SYSTEM_ITEMS

Line 3968: FROM mtl_system_items

3964: SELECT lot_control_code
3965: , serial_number_control_code
3966: INTO l_lot_code
3967: , l_serial_code
3968: FROM mtl_system_items
3969: WHERE organization_id = p_org_id
3970: AND inventory_item_id = p_item_id;
3971:
3972:

Line 7169: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

7165: , l_item_id
7166: , l_sub
7167: , l_loc
7168: , l_lpn_id
7169: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
7170: WHERE mmtt.organization_id = l_org_id
7171: AND mmtt.transaction_temp_id = l_temp_id
7172: AND msi.organization_id = mmtt.organization_id
7173: AND msi.inventory_item_id = mmtt.inventory_item_id;

Line 8472: FROM mtl_system_items

8468:
8469: -- Get the item's primary uom code
8470: SELECT primary_uom_code
8471: INTO l_primary_uom_code
8472: FROM mtl_system_items
8473: WHERE inventory_item_id = v_mo_line.inventory_item_id
8474: AND organization_id = p_organization_id;
8475:
8476: IF (l_debug = 1) THEN

Line 8720: FROM mtl_system_items

8716: SELECT lot_control_code
8717: , serial_number_control_code
8718: INTO l_lot_control_code
8719: , l_serial_control_code
8720: FROM mtl_system_items
8721: WHERE inventory_item_id = l_item_id
8722: AND organization_id = p_organization_id;
8723:
8724: IF (l_debug = 1) THEN