APPS.JE_IL_TAX_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 418: ap_invoice_distributions_all aid,

414: THEN 0
415: ELSE 1
416: END) countv
417: FROM ap_invoices_all ai,
418: ap_invoice_distributions_all aid,
419: ap_checks_all ac,
420: ap_invoice_payments_all aip,
421: po_vendors pvend,
422: po_vendor_sites_all pvs,

Line 462: ,ap_invoice_distributions_all aid

458: ELSE 1
459: END ) countv,
460: COUNT(distinct(ac.vendor_site_id)) countt
461: FROM ap_invoices_all ai
462: ,ap_invoice_distributions_all aid
463: ,ap_checks_all ac
464: ,ap_invoice_payments_all aip
465: WHERE ai.invoice_id = aid.invoice_id
466: AND ac.check_id=aip.check_id

Line 664: ap_invoice_distributions_all aid,

660:
661: CURSOR c_get_invwht_check (cn_invoice_id NUMBER) IS
662: SELECT ai.invoice_id invoice_id
663: FROM ap_invoice_payments_all aip,
664: ap_invoice_distributions_all aid,
665: ap_invoices_all ai
666: WHERE ai.invoice_id = cn_invoice_id
667: AND ai.invoice_id = aip.invoice_id
668: AND aip.invoice_id = aid.invoice_id

Line 677: FROM ap_invoice_distributions_all aid ,

673: CURSOR c_get_invevent_awt(cn_invoice_id NUMBER) IS
674: SELECT xdln.event_id event,
675: -- SUM(xdln.unrounded_accounted_dr) pay_amount Commented for bug 10279386
676: SUM(nvl(xdln.unrounded_accounted_dr,0)) - SUM(nvl(xdln.unrounded_accounted_cr,0)) pay_amount --modified for bug10279386
677: FROM ap_invoice_distributions_all aid ,
678: xla_distribution_links xdln,
679: xla_ae_headers xlah
680: WHERE aid.invoice_id = cn_invoice_id
681: AND aid.line_type_lookup_code = 'AWT'

Line 768: FROM ap_invoice_distributions_all aid ,

764: ELSIF ln_bank_awt_check <> 1 THEN
765:
766: BEGIN
767: SELECT SUM(xdln.unrounded_accounted_dr) INTO ln_invoice_amount
768: FROM ap_invoice_distributions_all aid ,
769: xla_distribution_links xdln,
770: xla_ae_headers xlah
771: WHERE aid.invoice_id = ln_invoice_id
772: AND aid.line_type_lookup_code <> 'AWT'

Line 885: ap_invoice_distributions_all aid,

881:
882: CURSOR c_get_invwht_check (cn_invoice_id NUMBER) IS
883: SELECT ai.invoice_id invoice_id
884: FROM ap_invoice_payments_all aip,
885: ap_invoice_distributions_all aid,
886: ap_invoices_all ai
887: WHERE ai.invoice_id = cn_invoice_id
888: AND ai.invoice_id = aip.invoice_id
889: AND aip.invoice_id = aid.invoice_id

Line 914: FROM ap_invoice_distributions_all aid

910:
911: -- Verify if the invoice has AWT distributions or not
912: SELECT count(1)
913: INTO l_inv_with_awt
914: FROM ap_invoice_distributions_all aid
915: WHERE aid.invoice_id = pn_invoice_id
916: AND aid.line_type_lookup_code = 'AWT'
917: AND aid.awt_flag ='A'
918: AND aid.awt_invoice_payment_id IS NOT NULL