DBA Data[Home] [Help]

APPS.BOMPKMUD dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1369: RETURN mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE

1365: -- EXAMPLE
1366: --
1367: FUNCTION Get_Location_Name(
1368: p_supply_locator_id IN mtl_item_locations.inventory_location_id%TYPE)
1369: RETURN mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE
1370: IS
1371:
1372: CURSOR c_location_name IS
1373: SELECT CONCATENATED_SEGMENTS

Line 1374: FROM mtl_item_locations_kfv

1370: IS
1371:
1372: CURSOR c_location_name IS
1373: SELECT CONCATENATED_SEGMENTS
1374: FROM mtl_item_locations_kfv
1375: WHERE inventory_location_id = p_supply_locator_id;
1376:
1377: l_location_name mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;
1378:

Line 1377: l_location_name mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;

1373: SELECT CONCATENATED_SEGMENTS
1374: FROM mtl_item_locations_kfv
1375: WHERE inventory_location_id = p_supply_locator_id;
1376:
1377: l_location_name mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;
1378:
1379: BEGIN
1380:
1381: IF (p_supply_locator_id IS NOT NULL) THEN