FUN_OU_BU_TEMP_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
BUSINESS_GROUP_ID ORGANIZATION_ID NAME DATE_FROM DATE_TO SHORT_CODE SET_OF_BOOKS_ID DEFAULT_LEGAL_CONTEXT_ID USABLE_FLAG

Query

SQL_Statement
SELECT BU.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BU.BU_ID ORGANIZATION_ID, BU.BU_NAME NAME, BU.DATE_FROM DATE_FROM, BU.DATE_TO DATE_TO, BU.SHORT_CODE SHORT_CODE, BU.PRIMARY_LEDGER_ID SET_OF_BOOKS_ID, BU.LEGAL_ENTITY_ID DEFAULT_LEGAL_CONTEXT_ID, NULL USABLE_FLAG FROM FUN_ALL_BUSINESS_UNITS_V BU WHERE STATUS = 'A'