APPS.INV_COST_GROUP_PVT dependencies on MTL_ITEM_LOCATIONS

Line 576: FROM mtl_item_locations

572: p_mmtt_rec.transfer_organization > 0) THEN
573:
574: BEGIN
575: SELECT project_id INTO l_to_project_id
576: FROM mtl_item_locations
577: WHERE inventory_location_id = p_mmtt_rec.transfer_to_location
578: AND organization_id = p_mmtt_rec.transfer_organization;
579: EXCEPTION
580: WHEN OTHERS THEN

Line 743: FROM mtl_item_locations

739:
740: IF(p_mmtt_rec.locator_id IS NOT NULL) then
741: BEGIN
742: SELECT project_id INTO l_from_project_id
743: FROM mtl_item_locations
744: WHERE inventory_location_id = p_mmtt_rec.locator_id
745: AND organization_id = p_mmtt_rec.organization_id;
746: EXCEPTION
747: WHEN OTHERS THEN

Line 759: FROM mtl_item_locations

755: IF(p_mmtt_rec.transfer_to_location IS NOT NULL) then
756:
757: BEGIN
758: SELECT project_id INTO l_to_project_id
759: FROM mtl_item_locations
760: WHERE inventory_location_id = p_mmtt_rec.transfer_to_location
761: AND organization_id = l_transfer_organization_id;
762: EXCEPTION
763: WHEN OTHERS THEN

Line 815: FROM mtl_item_locations

811: WHERE organization_id = l_transfer_organization_id;
812: IF( l_from_locator_id IS NOT NULL) then
813: BEGIN
814: SELECT project_id INTO l_from_project_id
815: FROM mtl_item_locations
816: WHERE inventory_location_id = l_from_locator_id AND
817: organization_id = l_organization_id;
818: EXCEPTION
819: WHEN OTHERS THEN

Line 833: FROM mtl_item_locations

829: print_debug(' l_transfer_organization_id '||l_transfer_organization_id);
830: END IF;
831: BEGIN
832: SELECT project_id INTO l_to_project_id
833: FROM mtl_item_locations
834: WHERE inventory_location_id = l_to_locator_id AND
835: organization_id = l_transfer_organization_id;
836: EXCEPTION
837: WHEN OTHERS THEN