Search

Business units Query-Oracle Fusion

The below Query will be handy while fetching Business unit name in r13 instance.

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_DATE

FROM FUN_BU_USAGES_V FUBU, HR_OPERATING_UNITS HOU

WHERE FUBU.BUSINESS_UNIT_ID = HOU.ORGANIZATION_ID

AND FUBU.STATUS = 'A'

AND FUBU.CONFIGURATION_STATUS = 'Y'

AND SYSDATE BETWEEN NVL(HOU.DATE_FROM, SYSDATE - 1) AND NVL(HOU.DATE_TO, SYSDATE+1)

Hope this helps !

Recent Posts

See All

Call Fusion BIP Using ExternalReportWSSService Webservice

In this Post I will outline the steps to call a webservice using SOAP UI. you need below components to get start with . A report Created in ERP Cloud An obsolete path of the report Parameters if any C

Bank Statement Import and rejected Query - Oracle ERP Cloud

Imported Query : select hp.party_name "Bank Name", cba.bank_account_name, cba.bank_account_num, csh.statement_number, csl.trx_type, csl.flow_indicator, csl.amount from ce_statement_headers csh, ce_sta

Supplier and Site Query Oracle ERP Cloud

SELECT psv.vendor_name supplier_name, psv.vendor_id supplier_id, psv.segment1 supplier_number, psv.enabled_flag, psv.vendor_type_lookup_code, psv.one_time_flag, psv.start_date_active, psv.end_date_act

OIC Outbound Best-Practices & Guidelines

Tags

Archive

Business units Query-Oracle Fusion

Recent Posts

Other Posts you may Interested