APPS.PA_CMT_UTILS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 102: ap_invoice_distributions_all apd

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

Line 386: from ap_invoice_distributions_all dist,

382:
383: select count(*),
384: SUM(dist.pa_quantity*(SUM(nvl(paydist.paid_base_amount,paydist.amount))/(nvl(dist.base_amount,dist.amount))))
385: into l_inv_num, l_tot_inv_qty
386: from ap_invoice_distributions_all dist,
387: ap_payment_hist_dists paydist,
388: ap_invoices_all inv
389: where dist.po_distribution_id = p_po_dist
390: and dist.charge_applicable_to_dist_id is null --R12 change

Line 430: from ap_invoice_distributions_all dist,

426:
427: ELSE
428: select count(*), sum(dist.pa_quantity)
429: into l_inv_num, l_tot_inv_qty
430: from ap_invoice_distributions_all dist,
431: ap_invoices_all inv
432: where dist.po_distribution_id = p_po_dist
433: -- and dist.line_type_lookup_code = 'ITEM' --R12 change
434: and dist. line_type_lookup_code <> 'REC_TAX'

Line 587: from ap_invoice_distributions_all

583: sum(decode(p_denom_amt_flag,
584: 'Y', amount,
585: 'N', nvl(base_amount,amount)))
586: into l_inv_num, l_inv_amt
587: from ap_invoice_distributions_all
588: where po_distribution_id = p_po_dist
589: --and line_type_lookup_code = 'ITEM'
590: and line_type_lookup_code <> 'REC_TAX' -- R12 change
591: --and nvl(reversal_flag,'N') <> 'Y' /* Bug 5673779 */ /* Commented for Bug 13002754 -- Bug 13251424 */

Line 615: from ap_invoice_distributions_all

611: select sum(decode(p_denom_amt_flag, /* Bug 4015448. Added Dummy Sum */
612: 'Y', amount,
613: 'N', nvl(base_amount,amount)))
614: into l_inv_amt
615: from ap_invoice_distributions_all
616: where po_distribution_id = p_po_dist
617: and invoice_id = p_invoice_id
618: -- and distribution_line_number = p_dist_line_num --R12 change
619: and invoice_distribution_id = p_inv_dist_id -- R12 change

Line 805: from ap_invoice_distributions_all dist

801: select decode(p_denom_amt_flag, /* Bug 4015448. Added Dummy Sum */
802: 'Y', dist.amount,
803: 'N', nvl(dist.base_amount,dist.amount))
804: into l_inv_amt
805: from ap_invoice_distributions_all dist
806: where invoice_id = p_invoice_id
807: and dist.invoice_distribution_id = p_inv_dist_id ;
808:
809: -- Bug 13602288: Added below select query as a part of self assessed tax enhancement