eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RBS_MAPPING dependencies on PJI_FP_TXN_ACCUM

Line 1936: --SELECT /+ ORDERED index(accum pji_fp_txn_accum_n2)/

1932: WHERE fin7.project_id = map.project_id
1933: AND map.worker_id = p_worker_id
1934: AND fin7.recvr_period_type='GL'
1935: UNION ALL
1936: --SELECT /*+ ORDERED index(accum pji_fp_txn_accum_n2)*/
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

Line 1937: SELECT /+ ORDERED USE_NL(map, accum) index(accum pji_fp_txn_accum_n2)/ --AECOM added ordered and use_nl bug 6739719

1933: AND map.worker_id = p_worker_id
1934: AND fin7.recvr_period_type='GL'
1935: UNION ALL
1936: --SELECT /*+ ORDERED index(accum pji_fp_txn_accum_n2)*/
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

Line 1942: pji_fp_txn_accum accum

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'
1946: UNION ALL

Line 1947: --SELECT /+ ORDERED index(accum1 pji_fp_txn_accum1_n1)/

1943: WHERE accum.project_id = map.project_id
1944: AND map.worker_id = p_worker_id
1945: AND accum.recvr_period_type='GL'
1946: UNION ALL
1947: --SELECT /*+ ORDERED index(accum1 pji_fp_txn_accum1_n1)*/
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

Line 1948: SELECT /+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)/ --AECOM added ordered and use_nl bug 6739719

1944: AND map.worker_id = p_worker_id
1945: AND accum.recvr_period_type='GL'
1946: UNION ALL
1947: --SELECT /*+ ORDERED index(accum1 pji_fp_txn_accum1_n1)*/
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

Line 1953: pji_fp_txn_accum1 accum1

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

Line 2090: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head

2086: SAVEPOINT map_rbs_txn;
2087:
2088: SELECT distinct head.revenue_category
2089: BULK COLLECT INTO l_revenue_category
2090: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head
2091: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i)
2092: AND tmp.txn_accum_header_id = head.txn_accum_header_id
2093: AND head.revenue_category IS NOT NULL
2094: AND head.revenue_category NOT IN

Line 2158: pji_fp_txn_accum_header head

2154: decode(head.person_id,-1,null,head.person_id), --- named person
2155: decode(head.bom_equipment_resource_id,-1,null,head.bom_equipment_resource_id), --- BOM equipment
2156: decode(head.bom_labor_resource_id,-1,null,head.bom_labor_resource_id) --- BOM labor
2157: FROM pa_rbs_map_tmp1 tmp,
2158: pji_fp_txn_accum_header head
2159: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i) AND
2160: tmp.txn_accum_header_id = head.txn_accum_header_id;
2161:
2162:

Line 2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header

2284: pa_debug.g_err_stage:= 'rbs version is provided';
2285: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2286: END IF;
2287:
2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2289: --assuming that source_id is populated in pji_fp_txn_accum_header
2290:
2291: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required

Line 2289: --assuming that source_id is populated in pji_fp_txn_accum_header

2285: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2286: END IF;
2287:
2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2289: --assuming that source_id is populated in pji_fp_txn_accum_header
2290:
2291: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2293:

Line 2291: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl

2287:
2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2289: --assuming that source_id is populated in pji_fp_txn_accum_header
2290:
2291: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2293:
2294: SELECT distinct revenue_category_code
2295: BULK COLLECT INTO l_revenue_category

Line 2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required

2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2289: --assuming that source_id is populated in pji_fp_txn_accum_header
2290:
2291: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2293:
2294: SELECT distinct revenue_category_code
2295: BULK COLLECT INTO l_revenue_category
2296: FROM PA_RBS_PLANS_IN_TMP

Line 2328: lockhndl := auto_allocate_unique('LOCK_PJI_FP_TXN_ACCUM_HEADER');

2324: END;
2325:
2326:
2327: /* added for bug#4102476, 4101364 */
2328: lockhndl := auto_allocate_unique('LOCK_PJI_FP_TXN_ACCUM_HEADER');
2329: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;
2330: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2331: raise can_not_lock_header;
2332: END IF;

Line 2334: INSERT INTO PJI_FP_TXN_ACCUM_HEADER(

2330: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2331: raise can_not_lock_header;
2332: END IF;
2333:
2334: INSERT INTO PJI_FP_TXN_ACCUM_HEADER(
2335: txn_accum_header_id,
2336: vendor_id,
2337: project_role_id,
2338: revenue_category,

Line 2367: PJI_FP_TXN_ACCUM_HEADER_S.nextval ,

2363: CREATION_DATE,
2364: CREATED_BY,
2365: LAST_UPDATE_LOGIN )
2366: SELECT
2367: PJI_FP_TXN_ACCUM_HEADER_S.nextval ,
2368: decode(TAB1.supplier_id,null,-1,TAB1.supplier_id),
2369: decode(TAB1.role_id,null,-1,TAB1.role_id),
2370: decode(TAB1.revenue_category_code,null,'PJI$NULL',TAB1.revenue_category_code),
2371: decode(TAB1.resource_class_id,null,-1,TAB1.resource_class_id) ,

Line 2420: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2416: person_type_code
2417: FROM PA_RBS_PLANS_IN_TMP
2418: WHERE rowid NOT IN
2419: (SELECT /*+ ordered */ tmp.rowid
2420: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2421: WHERE
2422: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2423: head.project_role_id = nvl(tmp.role_id,-1) AND
2424: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND

Line 2502: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2498: tmp.person_id,
2499: tmp.bom_equipment_id,
2500: tmp.bom_labor_id,
2501: tmp.person_type_code
2502: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2503: WHERE
2504: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2505: head.project_role_id = nvl(tmp.role_id,-1) AND
2506: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND