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 909: mtl_item_locations WHERE inventory_location_id =

905: IF (p_mtl_trx_tbl(i).locator_id IS NOT NULL) THEN
906:
907: BEGIN
908: SELECT project_id, task_id INTO l_project_id, l_task_id FROM
909: mtl_item_locations WHERE inventory_location_id =
910: p_mtl_trx_tbl(i).locator_id AND organization_id =
911: p_mtl_trx_tbl(i).organization_id;
912: EXCEPTION
913: WHEN no_data_found THEN