DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on PO_HEADERS_ALL

Line 101: from po_headers_all

97: select
98: po_header_id,
99: segment1,
100: trunc(creation_date) po_date
101: from po_headers_all
102: where po_header_id =
103: ( select po_header_id
104: from po_distributions_all
105: where po_distribution_id = p_po_distribution_id);

Line 252: v_po_header_id po_headers_all.po_header_id%type;

248:
249:
250:
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;

Line 253: v_po_number po_headers_all.segment1%type;

249:
250:
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;