eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAAP_PWP_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 547: -- We pickup the payment details from ap_payment_schedules_all and vendor information from

543: ,X_msg_count OUT NOCOPY NUMBER
544: ,X_msg_data OUT NOCOPY VARCHAR2) IS
545:
546: -- Cursor C1 is to Fetch Supplier wise Invoice details at Invoice Header Level for a project.
547: -- We pickup the payment details from ap_payment_schedules_all and vendor information from
548: -- po_vendors.
549:
550: /****
551: Modified below cursor for Bug# 7833675:

Line 582: ap_payment_schedules_all appay,

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
586: where apd.project_id = P_project_Id

Line 611: ap_payment_schedules_all appay

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
615: and apd.posted_flag ='Y'