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 1945: SELECT /+ ORDERED USE_NL(map, accum) index(accum pji_fp_txn_accum_n2)/

1941: PJI_FM_AGGR_FIN7 FIN7
1942: WHERE FIN7.PROJECT_ID = MAP.PROJECT_ID
1943: AND FIN7.RECVR_PERIOD_TYPE='GL'
1944: UNION ALL
1945: SELECT /*+ ORDERED USE_NL(map, accum) index(accum pji_fp_txn_accum_n2)*/
1946: ACCUM.PROJECT_ID, TXN_ACCUM_HEADER_ID
1947: FROM gmap MAP,
1948: PJI_FP_TXN_ACCUM ACCUM
1949: WHERE ACCUM.PROJECT_ID = MAP.PROJECT_ID

Line 1948: PJI_FP_TXN_ACCUM ACCUM

1944: UNION ALL
1945: SELECT /*+ ORDERED USE_NL(map, accum) index(accum pji_fp_txn_accum_n2)*/
1946: ACCUM.PROJECT_ID, TXN_ACCUM_HEADER_ID
1947: FROM gmap MAP,
1948: PJI_FP_TXN_ACCUM ACCUM
1949: WHERE ACCUM.PROJECT_ID = MAP.PROJECT_ID
1950: AND ACCUM.RECVR_PERIOD_TYPE='GL'
1951: UNION ALL
1952: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/

Line 1952: SELECT /+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)/

1948: PJI_FP_TXN_ACCUM ACCUM
1949: WHERE ACCUM.PROJECT_ID = MAP.PROJECT_ID
1950: AND ACCUM.RECVR_PERIOD_TYPE='GL'
1951: UNION ALL
1952: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/
1953: ACCUM1.PROJECT_ID, TXN_ACCUM_HEADER_ID
1954: FROM gmap MAP,
1955: PJI_FP_TXN_ACCUM1 ACCUM1
1956: WHERE ACCUM1.PROJECT_ID = MAP.PROJECT_ID

Line 1955: PJI_FP_TXN_ACCUM1 ACCUM1

1951: UNION ALL
1952: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/
1953: ACCUM1.PROJECT_ID, TXN_ACCUM_HEADER_ID
1954: FROM gmap MAP,
1955: PJI_FP_TXN_ACCUM1 ACCUM1
1956: WHERE ACCUM1.PROJECT_ID = MAP.PROJECT_ID
1957: UNION ALL
1958: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) index ( wbs pji_pjp_wbs_header_n1 ) */
1959: DISTINCT RA.PROJECT_ID, RA.TXN_ACCUM_HEADER_ID

Line 2119: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head

2115: SAVEPOINT map_rbs_txn;
2116:
2117: SELECT distinct head.revenue_category
2118: BULK COLLECT INTO l_revenue_category
2119: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head
2120: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i)
2121: AND tmp.txn_accum_header_id = head.txn_accum_header_id
2122: AND head.revenue_category IS NOT NULL
2123: AND head.revenue_category NOT IN

Line 2187: pji_fp_txn_accum_header head

2183: decode(head.person_id,-1,null,head.person_id), --- named person
2184: decode(head.bom_equipment_resource_id,-1,null,head.bom_equipment_resource_id), --- BOM equipment
2185: decode(head.bom_labor_resource_id,-1,null,head.bom_labor_resource_id) --- BOM labor
2186: FROM pa_rbs_map_tmp1 tmp,
2187: pji_fp_txn_accum_header head
2188: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i) AND
2189: tmp.txn_accum_header_id = head.txn_accum_header_id;
2190:
2191:

Line 2330: SELECT /+ ORDERED USE_NL(map, accum) index(accum pji_fp_txn_accum_n2)/

2326: WHERE p_calling_mode in ( 'FULL', 'INCREMENTAL ' )
2327: AND FIN7.RECVR_PERIOD_TYPE='GL'
2328: AND FIN7.project_id = p_project_id
2329: UNION ALL
2330: SELECT /*+ ORDERED USE_NL(map, accum) index(accum pji_fp_txn_accum_n2)*/
2331: ACCUM.PROJECT_ID, TXN_ACCUM_HEADER_ID
2332: FROM PJI_FP_TXN_ACCUM ACCUM
2333: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2334: AND ACCUM.RECVR_PERIOD_TYPE='GL'

Line 2332: FROM PJI_FP_TXN_ACCUM ACCUM

2328: AND FIN7.project_id = p_project_id
2329: UNION ALL
2330: SELECT /*+ ORDERED USE_NL(map, accum) index(accum pji_fp_txn_accum_n2)*/
2331: ACCUM.PROJECT_ID, TXN_ACCUM_HEADER_ID
2332: FROM PJI_FP_TXN_ACCUM ACCUM
2333: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2334: AND ACCUM.RECVR_PERIOD_TYPE='GL'
2335: AND ACCUM.project_id = p_project_id
2336: UNION ALL

Line 2337: SELECT /+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)/

2333: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2334: AND ACCUM.RECVR_PERIOD_TYPE='GL'
2335: AND ACCUM.project_id = p_project_id
2336: UNION ALL
2337: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/
2338: ACCUM1.PROJECT_ID, TXN_ACCUM_HEADER_ID
2339: FROM PJI_FP_TXN_ACCUM1 ACCUM1
2340: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2341: AND ACCUM1.PROJECT_ID = p_project_id

Line 2339: FROM PJI_FP_TXN_ACCUM1 ACCUM1

2335: AND ACCUM.project_id = p_project_id
2336: UNION ALL
2337: SELECT /*+ ORDERED USE_NL(map, accum1) index(accum1 pji_fp_txn_accum1_n1)*/
2338: ACCUM1.PROJECT_ID, TXN_ACCUM_HEADER_ID
2339: FROM PJI_FP_TXN_ACCUM1 ACCUM1
2340: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2341: AND ACCUM1.PROJECT_ID = p_project_id
2342: UNION ALL
2343: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) */

Line 2450: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head

2446: SAVEPOINT map_rbs_txn;
2447:
2448: SELECT distinct head.revenue_category
2449: BULK COLLECT INTO l_revenue_category
2450: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head
2451: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i)
2452: AND tmp.txn_accum_header_id = head.txn_accum_header_id
2453: AND head.revenue_category IS NOT NULL
2454: AND head.revenue_category NOT IN

Line 2518: pji_fp_txn_accum_header head

2514: decode(head.person_id,-1,null,head.person_id), --- named person
2515: decode(head.bom_equipment_resource_id,-1,null,head.bom_equipment_resource_id), --- BOM equipment
2516: decode(head.bom_labor_resource_id,-1,null,head.bom_labor_resource_id) --- BOM labor
2517: FROM pa_rbs_map_tmp1 tmp,
2518: pji_fp_txn_accum_header head
2519: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i) AND
2520: tmp.txn_accum_header_id = head.txn_accum_header_id;
2521:
2522:

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

2619: pa_debug.g_err_stage:= 'rbs version is provided';
2620: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2621: END IF;
2622:
2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2624: --assuming that source_id is populated in pji_fp_txn_accum_header
2625:
2626: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required

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

2620: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2621: END IF;
2622:
2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2624: --assuming that source_id is populated in pji_fp_txn_accum_header
2625:
2626: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2628:

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

2622:
2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2624: --assuming that source_id is populated in pji_fp_txn_accum_header
2625:
2626: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2628:
2629: SELECT distinct revenue_category_code
2630: BULK COLLECT INTO l_revenue_category

Line 2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required

2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2624: --assuming that source_id is populated in pji_fp_txn_accum_header
2625:
2626: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2628:
2629: SELECT distinct revenue_category_code
2630: BULK COLLECT INTO l_revenue_category
2631: FROM PA_RBS_PLANS_IN_TMP

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

2659: END;
2660:
2661:
2662: /* added for bug#4102476, 4101364 */
2663: lockhndl := auto_allocate_unique('LOCK_PJI_FP_TXN_ACCUM_HEADER');
2664: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;
2665: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2666: raise can_not_lock_header;
2667: END IF;

Line 2669: INSERT INTO PJI_FP_TXN_ACCUM_HEADER(

2665: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2666: raise can_not_lock_header;
2667: END IF;
2668:
2669: INSERT INTO PJI_FP_TXN_ACCUM_HEADER(
2670: txn_accum_header_id,
2671: vendor_id,
2672: project_role_id,
2673: revenue_category,

Line 2702: PJI_FP_TXN_ACCUM_HEADER_S.nextval ,

2698: CREATION_DATE,
2699: CREATED_BY,
2700: LAST_UPDATE_LOGIN )
2701: SELECT
2702: PJI_FP_TXN_ACCUM_HEADER_S.nextval ,
2703: decode(TAB1.supplier_id,null,-1,TAB1.supplier_id),
2704: decode(TAB1.role_id,null,-1,TAB1.role_id),
2705: decode(TAB1.revenue_category_code,null,'PJI$NULL',TAB1.revenue_category_code),
2706: decode(TAB1.resource_class_id,null,-1,TAB1.resource_class_id) ,

Line 2755: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2751: person_type_code
2752: FROM PA_RBS_PLANS_IN_TMP
2753: WHERE rowid NOT IN
2754: (SELECT /*+ ordered */ tmp.rowid
2755: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2756: WHERE
2757: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2758: head.project_role_id = nvl(tmp.role_id,-1) AND
2759: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND

Line 2837: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2833: tmp.person_id,
2834: tmp.bom_equipment_id,
2835: tmp.bom_labor_id,
2836: tmp.person_type_code
2837: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2838: WHERE
2839: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2840: head.project_role_id = nvl(tmp.role_id,-1) AND
2841: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND