[Home] [Help]
215: FROM po_vendor_sites pvss,
216: po_vendor_sites pvss2,
217: po_vendors pvds,
218: --Bugfix 5407632 - Using _all tables instead of views.
219: po_headers_all phs,
220: -- po_releases_all prs, /*Bug 5443196*/
221: po_lines_all pls,
222: po_line_locations_all plls,
223: rcv_shipment_headers rsh,
293: FROM po_vendor_sites pvss,
294: po_vendor_sites pvss2,
295: po_vendors pvds,
296: --Bugfix 5407632 - Using _all tables instead of views.
297: po_headers_all phs,
298: po_releases_all prs,
299: po_lines_all pls,
300: po_line_locations_all plls,
301: rcv_shipment_headers rsh,
390: plls.unit_meas_lookup_code -- 5100177
391: FROM po_vendor_sites pvss,
392: po_vendor_sites pvss2,
393: po_vendors pvds,
394: po_headers phs,
395: po_releases prs,
396: po_lines pls,
397: po_line_locations plls,
398: rcv_shipment_headers rsh,
649:
650: /*Bug#2492041 Get the Operating Unit for the PO */
651: select org_id
652: into x_org_id
653: from po_headers_all
654: where po_header_id = X_rcv_txns.po_header_id;
655:
656: IF (x_payment_currency_code is NULL) THEN
657: x_payment_currency_code := X_rcv_txns.currency_code;
2343: X_progress := '085';
2344: /*Bug#2492041 Get the Operating Unit for the PO */
2345: select org_id
2346: into x_org_id
2347: from po_headers_all
2348: where po_header_id = X_po_header_id;
2349:
2350: --Bug 3338268 - remove line item amt and qty calculations
2351: X_progress := '100';
2617:
2618: l_aging_period NUMBER;
2619: l_cutoff_date DATE;
2620: l_def_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2621: l_org_id po_headers.org_id%TYPE;
2622: l_invoice_desc ap_invoices_interface.description%TYPE;
2623:
2624: l_group_id ap_invoices_interface.group_id%TYPE;
2625: l_user_id NUMBER;