DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 126: from rcv_shipment_headers

122:
123:
124: cursor c_get_receipt_num(p_transaction_id number) is
125: select receipt_num, trunc(creation_date) receipt_date
126: from rcv_shipment_headers
127: where shipment_header_id =
128: ( select shipment_header_id
129: from rcv_transactions
130: where transaction_id = p_transaction_id);

Line 255: v_receipt_num rcv_shipment_headers.receipt_num%type;

251: v_run_no number;
252: v_po_header_id po_headers_all.po_header_id%type;
253: v_po_number po_headers_all.segment1%type;
254: v_po_date date;
255: v_receipt_num rcv_shipment_headers.receipt_num%type;
256: v_receipt_date date;
257: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
258: v_po_release_num po_releases_all.release_num%type;
259: v_po_release_date date;