5905:
5906: PROCEDURE default_rti_from_pll(
5907: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
5908: ) IS
5909: pll po_line_locations_all%ROWTYPE;
5910: x_quantity NUMBER;
5911: BEGIN
5912: IF (rti.po_line_location_id IS NOT NULL) THEN
5913: pll := rcv_table_functions.get_pll_row_from_id(rti.po_line_location_id);
5948: */
5949:
5950: select nvl(poll.price_override,pol.unit_price)
5951: into pll.price_override
5952: from po_line_locations_all poll,
5953: po_lines_all pol
5954: where poll.line_location_id = pll.line_location_id
5955: and pol.po_line_id = poll.po_line_id;
5956:
6000: * for non-complex work POs.
6001: */
6002: select nvl(poll.description,pol.item_description)
6003: into pll.description
6004: from po_line_locations_all poll,
6005: po_lines_all pol
6006: where poll.line_location_id = pll.line_location_id
6007: and pol.po_line_id = poll.po_line_id;
6008: