APPS.BOMPXINQ dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1070: FROM mtl_item_locations_kfv

1066: P_organization_id IN NUMBER)
1067: RETURN VARCHAR2 IS
1068: CURSOR locator_name_CUR IS
1069: SELECT concatenated_segments
1070: FROM mtl_item_locations_kfv
1071: WHERE inventory_location_id = P_locator_id
1072: AND organization_id = P_organization_id;
1073: l_locator_name MTL_ITEM_LOCATIONS_KFV.Concatenated_Segments%TYPE;
1074: BEGIN

Line 1073: l_locator_name MTL_ITEM_LOCATIONS_KFV.Concatenated_Segments%TYPE;

1069: SELECT concatenated_segments
1070: FROM mtl_item_locations_kfv
1071: WHERE inventory_location_id = P_locator_id
1072: AND organization_id = P_organization_id;
1073: l_locator_name MTL_ITEM_LOCATIONS_KFV.Concatenated_Segments%TYPE;
1074: BEGIN
1075: OPEN locator_name_CUR;
1076: FETCH locator_name_CUR INTO l_locator_name;
1077: IF (locator_name_CUR%NOTFOUND) THEN

Line 1367: l_locator_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;

1363: j NUMBER;
1364: k NUMBER;
1365: l NUMBER;
1366: l_component_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1367: l_locator_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;
1368: BEGIN
1369: l_component_item_name := Get_Item_Name(P_component_item_id, P_organization_id);
1370:
1371: OPEN Component_Details_CUR;