DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2440: FROM mtl_item_locations_kfv

2436: IF (rcd.supply_locator_id is NOT NULL) THEN
2437:
2438: SELECT CONCATENATED_SEGMENTS
2439: INTO l_location_name
2440: FROM mtl_item_locations_kfv
2441: WHERE inventory_location_id = rcd.supply_locator_id;
2442: ELSE
2443: l_location_name := NULL;
2444: END IF;

Line 2700: FROM mtl_item_locations_kfv

2696: IF (rc.supply_locator_id is NOT NULL) THEN
2697:
2698: SELECT CONCATENATED_SEGMENTS
2699: INTO l_location_name
2700: FROM mtl_item_locations_kfv
2701: WHERE inventory_location_id = rc.supply_locator_id;
2702: ELSE
2703: l_location_name := NULL;
2704: END IF;

Line 3328: l_location_name mtl_item_locations_kfv.concatenated_segments%type;

3324: l_sub_component_count NUMBER := 1;
3325: l_ref_designator_count NUMBER := 1;
3326:
3327: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3328: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3329: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3330: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3331: l_new_item_revision VARCHAR2(3);
3332: l_effectivity_date DATE;

Line 3509: FROM mtl_item_locations_kfv

3505: IF (rc.supply_locator_id is NOT NULL)
3506: THEN
3507: SELECT CONCATENATED_SEGMENTS
3508: INTO l_location_name
3509: FROM mtl_item_locations_kfv
3510: WHERE inventory_location_id = rc.supply_locator_id;
3511: ELSE
3512: l_location_name := NULL;
3513: END IF;