APPS.MRP_EXCEPTION_SC dependencies on MTL_ITEM_FLEXFIELDS

Line 287: v_item_number mtl_item_flexfields.item_number%type;

283: END lock_row;
284:
285: FUNCTION item_number(p_org_id number, p_inventory_item_id NUMBER) RETURN VARCHAR2
286: IS
287: v_item_number mtl_item_flexfields.item_number%type;
288: BEGIN
289: IF p_inventory_item_id IS NOT NULL AND p_org_id IS NOT NULL THEN
290:
291: SELECT item_number INTO v_item_number

Line 292: FROM mtl_item_flexfields

288: BEGIN
289: IF p_inventory_item_id IS NOT NULL AND p_org_id IS NOT NULL THEN
290:
291: SELECT item_number INTO v_item_number
292: FROM mtl_item_flexfields
293: WHERE organization_id = p_org_id
294: AND inventory_item_id = p_inventory_item_id;
295:
296: RETURN(v_item_number);