DBA Data[Home] [Help]

APPS.PO_INVOICES_SV2 dependencies on PO_HEADERS

Line 229: po_headers_all phs,

225: FROM po_vendor_sites pvss,
226: po_vendor_sites pvss2,
227: po_vendors pvds,
228: --Bugfix 5407632 - Using _all tables instead of views.
229: po_headers_all phs,
230: -- po_releases_all prs, /*Bug 5443196*/
231: po_lines_all pls,
232: po_line_locations_all plls,
233: rcv_shipment_headers rsh,

Line 324: po_headers_all phs,

320: FROM po_vendor_sites pvss,
321: po_vendor_sites pvss2,
322: po_vendors pvds,
323: --Bugfix 5407632 - Using _all tables instead of views.
324: po_headers_all phs,
325: po_releases_all prs,
326: po_lines_all pls,
327: po_line_locations_all plls,
328: rcv_shipment_headers rsh,

Line 438: po_headers phs,

434: plls.unit_meas_lookup_code -- 5100177
435: FROM po_vendor_sites pvss,
436: po_vendor_sites pvss2,
437: po_vendors pvds,
438: po_headers phs,
439: po_releases prs,
440: po_lines pls,
441: po_line_locations plls,
442: rcv_shipment_headers rsh,

Line 704: from po_headers_all

700:
701: /*Bug#2492041 Get the Operating Unit for the PO */
702: select org_id
703: into x_org_id
704: from po_headers_all
705: where po_header_id = X_rcv_txns.po_header_id;
706:
707: IF (x_payment_currency_code is NULL) THEN
708: x_payment_currency_code := X_rcv_txns.currency_code;

Line 2458: from po_headers_all

2454: X_progress := '085';
2455: /*Bug#2492041 Get the Operating Unit for the PO */
2456: select org_id
2457: into x_org_id
2458: from po_headers_all
2459: where po_header_id = X_po_header_id;
2460:
2461: --Bug 3338268 - remove line item amt and qty calculations
2462: X_progress := '100';

Line 2774: l_org_id po_headers.org_id%TYPE;

2770:
2771: l_aging_period NUMBER;
2772: l_cutoff_date DATE;
2773: l_def_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2774: l_org_id po_headers.org_id%TYPE;
2775: l_invoice_desc ap_invoices_interface.description%TYPE;
2776:
2777: l_group_id ap_invoices_interface.group_id%TYPE;
2778: l_user_id NUMBER;