APPS.PJI_RM_SUM_AVL dependencies on PJI_RM_AGGR_RES2

Line 1448: So, for Enterprise periods, we select from PJI_RM_AGGR_RES2

1444: /*
1445: The idea is to determine all different periods and quarters for
1446: both enterprise and GL periods that are affected by the
1447: incremental change in the availability data.
1448: So, for Enterprise periods, we select from PJI_RM_AGGR_RES2
1449: and join it to FII_TIME_DAY to get appropriate distinct records
1450: for the periods/quarters/weeks affected. Similarly, for GL periods,
1451: we select from PJI_RM_AGGR_RES2 and join it to
1452: FII_TIME_CAL_DAY_MV and PJI_ORG_EXTR_INFO to get appropriate

Line 1451: we select from PJI_RM_AGGR_RES2 and join it to

1447: incremental change in the availability data.
1448: So, for Enterprise periods, we select from PJI_RM_AGGR_RES2
1449: and join it to FII_TIME_DAY to get appropriate distinct records
1450: for the periods/quarters/weeks affected. Similarly, for GL periods,
1451: we select from PJI_RM_AGGR_RES2 and join it to
1452: FII_TIME_CAL_DAY_MV and PJI_ORG_EXTR_INFO to get appropriate
1453: distinct records for the periods/quarters affected.
1454: */
1455: /*

Line 1512: index(tmp2. PJI_RM_AGGR_RES2_N1)

1508: end period_type
1509: FROM
1510: (
1511: SELECT /*+ ordered
1512: index(tmp2. PJI_RM_AGGR_RES2_N1)
1513: full(fiit) use_hash(fiit) */
1514: DISTINCT
1515: tmp2.expenditure_org_id as expenditure_org_id,
1516: p_worker_id as worker_id,

Line 1523: PJI_RM_AGGR_RES2 tmp2,

1519: tmp2.gl_calendar_id as gl_calendar_id,
1520: fiit.ent_qtr_id as qtr_id,
1521: (to_char(fiit.week_start_date,'j') - g_min_wk_j_st_date)/7 + 1 as week_id
1522: FROM
1523: PJI_RM_AGGR_RES2 tmp2,
1524: FII_TIME_DAY fiit
1525: WHERE
1526: tmp2.person_id = p_person_id
1527: and tmp2.time_id = fiit.report_date_julian

Line 1541: index(tmp2, PJI_RM_AGGR_RES2_N1)

1537: SELECT 2 as tmp_index from dual
1538: ) rt2
1539: UNION ALL
1540: SELECT /*+ ordered
1541: index(tmp2, PJI_RM_AGGR_RES2_N1)
1542: index(fiit, FII_TIME_CAL_DAY_MV_U1) */
1543: DISTINCT
1544: tmp2.expenditure_org_id as expenditure_org_id,
1545: p_worker_id as worker_id,

Line 1553: PJI_RM_AGGR_RES2 tmp2,

1549: 64 as period_type_id,
1550: fiit.cal_qtr_id as period_id,
1551: 'G' as period_type
1552: FROM
1553: PJI_RM_AGGR_RES2 tmp2,
1554: FII_TIME_CAL_DAY_MV fiit
1555: WHERE
1556: tmp2.person_id = p_person_id
1557: and to_date(to_char(tmp2.time_id), 'J') = fiit.report_date

Line 4785: tabname => 'PJI_RM_AGGR_RES2',

4781: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4782:
4783: -- implicit commit
4784: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4785: tabname => 'PJI_RM_AGGR_RES2',
4786: percent => 10,
4787: degree => BIS_COMMON_PARAMETERS.
4788: GET_DEGREE_OF_PARALLELISM);
4789: -- implicit commit

Line 4791: tabname => 'PJI_RM_AGGR_RES2',

4787: degree => BIS_COMMON_PARAMETERS.
4788: GET_DEGREE_OF_PARALLELISM);
4789: -- implicit commit
4790: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4791: tabname => 'PJI_RM_AGGR_RES2',
4792: colname => 'PERSON_ID',
4793: percent => 10,
4794: degree => BIS_COMMON_PARAMETERS.
4795: GET_DEGREE_OF_PARALLELISM);

Line 4877: SELECT DISTINCT person_id from PJI_RM_AGGR_RES2;

4873: --If this is the first time program is being run then'
4874: --no data would be present, so insert the resources
4875: --one needs to process
4876: INSERT INTO PJI_RM_RES_BATCH_MAP(person_id)
4877: SELECT DISTINCT person_id from PJI_RM_AGGR_RES2;
4878: END IF;
4879:
4880: -- implicit commit
4881: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,