APPS.JAI_AP_RPT_APCR_PKG dependencies on PO_HEADERS_ALL

Line 1013: from po_headers_all

1009: select
1010: po_header_id,
1011: segment1,
1012: trunc(creation_date) po_date
1013: from po_headers_all
1014: where po_header_id =
1015: ( select po_header_id
1016: from po_distributions_all
1017: where po_distribution_id = p_po_distribution_id);

Line 1160: v_po_header_id po_headers_all.po_header_id%type;

1156:
1157:
1158:
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;

Line 1161: v_po_number po_headers_all.segment1%type;

1157:
1158:
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;