APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_ITEM_LOCATIONS

Line 487: SELECT COUNT(1) INTO l_count FROM MTL_ITEM_LOCATIONS MIL

483:
484: IF (p_mtl_trx_tbl(i).locator_id IS NOT NULL) THEN
485:
486: BEGIN
487: SELECT COUNT(1) INTO l_count FROM MTL_ITEM_LOCATIONS MIL
488: WHERE MIL.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
489: AND MIL.SUBINVENTORY_CODE = p_mtl_trx_tbl(i).subinventory_code
490: AND MIL.INVENTORY_LOCATION_ID = p_mtl_trx_tbl(i).locator_id
491: AND TRUNC(p_mtl_trx_tbl(i).transaction_date) <= NVL(MIL.DISABLE_DATE,p_mtl_trx_tbl(i).transaction_date + 1);

Line 891: mtl_item_locations WHERE inventory_location_id =

887: IF (p_mtl_trx_tbl(i).locator_id IS NOT NULL) THEN
888:
889: BEGIN
890: SELECT project_id, task_id INTO l_project_id, l_task_id FROM
891: mtl_item_locations WHERE inventory_location_id =
892: p_mtl_trx_tbl(i).locator_id AND organization_id =
893: p_mtl_trx_tbl(i).organization_id;
894: EXCEPTION
895: WHEN no_data_found THEN