DBA Data[Home] [Help]

APPS.BOMPKMUD dependencies on MTL_ITEM_LOCATIONS

Line 1363: p_supply_locator_id IN mtl_item_locations.inventory_location_id%TYPE)

1359: --
1360: -- EXAMPLE
1361: --
1362: FUNCTION Get_Location_Name(
1363: p_supply_locator_id IN mtl_item_locations.inventory_location_id%TYPE)
1364: RETURN mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE
1365: IS
1366:
1367: CURSOR c_location_name IS

Line 1364: RETURN mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE

1360: -- EXAMPLE
1361: --
1362: FUNCTION Get_Location_Name(
1363: p_supply_locator_id IN mtl_item_locations.inventory_location_id%TYPE)
1364: RETURN mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE
1365: IS
1366:
1367: CURSOR c_location_name IS
1368: SELECT CONCATENATED_SEGMENTS

Line 1369: FROM mtl_item_locations_kfv

1365: IS
1366:
1367: CURSOR c_location_name IS
1368: SELECT CONCATENATED_SEGMENTS
1369: FROM mtl_item_locations_kfv
1370: WHERE inventory_location_id = p_supply_locator_id;
1371:
1372: l_location_name mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;
1373:

Line 1372: l_location_name mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;

1368: SELECT CONCATENATED_SEGMENTS
1369: FROM mtl_item_locations_kfv
1370: WHERE inventory_location_id = p_supply_locator_id;
1371:
1372: l_location_name mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;
1373:
1374: BEGIN
1375:
1376: IF (p_supply_locator_id IS NOT NULL) THEN