SELECT NVL (f.currency_code, d.invoice_currency_code) currency_code, d.invoice_amount, d.wfapproval_status, d.invoice_num, d.invoice_id, i.segment1 v_code, i.vendor_name, NVL (d.invoice_amount, 0) – NVL (d.amount_paid, 0) amt, SUM (a.acctd_rounded_cr) – SUM (a.acctd_rounded_dr) amount, b.accounting_date, f.segment1 po_num, f.comments…
Read MoreSELECT gjh.doc_sequence_value vch_num, gjl.effective_date, xal.currency_code, xal.currency_conversion_rate con_rate, xal.entered_dr entered_dr, xal.entered_cr entered_cr, xal.accounted_dr amount_dr, xal.accounted_cr amount_cr, xal.description, aia.invoice_num, aia.SOURCE, rsh.receipt_num FROM ap_invoices_all aia, ap_invoice_lines_all aila, ap_invoice_distributions_all aida, xla.xla_transaction_entities xte, xla_ae_headers xah, …
Read MoreSELECT /*+ Index(xdl XLA_DISTRIBUTION_LINKS_N3) */ DISTINCT gjh.doc_sequence_value gl_vou_num, ac.check_id, xal.source_id, aipa.invoice_payment_id, gjl.effective_date accounting_date, xal.accounted_dr, xal.accounted_cr, aps.segment1 vendor_code, aps.vendor_name vendor_name, aipa.invoice_id, aia.invoice_num, aia.invoice_date, aia.invoice_currency_code cur, aia.invoice_amount inv_amt_frc, aia.exchange_rate inv_exc_rate, aia.exchange_date inv_exc_date, …
Read MoreSELECT SUM (xal.accounted_cr), SUM (xal.accounted_dr), aia.invoice_amount, invoice_num FROM ap_invoices_all aia, ap_invoice_payments_all aipa, ap_checks_all aca, xla.xla_transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal, gl.gl_import_references gir, gl_je_lines gjl, gl_je_headers gjh WHERE 1 = 1 …
Read MoreSELECT SUM (xal.accounted_cr), SUM (xal.accounted_dr), aia.invoice_amount, invoice_num FROM ap_invoices_all aia, xla.xla_transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal, gl.gl_import_references gir, gl_je_lines gjl, gl_je_headers gjh WHERE 1 = 1 AND aia.invoice_id = NVL…
Read MoreError: JBO-25006: Invalid parameter value PosViewShipmentsVO for destination passed to method ViewLinkImpl.setDestination. Explanation: view def mismatch. Root Cause for the Error : While extending a Seeded VO ( that has a Seeded…
Read MoreHow to Add/Assign the Printer to a desired Report Responsibility: Order Management Super User Navigation: Setup > Shipping > Documents > Choose Printers “Choose Document and Label Printers” Page will…
Read MoreSetups for Discoverer Desktop The following steps have to be implemented after installation of Discoverer Administrator and Discoverer Desktop: 1. In Discoverer Desktop, go to tools –> options –> Connections…
Read MoreEliminating block.field issue while upgrading from EBS R11i to R12 versions Problem In 11i, Customers are accessed through Oracle forms where :block.field reference is allowed to dynamically bring values in value…
Read More