DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 131: from rcv_shipment_headers

127:
128:
129: cursor c_get_receipt_num(p_transaction_id number) is
130: select receipt_num, trunc(creation_date) receipt_date
131: from rcv_shipment_headers
132: where shipment_header_id =
133: ( select shipment_header_id
134: from rcv_transactions
135: where transaction_id = p_transaction_id);

Line 260: v_receipt_num rcv_shipment_headers.receipt_num%type;

256: v_run_no number;
257: v_po_header_id po_headers_all.po_header_id%type;
258: v_po_number po_headers_all.segment1%type;
259: v_po_date date;
260: v_receipt_num rcv_shipment_headers.receipt_num%type;
261: v_receipt_date date;
262: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
263: v_po_release_num po_releases_all.release_num%type;
264: v_po_release_date date;