CMR_PERIOD_STATUSES_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
BU_ID PERIOD_SET_NAME LEDGER_ID LEGAL_ENTITY_ID PERIOD_TYPE PERIOD_NAME PERIOD_NUM PERIOD_YEAR START_DATE END_DATE LE_TIME_OFFSET SERVER_START_DATE SERVER_END_DATE

Query

SQL_Statement
SELECT BUSINESS_UNIT_ID BU_ID, PERIOD_SET_NAME PERIOD_SET_NAME, LEDGER_ID LEDGER_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PERIOD_TYPE PERIOD_TYPE, PERIOD_NAME PERIOD_NAME, PERIOD_NUM PERIOD_NUM, PERIOD_YEAR PERIOD_YEAR, START_DATE START_DATE, END_DATE END_DATE, LE_TIME_OFFSET LE_TIME_OFFSET, SERVER_START_DATE SERVER_START_DATE, SERVER_END_DATE SERVER_END_DATE FROM cmr_period_statuses