VIEW: APPS.PA_ALLOC_PERIODS_V

Source

View Text - Preformatted

SELECT 'PA' , period_name , start_date , end_date , org_id from pa_periods WHERE status in ('C','F','O','P','W') UNION select 'GL' ,glp.period_name ,glp.start_date ,glp. end_date ,c.org_id from gl_periods glp, gl_sets_of_books a, gl_period_statuses b, pa_implementations c where glp.period_set_name = a.period_set_name and glp.adjustment_period_flag = 'N' and glp.period_type = a.accounted_period_type and c.set_of_books_id=a.set_of_books_id and b.application_id=101 and b.set_of_books_id=c.set_of_books_id and b.period_name=glp.period_name and b.closing_status in ('C','F','O','P')

View Text - HTML Formatted

SELECT 'PA'
, PERIOD_NAME
, START_DATE
, END_DATE
, ORG_ID
FROM PA_PERIODS
WHERE STATUS IN ('C'
, 'F'
, 'O'
, 'P'
, 'W') UNION SELECT 'GL'
, GLP.PERIOD_NAME
, GLP.START_DATE
, GLP. END_DATE
, C.ORG_ID
FROM GL_PERIODS GLP
, GL_SETS_OF_BOOKS A
, GL_PERIOD_STATUSES B
, PA_IMPLEMENTATIONS C
WHERE GLP.PERIOD_SET_NAME = A.PERIOD_SET_NAME
AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
AND GLP.PERIOD_TYPE = A.ACCOUNTED_PERIOD_TYPE
AND C.SET_OF_BOOKS_ID=A.SET_OF_BOOKS_ID
AND B.APPLICATION_ID=101
AND B.SET_OF_BOOKS_ID=C.SET_OF_BOOKS_ID
AND B.PERIOD_NAME=GLP.PERIOD_NAME
AND B.CLOSING_STATUS IN ('C'
, 'F'
, 'O'
, 'P')