View: PA_REP_PERIODS_V

Product:	PA - Projects
Description:	PA_REP_PERIODS_V displays the type of the period ,year ,name
Implementation/DBA Data:	APPS.PA_REP_PERIODS_V

View Text

SELECT PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NAME
, MON_OR_QTR
, GE_WEEK_DT
, PERIOD_STATUS
, PERIOD_STATUS_CODE
, PERIOD_START_DATE
, EFFECTIVE_PERIOD_NUM
, PERIOD_END_DATE
, ORG_ID
FROM (SELECT 'PA' PERIOD_TYPE
, PAPERIOD.PERIOD_YEAR PERIOD_YEAR
, PAPERIOD.PERIOD_NAME PERIOD_NAME
, PAPERIOD.QUARTER_NUM MON_OR_QTR
, SYSDATE GE_WEEK_DT
, PAPERIOD.STATUS_MEANING PERIOD_STATUS
, PAPERIOD.STATUS PERIOD_STATUS_CODE
, PAPERIOD.PA_START_DATE PERIOD_START_DATE
, 0 EFFECTIVE_PERIOD_NUM
, PAPERIOD.PA_END_DATE PERIOD_END_DATE
, PAPERIOD.ORG_ID ORG_ID
FROM PA_PERIODS_V PAPERIOD UNION SELECT 'GL' PERIOD_TYPE
, GLPER.PERIOD_YEAR PERIOD_YEAR
, GLPER.PERIOD_NAME PERIOD_NAME
, GLPER.QUARTER_NUM MON_OR_QTR
, SYSDATE GE_WEEK_DT
, PRSTS.MEANING PERIOD_STATUS
, PRSTS.LOOKUP_CODE PERIOD_STATUS_CODE
, GLPER.START_DATE PERIOD_START_DATE
, GLPERSTS.EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM
, GLPER.END_DATE PERIOD_END_DATE
, IMP.ORG_ID ORG_ID
FROM PA_IMPLEMENTATIONS IMP
, GL_SETS_OF_BOOKS GL
, GL_PERIODS GLPER
, GL_PERIOD_STATUSES GLPERSTS
, GL_LOOKUPS PRSTS
, GL_DATE_PERIOD_MAP GLMAPS
WHERE IMP.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND GL.PERIOD_SET_NAME = GLPER.PERIOD_SET_NAME
AND GL.ACCOUNTED_PERIOD_TYPE = GLPER.PERIOD_TYPE
AND GLPERSTS.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND GLPERSTS.PERIOD_TYPE = GLPER.PERIOD_TYPE
AND GLPERSTS.PERIOD_NAME = GLPER.PERIOD_NAME
AND GLPERSTS.PERIOD_YEAR = GLPER.PERIOD_YEAR
AND GLPERSTS.CLOSING_STATUS = PRSTS.LOOKUP_CODE
AND GLMAPS.PERIOD_TYPE = GLPER.PERIOD_TYPE
AND GLMAPS.PERIOD_NAME = GLPER.PERIOD_NAME
AND GLMAPS.PERIOD_SET_NAME = GLPER.PERIOD_SET_NAME
AND GLPERSTS.APPLICATION_ID = PA_PERIOD_PROCESS_PKG.APPLICATION_ID
AND PRSTS.LOOKUP_CODE IN('C'
, 'F'
, 'N'
, 'O'
, 'P')
AND PRSTS.LOOKUP_TYPE ='CLOSING_STATUS' UNION SELECT 'QR' PERIOD_TYPE
, TO_NUMBER(TO_CHAR(YR.PERIOD_YEAR
, '0000')) PERIOD_YEAR
, PRL.MEANING||' '|| TO_CHAR(QTR.QUARTER_NUM) PERIOD_NAME
, QTR.QUARTER_NUM MON_OR_QTR
, SYSDATE GE_WEEK_DT
, ' ' PERIOD_STATUS
, ' ' PERIOD_STATUS_CODE
, TRUNC(SYSDATE) PERIOD_START_DATE
, 0 EFFECTIVE_PERIOD_NUM
, TRUNC(SYSDATE) PERIOD_END_DATE
, 0 ORG_ID
FROM PA_REP_QUARTER_GL_V QTR
, PA_LOOKUPS PRL
, PA_REP_YEAR_CAL_V YR
WHERE PRL.LOOKUP_TYPE = 'PA_REP_PERIOD_TYPES'
AND PRL.LOOKUP_CODE = 'QR' UNION SELECT 'GE' PERIOD_TYPE
, PERIOD_YEAR PERIOD_YEAR
, TO_CHAR((NEXT_DAY(TO_DATE('01-JAN-'||TO_CHAR(PERIOD_YEAR)
, 'DD-MON-YYYY')
, TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (SEQ_NUMBER-1) * 7) PERIOD_NAME
, TO_NUMBER(TO_CHAR(((NEXT_DAY(TO_DATE('01-JAN-'||TO_CHAR(PERIOD_YEAR)
, 'DD-MON-YYYY')
, TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (SEQ_NUMBER-1) * 7)-6
, 'MM')) MON_OR_QTR
, (NEXT_DAY(TO_DATE('01-JAN-'||TO_CHAR(PERIOD_YEAR)
, 'DD-MON-YYYY')
, TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (SEQ_NUMBER-1) * 7 GE_WEEK_DT
, ' ' PERIOD_STATUS
, ' ' PERIOD_STATUS_CODE
, ((NEXT_DAY(TO_DATE('01-JAN-'||TO_CHAR(PERIOD_YEAR)
, 'DD-MON-YYYY')
, TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (SEQ_NUMBER-1) * 7) - 6 PERIOD_START_DATE
, 0 EFFECTIVE_PERIOD_NUM
, TRUNC(SYSDATE) PERIOD_END_DATE
, 0 ORG_ID
FROM PA_REP_YEAR_CAL_V
, PA_REP_SEQ_NUMBER
WHERE SEQ_NUMBER BETWEEN 1
AND 53 AND TO_CHAR(((NEXT_DAY(TO_DATE('01-JAN-'||TO_CHAR(PERIOD_YEAR)
, 'DD-MON-YYYY')
, TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (SEQ_NUMBER-1) * 7) - 6
, 'YYYY') = PERIOD_YEAR) ORDER BY PERIOD_TYPE
, PERIOD_START_DATE

Columns