SUS_PERIOD_STATUSES_V

Details

• Schema: FUSION

• Object owner: SUS

• Object type: VIEW

Columns

Name
PERIOD_ID PERIOD_NAME PERIOD_TYPE PERIOD_YEAR PERIOD_NUM START_DATE END_DATE PERIOD_STATUS_CODE PERIOD_STATUS LEDGER_ID ADJUSTMENT_PERIOD_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT SPS.PERIOD_ID, SPS.PERIOD_NAME, SPS.PERIOD_TYPE, SPS.PERIOD_YEAR, SPS.PERIOD_NUM, SPS.START_DATE, SPS.END_DATE, SPS.PERIOD_STATUS_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_PERIOD_STATUSES' and lookup_code = SPS.PERIOD_STATUS_CODE) as PERIOD_STATUS, SPS.LEDGER_ID, SPS.ADJUSTMENT_PERIOD_FLAG, SPS.OBJECT_VERSION_NUMBER, SPS.CREATED_BY, SPS.CREATION_DATE, SPS.LAST_UPDATED_BY, SPS.LAST_UPDATE_DATE, SPS.LAST_UPDATE_LOGIN FROM SUS_PERIOD_STATUSES SPS