DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on PO_VENDORS

Line 548: -- po_vendors.

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:
552: Removed the discount calculation from here.

Line 583: po_vendors vend

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