DBA Data[Home] [Help]

APPS.PO_AP_INVOICE_MATCH_GRP dependencies on RCV_TRANSACTIONS

Line 402: p_receive_transaction_id IN RCV_TRANSACTIONS.transaction_id%TYPE,

398: --End of Comments
399: -------------------------------------------------------------------------------------------------
400:
401: PROCEDURE get_po_ship_amounts (p_api_version IN NUMBER,
402: p_receive_transaction_id IN RCV_TRANSACTIONS.transaction_id%TYPE,
403: x_ship_amt_ordered OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount%TYPE,
404: x_ship_amt_cancelled OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount_cancelled%TYPE,
405: x_ret_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,

Line 432: rcv_transactions rt

428: pll.amount_cancelled
429: INTO x_ship_amt_ordered,
430: x_ship_amt_cancelled
431: FROM po_line_locations pll,
432: rcv_transactions rt
433: WHERE rt.po_line_location_id = pll.line_location_id
434: AND rt.transaction_id = p_receive_transaction_id;
435:
436: EXCEPTION