SELECT FUBU.BU_NAME, FUBU.SHORT_CODE, FUBU.STATUS, FUBU.MODULE_NAME,FUBU.CONFIGURATION_STATUS,TO_CHAR(HOU.DATE_FROM, 'MM/DD/YYYY') FROM_DATE,TO_CHAR(HOU.DATE_TO, 'MM/DD/YYYY') TO_DATEFROM FUN_BU_USAGES_V FUBU, HR_OPERATING_UNITS HOUWHERE FUBU.BUSINESS_UNIT_ID = HOU.ORGANIZATION_IDAND FUBU.STATUS = 'A'AND FUBU.CONFIGURATION_STATUS = 'Y'AND SYSDATE BETWEEN NVL(HOU.DATE_FROM, SYSDATE - 1) AND NVL(HOU.DATE_TO, SYSDATE+1)top of page
A Tech Journey: My experience with Oracle ERP, HCM Cloud, OCI, OIC, Salesforce, and other technologies
Fusiongoeasy.com
Tags
Archive
Search
Recent Posts
See AllAnyone new to the oracle fusion Assets can take advantage of these queries to find the joins and key columns Query1 : SELECT...
In this Post I will Explain the Various oracle Cloud Services at SaaS, PaaS and IaaS Levels
Other Posts you may Interested
bottom of page
Comments