DBA Data[Home] [Help]

VIEW: PA.PA_PERIODS_ALL#

Source

View Text - Preformatted

select PERIOD_NAME PERIOD_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, START_DATE START_DATE, END_DATE END_DATE, STATUS STATUS, GL_PERIOD_NAME GL_PERIOD_NAME, CURRENT_PA_PERIOD_FLAG CURRENT_PA_PERIOD_FLAG, ORG_ID ORG_ID from "PA"."PA_PERIODS_ALL"
View Text - HTML Formatted

SELECT PERIOD_NAME PERIOD_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, START_DATE START_DATE
, END_DATE END_DATE
, STATUS STATUS
, GL_PERIOD_NAME GL_PERIOD_NAME
, CURRENT_PA_PERIOD_FLAG CURRENT_PA_PERIOD_FLAG
, ORG_ID ORG_ID
FROM "PA"."PA_PERIODS_ALL"