1. Tables and Views for Financials
  2. GL_PERIODS_AUTOPOST_V

GL_PERIODS_AUTOPOST_V

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: VIEW

Columns

Name

PERIOD_NAME_DISPLAY

PERIOD_NAME

PERIOD_YEAR

PERIOD_NUM

PERIOD_SET_NAME

PERIOD_TYPE

Query

SQL_Statement

SELECT

period_name period_name_display,

period_name,

period_year,

period_num,

period_set_name,

period_type

FROM

gl_periods

UNION

ALL

SELECT

meaning period_name_display,

lookup_code period_name,

9999 as period_year,

9999 as period_num,

lookup_code as period_set_name,

lookup_code as period_type

FROM

gl_lookups

WHERE

lookup_type = 'LITERAL'

AND lookup_code = 'ALL'