APPS.INV_COST_GROUP_PVT dependencies on MTL_ITEM_LOCATIONS

Line 577: FROM mtl_item_locations

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

Line 744: FROM mtl_item_locations

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

Line 760: FROM mtl_item_locations

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

Line 816: FROM mtl_item_locations

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

Line 834: FROM mtl_item_locations

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

Line 1401: FROM mtl_material_transactions mmt, rcv_shipment_lines rsl, rcv_transactions rt, MTL_ITEM_LOCATIONS mil

1397: END IF;
1398:
1399: BEGIN
1400: SELECT mil.project_id INTO l_project_id
1401: FROM mtl_material_transactions mmt, rcv_shipment_lines rsl, rcv_transactions rt, MTL_ITEM_LOCATIONS mil
1402: WHERE p_mmtt_rec.source_line_id= rt.transaction_id
1403: AND rt.shipment_line_id=rsl.shipment_line_id
1404: AND rsl.mmt_transaction_id=mmt.transaction_id
1405: AND mil.inventory_location_id=mmt.locator_id