[Home] [Help]
1926: SELECT /*+ ORDERED USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */ --AECOM added ordered and use_nl bug 6739719
1927: fin7.project_id,
1928: txn_accum_header_id
1929: FROM
1930: pji_pjp_proj_batch_map map, -- Bug#5223360 - Peformance Fix
1931: pji_fm_aggr_fin7 fin7
1932: WHERE fin7.project_id = map.project_id
1933: AND map.worker_id = p_worker_id
1934: AND fin7.recvr_period_type='GL'
1937: SELECT /*+ ORDERED USE_NL(map, accum) index(accum pji_fp_txn_accum_n2)*/ --AECOM added ordered and use_nl bug 6739719
1938: accum.project_id,
1939: txn_accum_header_id
1940: FROM
1941: pji_pjp_proj_batch_map map, -- Bug#5223360 - Peformance Fix
1942: pji_fp_txn_accum accum
1943: WHERE accum.project_id = map.project_id
1944: AND map.worker_id = p_worker_id
1945: AND accum.recvr_period_type='GL'
1948: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/ --AECOM added ordered and use_nl bug 6739719
1949: accum1.project_id,
1950: txn_accum_header_id
1951: FROM
1952: pji_pjp_proj_batch_map map, -- Bug#5223360 - Peformance Fix
1953: pji_fp_txn_accum1 accum1
1954: WHERE accum1.project_id = map.project_id
1955: AND map.worker_id = p_worker_id
1956: UNION ALL
1957: SELECT /*+ORDERED*/DISTINCT
1958: ra.project_id,
1959: ra.txn_accum_header_id
1960: FROM
1961: pji_pjp_proj_batch_map map, -- Bug#5223360 - Peformance Fix
1962: pji_pjp_wbs_header wbs,
1963: pa_resource_assignments ra ,
1964: ( SELECT worker_id
1965: , event_type
1987: DISTINCT
1988: ra.project_id,
1989: ra.txn_accum_header_id
1990: FROM
1991: pji_pjp_proj_batch_map map,
1992: pji_pjp_wbs_header hd2, -- sub
1993: pa_resource_assignments ra,
1994: ( SELECT worker_id
1995: , event_type