eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JE_ITWHYE_AP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 283: FROM ap_invoice_distributions_all dist1,ap_invoices_all inv1

279: 0
280: )
281: ) exempt_amount
282: ,dist1.invoice_id
283: FROM ap_invoice_distributions_all dist1,ap_invoices_all inv1
284: WHERE dist1.invoice_id = inv1.invoice_id
285: AND dist1.line_type_lookup_code = 'ITEM'
286: -- AND dist1.awt_group_id IS NULL
287: group by dist1.invoice_id)dist

Line 318: ap_invoice_distributions_all dist

314: GROUP BY aip_sub.invoice_id)
315: AND EXISTS (
316: SELECT 1
317: FROM ap_invoice_payments_all aip_sub2,
318: ap_invoice_distributions_all dist
319: WHERE aip_sub2.invoice_payment_id =
320: DECODE (dist.line_type_lookup_code,
321: 'AWT', dist.awt_invoice_payment_id,
322: aip_sub2.invoice_payment_id

Line 370: FROM ap_invoice_distributions_all dist,

366: SELECT count(1)rec_count
367: FROM ap_awt_group_taxes_all awt
368: WHERE awt.GROUP_ID IN (
369: SELECT DISTINCT dist.awt_origin_group_id
370: FROM ap_invoice_distributions_all dist,
371: ap_invoices_all inv
372: WHERE dist.invoice_id = inv.invoice_id
373: AND dist.line_type_lookup_code ='AWT'
374: AND inv.invoice_id = p_invoice_id

Line 449: FROM ap_invoice_distributions_all dist

445:
446: /* bug14369763
447: SELECT SUM (NVL (dist.base_amount, dist.amount))
448: INTO ln_ex_amount1
449: FROM ap_invoice_distributions_all dist
450: WHERE dist.invoice_id = cur_withholding_extract_rec.invoice_id
451: AND dist.line_type_lookup_code in ('ITEM','ACCRUAL')
452: AND dist.pay_awt_group_id IS NULL;
453:

Line 458: FROM ap_invoice_distributions_all dist

454: */
455:
456: SELECT SUM (NVL (dist.base_amount, dist.amount))
457: INTO ln_ex_amount2
458: FROM ap_invoice_distributions_all dist
459: WHERE dist.invoice_id = cur_withholding_extract_rec.invoice_id
460: AND dist.line_type_lookup_code in ('ITEM', 'ACCRUAL') --bug14369763
461: AND nvl(dist.pay_awt_group_id, nvl(dist.awt_group_id,dist.awt_origin_group_id)) IN ( --bug14369763
462: SELECT awgt_sub.GROUP_ID

Line 491: FROM ap_invoice_distributions_all dist

487:
488: /* bug14369763
489: SELECT SUM (NVL (dist.base_amount, dist.amount))
490: INTO ln_tax_amount_one
491: FROM ap_invoice_distributions_all dist
492: WHERE dist.invoice_id = cur_withholding_extract_rec.invoice_id
493: AND dist.line_type_lookup_code = 'ITEM'
494: AND dist.awt_group_id IS NULL;
495:

Line 502: FROM ap_invoice_distributions_all dist

498: */
499:
500: SELECT SUM (NVL (dist.base_amount, dist.amount))
501: INTO ln_tax_amount_two
502: FROM ap_invoice_distributions_all dist
503: , ap_awt_group_taxes_all awt
504: WHERE dist.invoice_id = invoice_id
505: AND NVL(dist.pay_awt_group_id,nvl(dist.awt_group_id, dist.awt_origin_group_id)) = awt.group_id --bug14369763
506: AND dist.org_id = awt.org_id

Line 572: from ap_invoice_distributions dist

568: into l_inv_gctot_base,
569: l_inv_gctot_etrd,
570: l_inv_whtot_base,
571: l_inv_whtot_etrd
572: from ap_invoice_distributions dist
573: where dist.invoice_id = cur_withholding_extract_rec.invoice_id
574: and exists (select 1
575: from ap_invoice_payments pay
576: where pay.invoice_payment_id = decode(dist.line_type_lookup_code,'AWT',

Line 623: FROM ap_invoice_distributions_all dist,

619: into ln_awt_group_id
620: FROM ap_awt_group_taxes_all awt
621: WHERE awt.GROUP_ID IN (
622: SELECT DISTINCT dist.awt_origin_group_id
623: FROM ap_invoice_distributions_all dist,
624: ap_invoices_all inv
625: WHERE dist.invoice_id = inv.invoice_id
626: AND dist.line_type_lookup_code ='AWT'
627: AND inv.invoice_id = cur_withholding_extract_rec.invoice_id

Line 646: from ap_invoice_distributions dist

642: select sum(nvl(amount,0))
643: into ln_gross_amount
644: from
645: ( select sum(nvl(dist.base_amount,nvl(dist.amount,0))) amount
646: from ap_invoice_distributions dist
647: where dist.invoice_id = cur_withholding_extract_rec.invoice_id
648: and dist.line_type_lookup_code <> 'AWT'
649: and nvl(dist.pay_awt_group_id,nvl(dist.awt_group_id,dist.awt_origin_group_id)) = ln_awt_group_id
650:

Line 654: from ap_invoice_distributions dist,

650:
651: UNION
652:
653: select sum(nvl(c.base_amount,nvl(c.amount,0))) amount
654: from ap_invoice_distributions dist,
655: ap_invoice_distributions c
656: where dist.invoice_id = cur_withholding_extract_rec.invoice_id
657: and c.invoice_id = cur_withholding_extract_rec.invoice_id
658: and dist.line_type_lookup_code <> 'AWT'

Line 655: ap_invoice_distributions c

651: UNION
652:
653: select sum(nvl(c.base_amount,nvl(c.amount,0))) amount
654: from ap_invoice_distributions dist,
655: ap_invoice_distributions c
656: where dist.invoice_id = cur_withholding_extract_rec.invoice_id
657: and c.invoice_id = cur_withholding_extract_rec.invoice_id
658: and dist.line_type_lookup_code <> 'AWT'
659: and c.CHARGE_APPLICABLE_TO_DIST_ID = dist.invoice_distribution_id

Line 692: FROM ap_invoice_distributions dist,

688: aps.vendor_name
689: INTO ln_irpef_rate, lc_irpef_taxname,
690: ln_irpef_wthamount,
691: lc_irpef_vendor_name
692: FROM ap_invoice_distributions dist,
693: ap_tax_codes atc,
694: ap_invoices inv1,
695: ap_awt_tax_rates awt,
696: ap_suppliers aps

Line 744: FROM ap_invoice_distributions dist,

740: aps.vendor_name
741: INTO ln_inps_rate, lc_inps_taxname,
742: ln_inps_wthamount,
743: lc_inps_vendor_name
744: FROM ap_invoice_distributions dist,
745: ap_tax_codes atc,
746: ap_invoices inv1,
747: ap_awt_tax_rates awt,
748: ap_suppliers aps

Line 805: ap_invoice_distributions_all apdist1_sub,

801: BEGIN
802: SELECT DISTINCT apinv_sub.invoice_num
803: INTO ln_inv_num
804: FROM ap_invoices_all apinv_sub,
805: ap_invoice_distributions_all apdist1_sub,
806: ap_invoice_distributions_all apdist2_sub
807: WHERE apdist2_sub.invoice_id = cur_withholding_extract_rec.invoice_id
808: AND apdist2_sub.invoice_distribution_id =
809: apdist1_sub.prepay_distribution_id

Line 806: ap_invoice_distributions_all apdist2_sub

802: SELECT DISTINCT apinv_sub.invoice_num
803: INTO ln_inv_num
804: FROM ap_invoices_all apinv_sub,
805: ap_invoice_distributions_all apdist1_sub,
806: ap_invoice_distributions_all apdist2_sub
807: WHERE apdist2_sub.invoice_id = cur_withholding_extract_rec.invoice_id
808: AND apdist2_sub.invoice_distribution_id =
809: apdist1_sub.prepay_distribution_id
810: AND apdist1_sub.invoice_id = apinv_sub.invoice_id