VIEW: APPS.PJI_TIME_PA_RPT_STR_MV

Source

View Text - Preformatted

SELECT rpt.CALENDAR_ID CALENDAR_ID, 'C' CALENDAR_TYPE, rpt.REPORT_DATE REPORT_DATE, 1 PERIOD_TYPE_ID, 4 RECORD_TYPE_ID, To_Number(To_char(wk.start_date,'j')) TIME_ID from PJI_TIME_CAL_RPT_STRUCT rpt, PJI_TIME_WEEK wk, ( select distinct cal.CALENDAR_ID from PA_TIME_CAL_NAME cal, GL_LEDGERS sob, PA_IMPLEMENTATIONS_ALL pi WHERE pi.SET_OF_BOOKS_ID = sob.LEDGER_ID and sob.PERIOD_SET_NAME = cal.PERIOD_SET_NAME and pi.PA_PERIOD_TYPE = cal.PERIOD_TYPE and nvl(fnd_profile.value_wnps('PA_EN_NEW_GLDATE_DERIVATION'),'N')<>'Y' union select distinct cal.CALENDAR_ID from PA_TIME_CAL_NAME cal, PA_IMPLEMENTATIONS_ALL pi where pi.PERIOD_SET_NAME = cal.PERIOD_SET_NAME and pi.PA_PERIOD_TYPE = cal.PERIOD_TYPE and nvl(fnd_profile.value_wnps('PA_EN_NEW_GLDATE_DERIVATION'), 'N')='Y' ) cal where rpt.PERIOD_TYPE_ID = 16 and rpt.TIME_ID = wk.WEEK_ID and rpt.CALENDAR_ID = cal.CALENDAR_ID

View Text - HTML Formatted

SELECT RPT.CALENDAR_ID CALENDAR_ID
, 'C' CALENDAR_TYPE
, RPT.REPORT_DATE REPORT_DATE
, 1 PERIOD_TYPE_ID
, 4 RECORD_TYPE_ID
, TO_NUMBER(TO_CHAR(WK.START_DATE
, 'J')) TIME_ID
FROM PJI_TIME_CAL_RPT_STRUCT RPT
, PJI_TIME_WEEK WK
, ( SELECT DISTINCT CAL.CALENDAR_ID
FROM PA_TIME_CAL_NAME CAL
, GL_LEDGERS SOB
, PA_IMPLEMENTATIONS_ALL PI
WHERE PI.SET_OF_BOOKS_ID = SOB.LEDGER_ID
AND SOB.PERIOD_SET_NAME = CAL.PERIOD_SET_NAME
AND PI.PA_PERIOD_TYPE = CAL.PERIOD_TYPE
AND NVL(FND_PROFILE.VALUE_WNPS('PA_EN_NEW_GLDATE_DERIVATION')
, 'N')<>'Y' UNION SELECT DISTINCT CAL.CALENDAR_ID
FROM PA_TIME_CAL_NAME CAL
, PA_IMPLEMENTATIONS_ALL PI
WHERE PI.PERIOD_SET_NAME = CAL.PERIOD_SET_NAME
AND PI.PA_PERIOD_TYPE = CAL.PERIOD_TYPE
AND NVL(FND_PROFILE.VALUE_WNPS('PA_EN_NEW_GLDATE_DERIVATION')
, 'N')='Y' ) CAL
WHERE RPT.PERIOD_TYPE_ID = 16
AND RPT.TIME_ID = WK.WEEK_ID
AND RPT.CALENDAR_ID = CAL.CALENDAR_ID