APPS.PA_CMT_UTILS dependencies on AP_INVOICES_ALL

Line 388: ap_invoices_all inv

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
391: and dist.related_id is null -- R12 change
392: and dist. line_type_lookup_code <> 'REC_TAX'

Line 410: ap_invoices_all inv

406: SUM(sat.pa_quantity*(SUM(nvl(paydist.paid_base_amount,paydist.amount))/(nvl(sat.base_amount,sat.amount))))
407: into l_inv_num2, l_tot_inv_qty2
408: from ap_self_assessed_tax_dist_all sat,
409: ap_payment_hist_dists paydist,
410: ap_invoices_all inv
411: where sat.po_distribution_id = p_po_dist
412: and sat.charge_applicable_to_dist_id is null
413: and sat.related_id is null
414: and sat. line_type_lookup_code <> 'REC_TAX'

Line 431: ap_invoices_all inv

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'
435: --and nvl(reversal_flag,'N') <> 'Y' /* Bug 5673779 */ /* Commented for Bug 13002754 -- Bug 13251424 */

Line 450: ap_invoices_all inv

446:
447: select count(*), sum(sat.pa_quantity)
448: into l_inv_num2, l_tot_inv_qty2
449: from ap_self_assessed_tax_dist_all sat,
450: ap_invoices_all inv
451: where sat.po_distribution_id = p_po_dist
452: and sat. line_type_lookup_code <> 'REC_TAX'
453: and nvl(reversal_flag,'N') <> 'Y'
454: and sat.charge_applicable_to_dist_id is null

Line 941: FROM ap_invoices_all

937: -- these records to 'G' status during "PRC : Interface supplier cost" process.
938:
939: CURSOR C_Valid_Invoice IS
940: SELECT 1
941: FROM ap_invoices_all
942: WHERE invoice_id = p_invoice_id
943: AND invoice_type_lookup_code <> 'EXPENSE REPORT'
944: AND nvl(source, 'xx' ) NOT IN ('PA_COST_ADJUSTMENTS');
945:

Line 952: FROM ap_invoices_all

948: -- R12.PJ:XB9:QA:APL: PREPAYMENT IN FOREIGN CURRENCY - FUNC COST INCORRECT IN PSI
949: --
950: CURSOR C_currency_attributes IS
951: SELECT exchange_rate
952: FROM ap_invoices_all
953: WHERE invoice_id = p_invoice_id ;
954:
955: l_av number;
956: l_base_av number;