DB Hints
DB HINTS What is DB Hints? DB Hints / Optimizer Hints can be used with SQL statements to alter execution plans. What is the purpose of DB Hints? DB Hints…
Read MoreHash Joins
HASH JOINS Hash joins are used when two larger data sets are joined. Optimizer will look for the smaller one of two datasets and build the hash table based on…
Read MoreCode Review Tools
Code Review plays a essential role in the Software development Life cycle This Result in Higher quality code and avoid the cost and time which we suppose to spend after…
Read MoreCustomer Contact Creation Email Creation and assignment API
CREATE OR REPLACE PACKAGE XX_CUST_CONT_PKG IS –================= — Global Variables –================= gn_request_id NUMBER := apps.fnd_global.conc_request_id; gn_prog_appl_id NUMBER := apps.fnd_global.prog_appl_id;…
Read MoreFunction to Get Customer's Contact Primary and Secondary Email Addresses
CREATE OR REPLACE FUNCTION CUST_EMAIL_FUNC (p_bill_to_contact_id IN NUMBER, p_flag VARCHAR2) RETURN VARCHAR2 IS V_email VARCHAR2(1000): = NULL; BEGIN IF p_flag = ‘PRI’ THEN select cont_point.email_address into V_email …
Read MoreScript to extract Expenses SLA Details
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 MoreScript for getting PO SLA Details
SELECT DISTINCT pap.last_name || ‘, ‘ || pap.first_name AS “BUYER”, prh.segment1 AS “REQUISITION”, (SELECT …
Read MoreAP Web Report Workflow Status
SELECT ‘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 MoreScript to extract Goods Received Date for Suppliers along with Invoice and PO Information
select (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 MoreApex used to call the Oracle JOB scheduler and Java
Create 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 More