APPS.PO_UNITEFF_PKG dependencies on RCV_SERIALS_SUPPLY

Line 20: -- RCV_SERIALS_SUPPLY table using the shipment_line_id.

16:
17: -- The design requires that an intransit shipment can only have
18: -- a single unit number. Hence, a distinct is used in the select
19: -- clause here. We obtain the serial number by mapping to the
20: -- RCV_SERIALS_SUPPLY table using the shipment_line_id.
21: -- Example: a shipment line contains an item of quantity 9.
22: -- Each of the 9 items have a different serial number.
23: -- However, all of these 9 items should only have a
24: -- single unit number.

Line 31: rcv_serials_supply rss

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;
35: