APPS.JE_ITWHYE_AP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

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 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 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