[Home] [Help]
644: ,X_msg_count OUT NOCOPY NUMBER
645: ,X_msg_data OUT NOCOPY VARCHAR2) IS
646:
647: -- Cursor C1 is to Fetch Supplier wise Invoice details at Invoice Header Level for a project.
648: -- We pickup the payment details from ap_payment_schedules_all and vendor information from
649: -- po_vendors.
650:
651: /****
652: Modified below cursor for Bug# 7833675:
681: sum(amount_remaining)/nvl(appay.payment_cross_rate,1))) Paid_Inv_Amt, /* Bug# 8785535*/
682: apinv.invoice_Type_Lookup_code invoice_type, /*Added for bug 8293625 */
683: apinv.cancelled_date Cancelled_Date /*Added for bug 8293625 */
684: from ap_invoices_all apinv,
685: ap_payment_schedules_all appay,
686: po_vendors vend
687: where exIsts (select 1 from
688: ap_invoice_dIstributions_all apd
689: where apd.project_id = P_project_Id
725: apinv.invoice_Currency_code,
726: sum(amount_remaining),
727: sum(amount_remaining)/nvl(appay.payment_cross_rate,1))),0) Paid_Inv_Amt
728: from ap_invoices_all apinv,
729: ap_payment_schedules_all appay
730: where apinv.invoice_id = p_invoice_id and exIsts (select 1 from
731: ap_invoice_dIstributions_all apd
732: where apd.project_id = P_project_Id
733: and apd.posted_flag ='Y'
918: select app.Description,
919: app.GL_date,
920: (select meaning from FND_LOOKUP_VALUES where lookup_type = 'INVOICE TYPE'
921: and view_application_id =200 and language = USERENV('LANG') and lookup_code=app.invoice_type_lookup_code) invoice_type,
922: (select min(psd.due_date) from ap_payment_schedules_all psd where psd.invoice_id=app.invoice_id) earliest_due_date,
923: app.exchange_rate_type,
924: (select user_conversion_type from GL_DAILY_CONVERSION_TYPES where conversion_type=app.exchange_rate_type) exchange_rate_type1,-- Bug 8904838
925: app.exchange_date,
926: app.exchange_rate