APPS.WMS_PUTAWAY_UTILS dependencies on MTL_ITEM_LOCATIONS

Line 682: --,mtl_item_locations milk

678: mmtt.secondary_uom_code -- 9037915
679: FROM mtl_material_transactions_temp mmtt
680: ,mtl_txn_request_lines mtrl
681: ,wms_dispatched_tasks wdt
682: --,mtl_item_locations milk
683: ,mtl_system_items_kfv msik
684: ,mtl_txn_request_headers mtrh
685: WHERE wdt.organization_id = p_organization_id
686: AND wdt.person_id = Decode(p_drop_type, g_dt_drop_all,p_emp_id,wdt.person_id)

Line 3409: --,mtl_item_locations milk

3405: --R12 End
3406: FROM mtl_material_transactions_temp mmtt
3407: ,mtl_txn_request_lines mtrl
3408: ,wms_dispatched_tasks wdt
3409: --,mtl_item_locations milk
3410: ,mtl_system_items_kfv msik
3411: ,mtl_txn_request_headers mtrh
3412: ,wms_license_plate_numbers wln
3413: --,mtl_secondary_inventories msi

Line 4371: ,mtl_item_locations_kfv milk

4367: ,Nvl(msi.lpn_controlled_flag,2) lpn_controlled_flag
4368: FROM mtl_material_transactions_temp mmtt
4369: ,wms_license_plate_numbers wlpn
4370: ,mtl_secondary_inventories msi
4371: ,mtl_item_locations_kfv milk
4372: WHERE mmtt.transaction_temp_id = v_transaction_temp_id
4373: AND mmtt.cartonization_id = wlpn.lpn_id(+)
4374: AND NVL(mmtt.transfer_to_location,mmtt.locator_id) = milk.inventory_location_id(+)
4375: AND msi.organization_id(+) = mmtt.organization_id

Line 13167: mtl_item_locations

13163: INTO
13164: l_into_lpn_project_id
13165: ,l_into_lpn_task_id
13166: FROM
13167: mtl_item_locations
13168: WHERE
13169: inventory_location_id = l_into_lpn_loc_id;
13170: ELSE -- context is 2 or 3
13171: SELECT