DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on AP_INVOICES_ALL

Line 581: from ap_invoices_all apinv,

577: decode(apinv.payment_Currency_code,
578: apinv.invoice_Currency_code,
579: sum(amount_remaining),
580: sum(amount_remaining)/nvl(apinv.exchange_rate,1))) Paid_Inv_Amt
581: from ap_invoices_all apinv,
582: ap_payment_schedules_all appay,
583: po_vendors vend
584: where exIsts (select 1 from
585: ap_invoice_dIstributions_all apd

Line 610: from ap_invoices_all apinv,

606: decode(apinv.payment_Currency_code,
607: apinv.invoice_Currency_code,
608: sum(amount_remaining),
609: sum(amount_remaining)/nvl(apinv.exchange_rate,1))),0) Paid_Inv_Amt
610: from ap_invoices_all apinv,
611: ap_payment_schedules_all appay
612: where apinv.invoice_id = p_invoice_id and exIsts (select 1 from
613: ap_invoice_dIstributions_all apd
614: where apd.project_id = P_project_Id