DBA Data[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;