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_FP_GEN_FCST_AMT_PUB3 dependencies on PA_FP_CALC_AMT_TMP1

Line 199: SELECT /+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)/

195: ELSIF p_fp_cols_tgt_rec.X_PLAN_IN_MULTI_CURR_FLAG = 'N' THEN
196: l_currency_flag := 'PC';
197: ELSIF l_rate_based_flag = 'N' THEN
198: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (
199: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/
200: DISTINCT act_tmp.txn_currency_code
201: FROM PA_FP_FCST_GEN_TMP1 act_tmp,
202: PA_FP_CALC_AMT_TMP1 tot_tmp
203: WHERE act_tmp.project_element_id = tot_tmp.task_id

Line 202: PA_FP_CALC_AMT_TMP1 tot_tmp

198: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (
199: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/
200: DISTINCT act_tmp.txn_currency_code
201: FROM PA_FP_FCST_GEN_TMP1 act_tmp,
202: PA_FP_CALC_AMT_TMP1 tot_tmp
203: WHERE act_tmp.project_element_id = tot_tmp.task_id
204: AND act_tmp.res_list_member_id = tot_tmp.resource_list_member_id
205: AND tot_tmp.target_res_asg_id = p_tgt_res_asg_id
206: AND data_type_code = DECODE(P_ETC_SOURCE_CODE,

Line 1368: SELECT /+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)/

1364: * P_WP_PLANNING_OPTIONS_FLAG = Y
1365: * P_FP_PLANNING_OPTIONS_FLAG = N */
1366:
1367: CURSOR src_tgt_cur_wp_opt_same IS
1368: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1369: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1370: tmp.resource_assignment_id src_res_asg_id
1371: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1372: PA_FP_CALC_AMT_TMP2 tmp

Line 1371: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,

1367: CURSOR src_tgt_cur_wp_opt_same IS
1368: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1369: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1370: tmp.resource_assignment_id src_res_asg_id
1371: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1372: PA_FP_CALC_AMT_TMP2 tmp
1373: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1374: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1375: AND tmp_ra.transaction_source_code = 'WORKPLAN_RESOURCES'

Line 1377: SELECT /+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)/

1373: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1374: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1375: AND tmp_ra.transaction_source_code = 'WORKPLAN_RESOURCES'
1376: UNION ALL
1377: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1378: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1379: NULL src_res_asg_id
1380: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1381: PA_FP_CALC_AMT_TMP2 tmp

Line 1380: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,

1376: UNION ALL
1377: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1378: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1379: NULL src_res_asg_id
1380: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1381: PA_FP_CALC_AMT_TMP2 tmp
1382: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1383: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1384: AND tmp_ra.transaction_source_code = 'FINANCIAL_PLAN';

Line 1393: SELECT /+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)/

1389: * P_WP_PLANNING_OPTIONS_FLAG = N
1390: * P_FP_PLANNING_OPTIONS_FLAG = Y */
1391:
1392: CURSOR src_tgt_cur_fp_opt_same IS
1393: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1394: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1395: tmp.resource_assignment_id src_res_asg_id
1396: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1397: PA_FP_CALC_AMT_TMP2 tmp

Line 1396: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,

1392: CURSOR src_tgt_cur_fp_opt_same IS
1393: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1394: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1395: tmp.resource_assignment_id src_res_asg_id
1396: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1397: PA_FP_CALC_AMT_TMP2 tmp
1398: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1399: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1400: AND tmp_ra.transaction_source_code = 'FINANCIAL_PLAN'

Line 1402: SELECT /+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)/

1398: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1399: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1400: AND tmp_ra.transaction_source_code = 'FINANCIAL_PLAN'
1401: UNION ALL
1402: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1403: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1404: NULL src_res_asg_id
1405: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1406: PA_FP_CALC_AMT_TMP2 tmp

Line 1405: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,

1401: UNION ALL
1402: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1403: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1404: NULL src_res_asg_id
1405: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1406: PA_FP_CALC_AMT_TMP2 tmp
1407: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1408: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1409: AND tmp_ra.transaction_source_code = 'WORKPLAN_RESOURCES';

Line 2591: SELECT /+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)/

2587: ELSIF p_fp_cols_tgt_rec.X_PLAN_IN_MULTI_CURR_FLAG = 'N' THEN
2588: l_currency_flag := 'PC';
2589: ELSIF l_rate_based_flag = 'N' THEN
2590: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (
2591: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2592: DISTINCT act_tmp.txn_currency_code
2593: FROM PA_FP_FCST_GEN_TMP1 act_tmp,
2594: PA_FP_CALC_AMT_TMP1 tot_tmp
2595: WHERE act_tmp.project_element_id = tot_tmp.task_id

Line 2594: PA_FP_CALC_AMT_TMP1 tot_tmp

2590: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (
2591: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2592: DISTINCT act_tmp.txn_currency_code
2593: FROM PA_FP_FCST_GEN_TMP1 act_tmp,
2594: PA_FP_CALC_AMT_TMP1 tot_tmp
2595: WHERE act_tmp.project_element_id = tot_tmp.task_id
2596: AND act_tmp.res_list_member_id = tot_tmp.resource_list_member_id
2597: AND nvl(act_tmp.cbs_element_id, -1) = nvl(tot_tmp.cbs_element_id, -1) --bug#16791711
2598: AND tot_tmp.target_res_asg_id = l_tgt_res_asg_id

Line 4552: FROM PA_FP_CALC_AMT_TMP1;

4548: -- Doing this processing to avoid unnecessary periods being pulled.
4549: BEGIN
4550: SELECT MAX(PLANNING_END_DATE)
4551: INTO l_end_date
4552: FROM PA_FP_CALC_AMT_TMP1;
4553: EXCEPTION
4554: WHEN NO_DATA_FOUND THEN
4555: SELECT MAX(pbl.end_date)
4556: INTO l_end_date