57:
58: -- PO_LINES_ALL.order_type_lookup_code
59: c_RATE CONSTANT VARCHAR2(5) := 'RATE';
60:
61: -- RCV_TRANSACTIONS_INTERFACE.transaction_status_code
62: c_PENDING CONSTANT VARCHAR2(10) := 'PENDING';
63:
64: -- Retroactive update mode
65: c_ALL_RELEASES CONSTANT VARCHAR2(30) := 'ALL_RELEASES';
707: FROM DUAL
708: WHERE EXISTS
709: ( SELECT null
710: FROM
711: RCV_TRANSACTIONS_INTERFACE RTI
712: , PO_LINE_LOCATIONS_ALL POLL
713: WHERE
714: RTI.po_line_location_id = POLL.line_location_id
715: AND POLL.po_line_id = p_line_id_tbl(i)