APPS.BOMPXINQ dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1114: FROM mtl_item_locations_kfv

1110: P_organization_id IN NUMBER)
1111: RETURN VARCHAR2 IS
1112: CURSOR locator_name_CUR IS
1113: SELECT concatenated_segments
1114: FROM mtl_item_locations_kfv
1115: WHERE inventory_location_id = P_locator_id
1116: AND organization_id = P_organization_id;
1117: l_locator_name MTL_ITEM_LOCATIONS_KFV.Concatenated_Segments%TYPE;
1118: BEGIN

Line 1117: l_locator_name MTL_ITEM_LOCATIONS_KFV.Concatenated_Segments%TYPE;

1113: SELECT concatenated_segments
1114: FROM mtl_item_locations_kfv
1115: WHERE inventory_location_id = P_locator_id
1116: AND organization_id = P_organization_id;
1117: l_locator_name MTL_ITEM_LOCATIONS_KFV.Concatenated_Segments%TYPE;
1118: BEGIN
1119: OPEN locator_name_CUR;
1120: FETCH locator_name_CUR INTO l_locator_name;
1121: IF (locator_name_CUR%NOTFOUND) THEN

Line 1411: l_locator_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;

1407: j NUMBER;
1408: k NUMBER;
1409: l NUMBER;
1410: l_component_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1411: l_locator_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;
1412: BEGIN
1413: l_component_item_name := Get_Item_Name(P_component_item_id, P_organization_id);
1414:
1415: OPEN Component_Details_CUR;