APPS.BOMPXINQ dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1065: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1061:
1062: FUNCTION Get_Item_Name(P_item_id IN NUMBER,
1063: P_organization_id IN NUMBER)
1064: RETURN VARCHAR2 IS
1065: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1066: BEGIN
1067: SELECT concatenated_segments
1068: INTO l_item_name
1069: FROM mtl_system_items_kfv

Line 1069: FROM mtl_system_items_kfv

1065: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1066: BEGIN
1067: SELECT concatenated_segments
1068: INTO l_item_name
1069: FROM mtl_system_items_kfv
1070: WHERE inventory_item_id = P_item_id
1071: AND organization_id = P_organization_id;
1072: RETURN l_item_name;
1073: EXCEPTION

Line 1183: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1179: WHERE inventory_item_id = P_assembly_item_id
1180: AND organization_id = P_organization_id;
1181:
1182: l_bill_details Bill_Details_CUR%ROWTYPE;
1183: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1184: l_common_org_code VARCHAR2(3);
1185: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1186: l_org_code VARCHAR2(3);
1187: l_cnt NUMBER;

Line 1185: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1181:
1182: l_bill_details Bill_Details_CUR%ROWTYPE;
1183: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1184: l_common_org_code VARCHAR2(3);
1185: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1186: l_org_code VARCHAR2(3);
1187: l_cnt NUMBER;
1188: l_counter NUMBER;
1189: l_count NUMBER;

Line 1410: l_component_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

1406: l_cnt NUMBER;
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: