DBA Data[Home] [Help]

APPS.GHG_UTILITIES_PKG dependencies on AP_INVOICES_ALL

Line 13: from ap_invoices_all

9: BEGIN
10:
11: select org_id
12: into v_org_id
13: from ap_invoices_all
14: where invoice_id = x_invoice_id;
15:
16: mo_global.set_policy_context_server(p_access_mode => 'S',p_org_id =>v_org_id);
17: -- Must be if one of the lines hits a facility.

Line 249: FROM ap_invoices_all ai,

245: aid.dist_code_combination_id code_combination_id,
246: aid.project,
247: aid.task,
248: aid.po_number
249: FROM ap_invoices_all ai,
250: ap_invoice_distributions_v aid,
251: fnd_lookup_values_vl xnlv
252: WHERE ai.invoice_id = p_invoice_id
253: AND aid.invoice_id = ai.invoice_id

Line 275: from ap_invoices_all

271: BEGIN
272:
273: select org_id
274: into v_org_id
275: from ap_invoices_all
276: where invoice_id = x_invoice_id;
277:
278: mo_global.set_policy_context_server(p_access_mode => 'S',p_org_id =>v_org_id);
279: -- Must be if one of the lines hits a facility.

Line 391: from ap_invoices_all a

387: , a.vendor_id
388: , a.vendor_site_id
389: , p.segment1 po_number
390: , a.org_id
391: from ap_invoices_all a
392: , ap_invoice_lines_all b
393: , po_headers_all p
394: where a.invoice_id = b.invoice_id
395: and b.po_header_id = p.po_header_id