eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_REP_PERIODS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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