SELECT WWOB.WORK_ORDER_NUMBER WO_NUMBER ,WWOT.WORK_ORDER_DESCRIPTION WO_DESCRIPTION ,WWST.WO_STATUS_NAME WO_STATUS ,HOU.NAME ORG_NAME ,CASE WHEN ROW_NUMBER() OVER (PARTITION BY HOU.NAME ORDER BY HOU.NAME) = 1 THEN HOU.NAME ELSE NULL END AS ORG_PARAMETER, CASE WHEN…
Read MoreSELECT Qry_rslt.”Supplier Name” ,Qry_rslt.”Supplier Number” ,Qry_rslt.”Supplier Site Name” ,Qry_rslt.”Supplier Status” ,Qry_rslt.”Inactive Date” ,Qry_rslt.”Procurement Business Unit” ,Qry_rslt.”Currency” ,Qry_rslt.”Total Amount” ,Qry_rslt.”No Data…
Read MoreIntroduction Business requested to provide the Payment reversal information Cause of the issue: Business want to cross check with Payment reversals How do we solve: We have created…
Read MoreIntroduction Business requested to provide the date for AR Adjustments for a particular period Cause of the issue: Business want to tally the data with uploaded Adjustments. How…
Read MoreIntroduction: This blog has the SQL query that can be used to pull the data access details of all the users irrespective of their status. Cause of the issue: Business…
Read MoreIntroduction: This blog has the SQL query that can be used to pull the data of employees who are recalled to join the organization. Cause of the issue: Business wants…
Read MoreIntroduction: This blog has the SQL query that can be used to pull Travel expense data from Fusion Expense Module. Cause of the issue: Business wants a report that contains…
Read MoreIntroduction: This blog has the SQL query that can be used to pull employee expenses data from Fusion Expense Module. Cause of the issue: Business wants a report that contains…
Read MoreThe below query extracts the list of employee users along with their user status and employee status SELECT pu.username USER_NAME ,papf.person_number EMPLOYEE_NUMBER ,ppn.first_name EMPLOYEE_FIRST_NAME ,ppn.last_name EMPLOYEE_LAST_NAME ,DECODE(SUSPENDED,'Y', 'Inactive User','N', 'Active…
Read MoreThe below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications. SELECT HP.party_name supplier_name ,SUP.segment1 supplier_number ,ZR.TAX_REGIME_CODE ,ZR.REGISTRATION_NUMBER tax_registration_number ,ZR.EFFECTIVE_FROM…
Read More