Introduction This will displays the journal entry details SELECT DISTINCT –LEG_ENT.COUNTRY, (select DISTINCT HRL.COUNTRY from apps.XLE_ENTITY_PROFILES LEP, apps.XLE_REGISTRATIONS REG, apps.HR_LOCATIONS_ALL HRL, apps.gl_ledgers gl, apps.HR_OPERATING_UNITS HRO where LEP.TRANSACTING_ENTITY_FLAG = ‘Y’ and…
Read MoreREM HEADER REM $Header: cp_analyzer.sql v1.01 MCOSTA $ REM REM MODIFICATION LOG: REM REM MCOSTA REM REM Consolidated script to diagnose the current status and footprint of Concurrent Processing on…
Read MorePlease use the below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format…
Read MorePlease find the steps to export and import AWR stats. Exporting AWR snapshot data:- ***************************** SQL> @?/rdbms/admin/awrextr.sql AWR EXTRACT **************************************************** This script will extract the AWR data for a range of snapshots into a dump file. The script…
Read MoreThe following SQL script, when run as user SYS, will generate an ordered script to recreate all the java grants, and java policies, assigned to users. It does not generate…
Read MoreIntroduction: This will displays the Audit time taken for expenses CREATE OR REPLACE FUNCTION TIME_TAKEN(P_REPORT_HEADER_ID IN NUMBER,P_AUDIT_COMPLETE_DATE IN VARCHAR2,P_CLAIM_APPROVED_DATE IN VARCHAR2) RETURN VARCHAR2 IS LS_AUDIT_TAKEN VARCHAR2(100):=0; BEGIN SELECT SUM((TO_DATE(B.CASE_TIME,’DD-MON-YYYY HH24:MI:SS’)-TO_DATE(B.End_Dated_time,’DD-MON-YYYY…
Read MoreIntroduction: This will displays all the unpaid invoices details select hrou.name Operating_Unit, api.invoice_num Invoice_Number, decode(aid.MATCH_STATUS_FLAG, ‘A’,’Validated’, null, ‘Never Validated’, ‘N’, ‘Never Validated’, ‘T’,’Validated’, ‘S’,’Needs Revalidation’, aid.MATCH_STATUS_FLAG) Invoice_Status, api.invoice_date Invoice_Date, aps.segment1…
Read MoreIntroduction: The will displays all the Paid invoices details . Select “Operating Unit” ,”Invoice Number” ,”Invoice Date” ,”Supplier Number” ,”Supplier Name” ,”Supplier Site” ,”Supplier Pay Terms” ,”Supplier Payment Method” ,”Supplier…
Read MoreEmployees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreIntroduction: This report will display all the Non printed invoices details to business. select (SELECT B1.ACCOUNT_NUMBER FROM apps.hz_cust_accounts_all B1 WHERE A.BILL_TO_CUSTOMER_ID=B1.CUST_ACCOUNT_ID)ACCOUNT_NUMBER, (SELECT E.PARTY_SITE_NUMBER FROM apps.hz_cust_acct_sites_all C, apps.hz_cust_site_uses_all D, apps.hz_party_sites E,…
Read More