DBA Data[Home] [Help]

APPS.PO_AP_INVOICE_MATCH_GRP dependencies on RCV_TRANSACTIONS

Line 458: p_receive_transaction_id IN RCV_TRANSACTIONS.transaction_id%TYPE,

454: --End of Comments
455: -------------------------------------------------------------------------------------------------
456:
457: PROCEDURE get_po_ship_amounts (p_api_version IN NUMBER,
458: p_receive_transaction_id IN RCV_TRANSACTIONS.transaction_id%TYPE,
459: x_ship_amt_ordered OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount%TYPE,
460: x_ship_amt_cancelled OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount_cancelled%TYPE,
461: x_ret_status OUT NOCOPY VARCHAR2,
462: x_msg_count OUT NOCOPY NUMBER,

Line 488: rcv_transactions rt

484: pll.amount_cancelled
485: INTO x_ship_amt_ordered,
486: x_ship_amt_cancelled
487: FROM po_line_locations pll,
488: rcv_transactions rt
489: WHERE rt.po_line_location_id = pll.line_location_id
490: AND rt.transaction_id = p_receive_transaction_id;
491:
492: EXCEPTION