PJF_P_PERIODS_DATE_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
ORG_ID PA_PERIOD_NAME GL_PERIOD_NAME PA_PERIOD_START_DATE PA_PERIOD_END_DATE PRIMARY_LEDGER_ID PA_PERIOD_SET_NAME PA_PERIOD_TYPE PA_PERIOD_NUMBER PA_QUARTER_NUMBER PA_QUARTER_START_DATE PA_PERIOD_YEAR PA_YEAR_START_DATE

Query

SQL_Statement

SELECT PAPER.ORG_ID, PAPER.PERIOD_NAME PA_PERIOD_NAME, PAPER.GL_PERIOD_NAME GL_PERIOD_NAME, PAPER.START_DATE PA_PERIOD_START_DATE, PAPER.END_DATE PA_PERIOD_END_DATE, PAPER.PRIMARY_LEDGER_ID, PAGLPER.PERIOD_SET_NAME PA_PERIOD_SET_NAME, PAGLPER.PERIOD_TYPE PA_PERIOD_TYPE, PAGLPER.PERIOD_NUM PA_PERIOD_NUMBER, PAGLPER.QUARTER_NUM PA_QUARTER_NUMBER, PAGLPER.QUARTER_START_DATE PA_QUARTER_START_DATE, PAGLPER.PERIOD_YEAR PA_PERIOD_YEAR, PAGLPER.YEAR_START_DATE PA_YEAR_START_DATE FROM PJF_P_PERIODS_ALL_V PAPER, GL_PERIODS PAGLPER, GL_LEDGERS LEDGER WHERE PAPER.PERIOD_NAME = PAGLPER.PERIOD_NAME AND PAPER.PERIOD_SET_NAME= PAGLPER.PERIOD_SET_NAME AND PAPER.PA_PERIOD_TYPE = PAGLPER.PERIOD_TYPE AND PAPER.PRIMARY_LEDGER_ID = LEDGER.LEDGER_ID