DBA Data[Home] [Help]

APPS.POS_AP_INVOICES_PKG dependencies on PO_HEADERS_ALL

Line 26: po_headers_all ph

22: CURSOR po_number_cursor IS
23: SELECT DISTINCT ph.segment1
24: FROM ap_invoice_distributions_all aid,
25: po_distributions_all pd,
26: po_headers_all ph
27: WHERE aid.invoice_id = l_invoice_id
28: AND aid.po_distribution_id = pd.po_distribution_id
29: AND pd.po_header_id = ph.po_header_id
30: AND ph.type_lookup_code = 'STANDARD'

Line 35: po_headers_all ph,

31: UNION ALL
32: SELECT DISTINCT (ph.segment1||'-'||pr.release_num)
33: FROM ap_invoice_distributions_all aid,
34: po_distributions_all pd,
35: po_headers_all ph,
36: po_releases_all pr
37: WHERE aid.invoice_id = l_invoice_id
38: AND aid.po_distribution_id = pd.po_distribution_id
39: AND pr.po_release_id = pd.po_release_id

Line 401: po_headers_all ph

397: CURSOR po_info_cursor IS
398: --using invoice lines
399: select distinct ph.segment1, ph.po_header_id, null
400: from ap_invoice_lines_all ail,
401: po_headers_all ph
402: where ail.invoice_id = l_invoice_id and
403: ail.po_release_id is null and
404: ph.po_header_id = ail.po_header_id and
405: ph.type_lookup_code = 'STANDARD'

Line 409: po_headers_all ph,

405: ph.type_lookup_code = 'STANDARD'
406: union all
407: select distinct (ph.segment1||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
408: from ap_invoice_lines_all ail,
409: po_headers_all ph,
410: po_releases_all pr
411: WHERE ail.invoice_id = l_invoice_id and
412: pr.po_release_id = ail.po_release_id and
413: ph.po_header_id = ail.po_header_id and

Line 420: po_headers_all ph

416: --using invoice distributions
417: /* SELECT DISTINCT ph.segment1,ph.po_header_id,null
418: FROM ap_invoice_distributions_all aid,
419: po_distributions_all pd,
420: po_headers_all ph
421: WHERE aid.invoice_id = l_invoice_id
422: AND aid.po_distribution_id = pd.po_distribution_id
423: AND pd.po_header_id = ph.po_header_id
424: AND ph.type_lookup_code = 'STANDARD'

Line 429: po_headers_all ph,

425: UNION ALL
426: SELECT DISTINCT (ph.segment1||'-'||pr.release_num),ph.po_header_id, pr.po_release_id
427: FROM ap_invoice_distributions_all aid,
428: po_distributions_all pd,
429: po_headers_all ph,
430: po_releases_all pr
431: WHERE aid.invoice_id = l_invoice_id
432: AND aid.po_distribution_id = pd.po_distribution_id
433: AND pr.po_release_id = pd.po_release_id