109: * Resolves the item number.
110: *
111: * ARGUMENTS
112: * p_item_id Unique identifier for item number in
113: * MTL_SYSTEM_ITEMS_KFV view.
114: *
115: * NOTES
116: * Return NULL if an error occurs.
117: *
133:
134: SELECT icx_util.item_flex_seg( msi.rowid )
135: INTO v_item_num
136: FROM
137: mtl_system_items msi,
138: financials_system_parameters fsp
139: WHERE
140: p_item_id = msi.inventory_item_id (+)
141: AND fsp.inventory_organization_id = NVL(