VIEW: PJI.PJI_ORG_EXTR_INFO#

Source

View Text - Preformatted

select ORG_ID ORG_ID, PF_CURRENCY_CODE PF_CURRENCY_CODE, EN_CALENDAR_MIN_DATE EN_CALENDAR_MIN_DATE, EN_CALENDAR_MAX_DATE EN_CALENDAR_MAX_DATE, GL_CALENDAR_ID GL_CALENDAR_ID, GL_CALENDAR_MIN_DATE GL_CALENDAR_MIN_DATE, GL_CALENDAR_MAX_DATE GL_CALENDAR_MAX_DATE, PA_CALENDAR_ID PA_CALENDAR_ID, PA_CALENDAR_MIN_DATE PA_CALENDAR_MIN_DATE, PA_CALENDAR_MAX_DATE PA_CALENDAR_MAX_DATE, PROJFUNC_CURRENCY_MAU PROJFUNC_CURRENCY_MAU, PA_FIRST_PERIOD_ID PA_FIRST_PERIOD_ID, PA_FIRST_PERIOD_NAME PA_FIRST_PERIOD_NAME, PA_FIRST_START_DATE PA_FIRST_START_DATE, PA_FIRST_END_DATE PA_FIRST_END_DATE, GL_FIRST_PERIOD_ID GL_FIRST_PERIOD_ID, GL_FIRST_PERIOD_NAME GL_FIRST_PERIOD_NAME, GL_FIRST_START_DATE GL_FIRST_START_DATE, GL_FIRST_END_DATE GL_FIRST_END_DATE, PA_CURR_REP_PERIOD PA_CURR_REP_PERIOD, GL_CURR_REP_PERIOD GL_CURR_REP_PERIOD from "PJI"."PJI_ORG_EXTR_INFO"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, PF_CURRENCY_CODE PF_CURRENCY_CODE
, EN_CALENDAR_MIN_DATE EN_CALENDAR_MIN_DATE
, EN_CALENDAR_MAX_DATE EN_CALENDAR_MAX_DATE
, GL_CALENDAR_ID GL_CALENDAR_ID
, GL_CALENDAR_MIN_DATE GL_CALENDAR_MIN_DATE
, GL_CALENDAR_MAX_DATE GL_CALENDAR_MAX_DATE
, PA_CALENDAR_ID PA_CALENDAR_ID
, PA_CALENDAR_MIN_DATE PA_CALENDAR_MIN_DATE
, PA_CALENDAR_MAX_DATE PA_CALENDAR_MAX_DATE
, PROJFUNC_CURRENCY_MAU PROJFUNC_CURRENCY_MAU
, PA_FIRST_PERIOD_ID PA_FIRST_PERIOD_ID
, PA_FIRST_PERIOD_NAME PA_FIRST_PERIOD_NAME
, PA_FIRST_START_DATE PA_FIRST_START_DATE
, PA_FIRST_END_DATE PA_FIRST_END_DATE
, GL_FIRST_PERIOD_ID GL_FIRST_PERIOD_ID
, GL_FIRST_PERIOD_NAME GL_FIRST_PERIOD_NAME
, GL_FIRST_START_DATE GL_FIRST_START_DATE
, GL_FIRST_END_DATE GL_FIRST_END_DATE
, PA_CURR_REP_PERIOD PA_CURR_REP_PERIOD
, GL_CURR_REP_PERIOD GL_CURR_REP_PERIOD
FROM "PJI"."PJI_ORG_EXTR_INFO"