[Home] [Help]
APPS.BOM_RTG_VAL_TO_ID dependencies on MTL_SYSTEM_ITEMS_B_KFV
Line 84: /* Bug 4040340. Using mtl_system_items_b_kfv to get the item id
80: ret_code NUMBER;
81: l_err_text VARCHAR2(2000);
82: BEGIN
83:
84: /* Bug 4040340. Using mtl_system_items_b_kfv to get the item id
85: ret_code := INVPUOPI.mtl_pr_parse_flex_name(
86: org_id => p_organization_id,
87: flex_code => 'MSTK',
88: flex_name => p_revised_item_num,
Line 101: FROM mtl_system_items_b_kfv
97: END IF;*/
98:
99: SELECT inventory_item_id
100: INTO l_id
101: FROM mtl_system_items_b_kfv
102: WHERE organization_id = p_organization_id
103: and concatenated_segments = p_revised_item_num;
104:
105: RETURN l_id;