DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2491: FROM mtl_item_locations_kfv

2487: IF (rcd.supply_locator_id is NOT NULL) THEN
2488:
2489: SELECT CONCATENATED_SEGMENTS
2490: INTO l_location_name
2491: FROM mtl_item_locations_kfv
2492: WHERE inventory_location_id = rcd.supply_locator_id;
2493: ELSE
2494: l_location_name := NULL;
2495: END IF;

Line 2757: FROM mtl_item_locations_kfv

2753: IF (rc.supply_locator_id is NOT NULL) THEN
2754:
2755: SELECT CONCATENATED_SEGMENTS
2756: INTO l_location_name
2757: FROM mtl_item_locations_kfv
2758: WHERE inventory_location_id = rc.supply_locator_id;
2759: ELSE
2760: l_location_name := NULL;
2761: END IF;

Line 3453: l_location_name mtl_item_locations_kfv.concatenated_segments%type;

3449: l_sub_component_count NUMBER := 1;
3450: l_ref_designator_count NUMBER := 1;
3451:
3452: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3453: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3454: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3455: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3456: l_new_item_revision VARCHAR2(3);
3457: l_effectivity_date DATE;

Line 3634: FROM mtl_item_locations_kfv

3630: IF (rc.supply_locator_id is NOT NULL)
3631: THEN
3632: SELECT CONCATENATED_SEGMENTS
3633: INTO l_location_name
3634: FROM mtl_item_locations_kfv
3635: WHERE inventory_location_id = rc.supply_locator_id;
3636: ELSE
3637: l_location_name := NULL;
3638: END IF;