APPS.BOMPXINQ dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1021: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1017:
1018: FUNCTION Get_Item_Name(P_item_id IN NUMBER,
1019: P_organization_id IN NUMBER)
1020: RETURN VARCHAR2 IS
1021: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1022: BEGIN
1023: SELECT concatenated_segments
1024: INTO l_item_name
1025: FROM mtl_system_items_kfv

Line 1025: FROM mtl_system_items_kfv

1021: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1022: BEGIN
1023: SELECT concatenated_segments
1024: INTO l_item_name
1025: FROM mtl_system_items_kfv
1026: WHERE inventory_item_id = P_item_id
1027: AND organization_id = P_organization_id;
1028: RETURN l_item_name;
1029: EXCEPTION

Line 1139: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1135: WHERE inventory_item_id = P_assembly_item_id
1136: AND organization_id = P_organization_id;
1137:
1138: l_bill_details Bill_Details_CUR%ROWTYPE;
1139: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1140: l_common_org_code VARCHAR2(3);
1141: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1142: l_org_code VARCHAR2(3);
1143: l_cnt NUMBER;

Line 1141: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1137:
1138: l_bill_details Bill_Details_CUR%ROWTYPE;
1139: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1140: l_common_org_code VARCHAR2(3);
1141: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1142: l_org_code VARCHAR2(3);
1143: l_cnt NUMBER;
1144: l_counter NUMBER;
1145: l_count NUMBER;

Line 1366: l_component_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

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