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_PUB5 dependencies on PA_FP_FCST_GEN_TMP1

Line 215: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */

211: l_pc_currency_code := p_fp_cols_tgt_rec.x_project_currency_code;
212: l_pfc_currency_code := p_fp_cols_tgt_rec.x_projfunc_currency_code;
213: l_target_version_type := p_fp_cols_src_rec.x_version_type;
214: IF p_etc_source_code = 'FINANCIAL_PLAN' THEN
215: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */
216: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
217: DECODE(l_currency_flag,
218: 'PC',l_pc_currency_code,
219: 'TC',txn_currency_code,

Line 216: SELECT /+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)/

212: l_pfc_currency_code := p_fp_cols_tgt_rec.x_projfunc_currency_code;
213: l_target_version_type := p_fp_cols_src_rec.x_version_type;
214: IF p_etc_source_code = 'FINANCIAL_PLAN' THEN
215: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */
216: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
217: DECODE(l_currency_flag,
218: 'PC',l_pc_currency_code,
219: 'TC',txn_currency_code,
220: 'PFC',l_pfc_currency_code),

Line 240: FROM PA_FP_FCST_GEN_TMP1

236: l_act_quantity_tab,
237: l_act_raw_cost_tab,
238: l_act_brdn_cost_tab,
239: l_act_revenue_tab
240: FROM PA_FP_FCST_GEN_TMP1
241: WHERE project_element_id = p_task_id
242: AND res_list_member_id = p_resource_list_member_id
243: AND data_type_code = 'ETC_FP'
244: GROUP BY DECODE(l_currency_flag,

Line 326: SELECT /+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)/

322: from the source resource assignments that are mapped to the current target
323: resource assignment. */
324: FOR i IN 1..l_act_currency_code_tab.count LOOP
325: IF p_etc_source_code = 'FINANCIAL_PLAN' THEN
326: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
327: SUM(NVL(quantity,0)),
328: SUM(DECODE(l_currency_flag,
329: 'PC', NVL(prj_raw_cost,0),
330: 'TC', NVL(txn_raw_cost,0),

Line 356: FROM PA_FP_FCST_GEN_TMP1

352: l_pc_rate_revenue,
353: l_pfc_rate_raw_cost,
354: l_pfc_rate_brdn_cost,
355: l_pfc_rate_revenue
356: FROM PA_FP_FCST_GEN_TMP1
357: WHERE project_element_id = p_task_id
358: AND res_list_member_id = p_resource_list_member_id
359: AND data_type_code = 'ETC_FP'
360: AND DECODE(l_currency_flag, 'TC',txn_currency_code,

Line 743: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */

739: l_pc_currency_code := p_fp_cols_tgt_rec.x_project_currency_code;
740: l_pfc_currency_code := p_fp_cols_tgt_rec.x_projfunc_currency_code;
741: l_target_version_type := p_fp_cols_tgt_rec.x_version_type;
742: IF p_etc_source_code_tab(main_loop) = 'FINANCIAL_PLAN' THEN
743: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */
744: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
745: DECODE(l_currency_flag,
746: 'PC',l_pc_currency_code,
747: 'TC',txn_currency_code,

Line 744: SELECT /+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)/

740: l_pfc_currency_code := p_fp_cols_tgt_rec.x_projfunc_currency_code;
741: l_target_version_type := p_fp_cols_tgt_rec.x_version_type;
742: IF p_etc_source_code_tab(main_loop) = 'FINANCIAL_PLAN' THEN
743: /* Get actual amounts from financial side - PA_FP_FCST_GEN_TMP1 */
744: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
745: DECODE(l_currency_flag,
746: 'PC',l_pc_currency_code,
747: 'TC',txn_currency_code,
748: 'PFC',l_pfc_currency_code),

Line 768: FROM PA_FP_FCST_GEN_TMP1

764: l_act_quantity_tab,
765: l_act_raw_cost_tab,
766: l_act_brdn_cost_tab,
767: l_act_revenue_tab
768: FROM PA_FP_FCST_GEN_TMP1
769: WHERE project_element_id = p_task_id_tab(main_loop)
770: AND res_list_member_id = p_res_list_member_id_tab(main_loop)
771: AND nvl(cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID_TAB(main_loop),-1) --bug#16791711
772: AND data_type_code = 'ETC_FP'

Line 855: SELECT /+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)/

851: from the source resource assignments that are mapped to the current target
852: resource assignment. */
853: FOR i IN 1..l_act_currency_code_tab.count LOOP
854: IF p_etc_source_code_tab(main_loop) = 'FINANCIAL_PLAN' THEN
855: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
856: SUM(NVL(quantity,0)),
857: SUM(DECODE(l_currency_flag,
858: 'PC', NVL(prj_raw_cost,0),
859: 'TC', NVL(txn_raw_cost,0),

Line 885: FROM PA_FP_FCST_GEN_TMP1

881: l_pc_rate_revenue,
882: l_pfc_rate_raw_cost,
883: l_pfc_rate_brdn_cost,
884: l_pfc_rate_revenue
885: FROM PA_FP_FCST_GEN_TMP1
886: WHERE project_element_id = p_task_id_tab(main_loop)
887: AND res_list_member_id = p_res_list_member_id_tab(main_loop)
888: AND nvl(cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID_TAB(main_loop),-1) --bug#16791711
889: AND data_type_code = 'ETC_FP'