FUN_FIN_BUSINESS_UNITS_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
BU_ID BU_NAME LOCATION_ID BUSINESS_GROUP_ID DATE_FROM DATE_TO MANAGER_ID LEGAL_ENTITY_ID PRIMARY_LEDGER_ID DEFAULT_SET_ID SHORT_CODE DEFAULT_CURRENCY_CODE STATUS CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT BU_ID , BU_NAME , LOCATION_ID , BUSINESS_GROUP_ID , DATE_FROM , DATE_TO , MANAGER_ID , LEGAL_ENTITY_ID , PRIMARY_LEDGER_ID , DEFAULT_SET_ID , SHORT_CODE , DEFAULT_CURRENCY_CODE , STATUS , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN FROM FUN_ALL_BUSINESS_UNITS_V WHERE EXISTS (SELECT 1 FROM FUN_BU_USAGES BUBF, FUN_BUSINESS_FUNCTIONS_B BF WHERE BUBF.BUSINESS_UNIT_ID = FUN_ALL_BUSINESS_UNITS_V.BU_ID AND BUBF.MODULE_ID = BF.BUSINESS_FUNCTION_ID AND BF.GENERATE_FIN_TXN_FLAG ='Y')