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);
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;
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;