DBA Data[Home] [Help]

APPS.JAI_AP_RPT_APCR_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 1038: from rcv_shipment_headers

1034:
1035:
1036: cursor c_get_receipt_num(p_transaction_id number) is
1037: select receipt_num, trunc(creation_date) receipt_date
1038: from rcv_shipment_headers
1039: where shipment_header_id =
1040: ( select shipment_header_id
1041: from rcv_transactions
1042: where transaction_id = p_transaction_id);

Line 1163: v_receipt_num rcv_shipment_headers.receipt_num%type;

1159: v_run_no number;
1160: v_po_header_id po_headers_all.po_header_id%type;
1161: v_po_number po_headers_all.segment1%type;
1162: v_po_date date;
1163: v_receipt_num rcv_shipment_headers.receipt_num%type;
1164: v_receipt_date date;
1165: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
1166: v_po_release_num po_releases_all.release_num%type;
1167: v_po_release_date date;