1333: tmp2.PJ_GL_CALENDAR_ID,
1334: tmp2.PJ_PA_CALENDAR_ID,
1335: tmp2.TXN_CURRENCY_CODE
1336: ) tmp2,
1337: PJI_TIME_CAL_PERIOD_V gl_cal,
1338: PJI_TIME_CAL_PERIOD_V pa_cal,
1339: PJI_FM_AGGR_RES_TYPES res_typs,
1340: (
1341: select
1334: tmp2.PJ_PA_CALENDAR_ID,
1335: tmp2.TXN_CURRENCY_CODE
1336: ) tmp2,
1337: PJI_TIME_CAL_PERIOD_V gl_cal,
1338: PJI_TIME_CAL_PERIOD_V pa_cal,
1339: PJI_FM_AGGR_RES_TYPES res_typs,
1340: (
1341: select
1342: cat.CATEGORY_ID ITEM_CATEGORY_ID,
2272: tmp2.GL_CALENDAR_ID,
2273: tmp2.PA_CALENDAR_ID,
2274: tmp2.TXN_CURRENCY_CODE
2275: ) tmp2,
2276: PJI_TIME_CAL_PERIOD_V gl_cal,
2277: PJI_TIME_CAL_PERIOD_V pa_cal,
2278: (
2279: select 'ENT' INVERT_ID from dual union all
2280: select 'GL' INVERT_ID from dual union all
2273: tmp2.PA_CALENDAR_ID,
2274: tmp2.TXN_CURRENCY_CODE
2275: ) tmp2,
2276: PJI_TIME_CAL_PERIOD_V gl_cal,
2277: PJI_TIME_CAL_PERIOD_V pa_cal,
2278: (
2279: select 'ENT' INVERT_ID from dual union all
2280: select 'GL' INVERT_ID from dual union all
2281: select 'PA' INVERT_ID from dual