APPS.PO_UNITEFF_PKG dependencies on MTL_SERIAL_NUMBERS

Line 10: * stored in MTL_SERIAL_NUMBERS.

6: * ---------------
7: * This function is called by PO_SHIP_RCV_SUPPLY_VIEW and
8: * PO_SHIP_SUPPLY_VIEW. Given a shipment line id and an item id,
9: * this function will return the end item unit number that is
10: * stored in MTL_SERIAL_NUMBERS.
11: */
12: FUNCTION GET_UNIT_NUMBER(p_shipment_line_id NUMBER, p_item_id NUMBER)
13: RETURN VARCHAR2 IS
14: v_end_item_unit_number VARCHAR2(30) := NULL;

Line 30: FROM mtl_serial_numbers msn,

26: -- shipment form should NOT allow this to occur in the first place.
27:
28: SELECT DISTINCT msn.end_item_unit_number
29: INTO v_end_item_unit_number
30: FROM mtl_serial_numbers msn,
31: rcv_serials_supply rss
32: WHERE msn.serial_number = rss.serial_num
33: AND rss.shipment_line_id = p_shipment_line_id
34: AND msn.inventory_item_id = p_item_id;