DBA Data[Home] [Help]

APPS.JAI_AP_RPT_APCR_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 996: from rcv_shipment_headers

992:
993:
994: cursor c_get_receipt_num(p_transaction_id number) is
995: select receipt_num, trunc(creation_date) receipt_date
996: from rcv_shipment_headers
997: where shipment_header_id =
998: ( select shipment_header_id
999: from rcv_transactions
1000: where transaction_id = p_transaction_id);

Line 1121: v_receipt_num rcv_shipment_headers.receipt_num%type;

1117: v_run_no number;
1118: v_po_header_id po_headers_all.po_header_id%type;
1119: v_po_number po_headers_all.segment1%type;
1120: v_po_date date;
1121: v_receipt_num rcv_shipment_headers.receipt_num%type;
1122: v_receipt_date date;
1123: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
1124: v_po_release_num po_releases_all.release_num%type;
1125: v_po_release_date date;