APPS.PA_CMT_UTILS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 99: ap_invoice_distributions_all apd

95:
96: select sum(apd.quantity_invoiced)
97: into l_qty_billed
98: from po_distributions_all pod,
99: ap_invoice_distributions_all apd
100: where pod.po_distribution_id = p_po_dist
101: and pod.po_distribution_id = apd.po_distribution_id
102: and NVL(pod.accrue_on_receipt_flag,'N') = 'Y'
103: and apd.pa_addition_flag = 'Y'

Line 369: from ap_invoice_distributions_all dist,

365:
366: select count(*),
367: SUM(dist.pa_quantity*(SUM(nvl(paydist.paid_base_amount,paydist.amount))/(nvl(dist.base_amount,dist.amount))))
368: into l_inv_num, l_tot_inv_qty
369: from ap_invoice_distributions_all dist,
370: ap_payment_hist_dists paydist,
371: ap_invoices_all inv
372: where dist.po_distribution_id = p_po_dist
373: and dist.charge_applicable_to_dist_id is null --R12 change

Line 392: from ap_invoice_distributions_all dist,

388:
389: ELSE
390: select count(*), sum(dist.pa_quantity)
391: into l_inv_num, l_tot_inv_qty
392: from ap_invoice_distributions_all dist,
393: ap_invoices_all inv
394: where dist.po_distribution_id = p_po_dist
395: -- and dist.line_type_lookup_code = 'ITEM' --R12 change
396: and dist. line_type_lookup_code <> 'REC_TAX'

Line 518: from ap_invoice_distributions_all

514: sum(decode(p_denom_amt_flag,
515: 'Y', amount,
516: 'N', nvl(base_amount,amount)))
517: into l_inv_num, l_inv_amt
518: from ap_invoice_distributions_all
519: where po_distribution_id = p_po_dist
520: --and line_type_lookup_code = 'ITEM'
521: and line_type_lookup_code <> 'REC_TAX' -- R12 change
522: and nvl(reversal_flag,'N') <> 'Y' /* Bug 5673779 */

Line 531: from ap_invoice_distributions_all

527: select sum(decode(p_denom_amt_flag, /* Bug 4015448. Added Dummy Sum */
528: 'Y', amount,
529: 'N', nvl(base_amount,amount)))
530: into l_inv_amt
531: from ap_invoice_distributions_all
532: where po_distribution_id = p_po_dist
533: and invoice_id = p_invoice_id
534: -- and distribution_line_number = p_dist_line_num --R12 change
535: and invoice_distribution_id = p_inv_dist_id -- R12 change

Line 706: from ap_invoice_distributions_all dist

702: select decode(p_denom_amt_flag, /* Bug 4015448. Added Dummy Sum */
703: 'Y', dist.amount,
704: 'N', nvl(dist.base_amount,dist.amount))
705: into l_inv_amt
706: from ap_invoice_distributions_all dist
707: where invoice_id = p_invoice_id
708: and dist.invoice_distribution_id = p_inv_dist_id ;
709:
710: END IF ;