DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on PO_HEADERS_ALL

Line 106: from po_headers_all

102: select
103: po_header_id,
104: segment1,
105: trunc(creation_date) po_date
106: from po_headers_all
107: where po_header_id =
108: ( select po_header_id
109: from po_distributions_all
110: where po_distribution_id = p_po_distribution_id);

Line 257: v_po_header_id po_headers_all.po_header_id%type;

253:
254:
255:
256: v_run_no number;
257: v_po_header_id po_headers_all.po_header_id%type;
258: v_po_number po_headers_all.segment1%type;
259: v_po_date date;
260: v_receipt_num rcv_shipment_headers.receipt_num%type;
261: v_receipt_date date;

Line 258: v_po_number po_headers_all.segment1%type;

254:
255:
256: v_run_no number;
257: v_po_header_id po_headers_all.po_header_id%type;
258: v_po_number po_headers_all.segment1%type;
259: v_po_date date;
260: v_receipt_num rcv_shipment_headers.receipt_num%type;
261: v_receipt_date date;
262: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;