SELECT aerh.invoice_num “Report_Number”, papf.full_name “Employee_Name”, papf.employee_number “Emp_Number”, hou.NAME “Operating_Unit”, aerh.total “Amount”, aerh.default_currency_code “Currency”, (SELECT meaning FROM…
Read MoreSELECT DISTINCT pap.last_name || ‘, ‘ || pap.first_name AS “BUYER”, prh.segment1 AS “REQUISITION”, (SELECT …
Read MoreSELECT ‘WPAY’ TYPE, gl.segment1 division, gl.segment3 dcc, gl.segment4 ccc, h.report_submitted_date creation_date, (TRUNC (SYSDATE) – TRUNC (h.report_submitted_date)) days_old, …
Read Moreselect (select hou.name from apps.hr_operating_units hou where organization_id = (select org_id from apps.ap_invoices_all apa where apa.vendor_id = ap.vendor_id order by creation_date …
Read MoreCreate the html link on apex Ajax(Application Process) used to call the DBMS_SCHEDULER then generate the job name Ajax(Application Process) used to call the DBMS_SCHEDULER .CREATE_JOB then Execute the job…
Read MoreOracle APEX is user friendly for designing part as well as client side data entry and validation related things. Oracle BI Publisher is good for report output; it will give…
Read MoreJavascript Used to Get the Tabular Form Id Example : var eleTables = document.getElementsByTagName(“table”); for…
Read MoreAjax(Application Process) used call the Oracle Query of APEX_ITEM.MD5_CHECKSUM Java method of Math.random used to get Random no Random no used to get the Attribute value from Select list …
Read MoreGo to Shared Components then click the images link and upload the image to application. Click the Definition write the image name to logo text field as #WORKSPACE_IMAGES#company_logo.gif Go to…
Read MoreOne of the very good features of Oracle BI Publisher is its ability to burst and send the reports to multiple users simultaneously. Using BI Publisher’s bursting feature we can…
Read More