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

Line 849: INSERT INTO PA_FP_FCST_GEN_TMP1 (

845: UPDATE pji_fm_xbs_accum_tmp1
846: SET res_list_member_id = l_rlm_id;
847: END IF;
848:
849: INSERT INTO PA_FP_FCST_GEN_TMP1 (
850: PROJECT_ID,
851: STRUCT_VERSION_ID,
852: PROJECT_ELEMENT_ID,
853: CALENDAR_TYPE,

Line 1040: SELECT /+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)/

1036:
1037: -- Bug 4040832, 3970800: Modified project-level cursor to get
1038: -- actuals data from PJI table instead of target budget lines.
1039: CURSOR get_res_asg_cur_proj IS
1040: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1041: DISTINCT ra.resource_assignment_id,
1042: tmp.res_list_member_id,
1043: ra.planning_start_date,
1044: ra.planning_end_date,

Line 1046: FROM PA_FP_FCST_GEN_TMP1 tmp,

1042: tmp.res_list_member_id,
1043: ra.planning_start_date,
1044: ra.planning_end_date,
1045: tmp.project_element_id
1046: FROM PA_FP_FCST_GEN_TMP1 tmp,
1047: pa_resource_assignments ra
1048: WHERE tmp.project_element_id = p_task_id AND
1049: ra.budget_version_id = P_BUDGET_VERSION_ID AND
1050: NVL(ra.task_id,0) = 0 AND

Line 1129: SELECT /+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)/

1125: AND NVL(quantity,0) <> NVL(init_quantity,0)
1126: AND rownum < 2 )));
1127:
1128: CURSOR get_res_asg_cur_proj_ml IS
1129: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1130: DISTINCT ra.resource_assignment_id,
1131: tmp.res_list_member_id,
1132: ra.planning_start_date,
1133: ra.planning_end_date,

Line 1135: FROM PA_FP_FCST_GEN_TMP1 tmp,

1131: tmp.res_list_member_id,
1132: ra.planning_start_date,
1133: ra.planning_end_date,
1134: tmp.project_element_id
1135: FROM PA_FP_FCST_GEN_TMP1 tmp,
1136: pa_resource_assignments ra
1137: WHERE tmp.project_element_id = p_task_id AND
1138: ra.budget_version_id = P_BUDGET_VERSION_ID AND
1139: NVL(ra.task_id,0) = 0 AND

Line 1151: SELECT /+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)/

1147: AND bl.start_date > p_actuals_thru_date
1148: AND rownum < 2 )));
1149:
1150: CURSOR get_res_asg_cur_proj_ml_none IS
1151: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/
1152: DISTINCT ra.resource_assignment_id,
1153: tmp.res_list_member_id,
1154: ra.planning_start_date,
1155: ra.planning_end_date,

Line 1157: FROM PA_FP_FCST_GEN_TMP1 tmp,

1153: tmp.res_list_member_id,
1154: ra.planning_start_date,
1155: ra.planning_end_date,
1156: tmp.project_element_id
1157: FROM PA_FP_FCST_GEN_TMP1 tmp,
1158: pa_resource_assignments ra
1159: WHERE tmp.project_element_id = p_task_id AND
1160: ra.budget_version_id = P_BUDGET_VERSION_ID AND
1161: NVL(ra.task_id,0) = 0 AND

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

1551: FROM PA_FP_CALC_AMT_TMP2
1552: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1553: AND ETC_CURRENCY_CODE IS NULL;
1554:
1555: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
1556: COUNT(DISTINCT TXN_CURRENCY_CODE)
1557: INTO l_currency_count_act
1558: FROM PA_FP_FCST_GEN_TMP1
1559: WHERE project_element_id = P_TASK_ID

Line 1558: FROM PA_FP_FCST_GEN_TMP1

1554:
1555: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
1556: COUNT(DISTINCT TXN_CURRENCY_CODE)
1557: INTO l_currency_count_act
1558: FROM PA_FP_FCST_GEN_TMP1
1559: WHERE project_element_id = P_TASK_ID
1560: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
1561: AND data_type_code = P_ETC_SOURCE_CODE;
1562: /* hr_utility.trace('currency count tot :'||l_currency_count_tot );

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

1577: FROM PA_FP_CALC_AMT_TMP2
1578: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1579: AND ETC_CURRENCY_CODE IS NULL;
1580:
1581: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
1582: DISTINCT TXN_CURRENCY_CODE
1583: INTO l_currency_code_act
1584: FROM PA_FP_FCST_GEN_TMP1
1585: WHERE project_element_id = P_TASK_ID

Line 1584: FROM PA_FP_FCST_GEN_TMP1

1580:
1581: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
1582: DISTINCT TXN_CURRENCY_CODE
1583: INTO l_currency_code_act
1584: FROM PA_FP_FCST_GEN_TMP1
1585: WHERE project_element_id = P_TASK_ID
1586: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
1587: AND data_type_code = P_ETC_SOURCE_CODE;
1588:

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

1603: ELSIF l_currency_count_tot = 0
1604: AND l_currency_count_act = 1
1605: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1606: l_currency_flag := 'TC';
1607: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
1608: DISTINCT TXN_CURRENCY_CODE
1609: INTO l_etc_currency_code
1610: FROM PA_FP_FCST_GEN_TMP1
1611: WHERE project_element_id = P_TASK_ID

Line 1610: FROM PA_FP_FCST_GEN_TMP1

1606: l_currency_flag := 'TC';
1607: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
1608: DISTINCT TXN_CURRENCY_CODE
1609: INTO l_etc_currency_code
1610: FROM PA_FP_FCST_GEN_TMP1
1611: WHERE project_element_id = P_TASK_ID
1612: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
1613: AND data_type_code = P_ETC_SOURCE_CODE;
1614: END IF;

Line 1661: FROM /+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)/

1657: INTO
1658: l_act_qty,
1659: l_act_txn_raw_cost,
1660: l_act_txn_brdn_cost
1661: FROM /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
1662: PA_FP_FCST_GEN_TMP1
1663: WHERE project_element_id = P_TASK_ID
1664: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
1665: AND data_type_code = P_ETC_SOURCE_CODE;

Line 1662: PA_FP_FCST_GEN_TMP1

1658: l_act_qty,
1659: l_act_txn_raw_cost,
1660: l_act_txn_brdn_cost
1661: FROM /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
1662: PA_FP_FCST_GEN_TMP1
1663: WHERE project_element_id = P_TASK_ID
1664: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
1665: AND data_type_code = P_ETC_SOURCE_CODE;
1666: EXCEPTION

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

2301: END IF;
2302:
2303: /*Getting ACWP in both TXN and PROJ currencies*/
2304: IF P_ETC_SOURCE_CODE = 'FINANCIAL_PLAN' THEN
2305: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
2306: COUNT(DISTINCT TXN_CURRENCY_CODE),SUM(NVL(quantity,0))
2307: INTO l_txn_currency_count_act,l_act_qty
2308: FROM PA_FP_FCST_GEN_TMP1
2309: WHERE project_element_id = P_TASK_ID

Line 2308: FROM PA_FP_FCST_GEN_TMP1

2304: IF P_ETC_SOURCE_CODE = 'FINANCIAL_PLAN' THEN
2305: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
2306: COUNT(DISTINCT TXN_CURRENCY_CODE),SUM(NVL(quantity,0))
2307: INTO l_txn_currency_count_act,l_act_qty
2308: FROM PA_FP_FCST_GEN_TMP1
2309: WHERE project_element_id = P_TASK_ID
2310: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
2311: AND data_type_code = P_ETC_SOURCE_CODE;
2312:

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

2316: ELSIF l_txn_currency_count_act = 1
2317: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
2318: l_act_exist_flag := 'Y';
2319: l_act_txn_pc_flag := 'TC';
2320: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
2321: DISTINCT TXN_CURRENCY_CODE
2322: INTO l_txn_currency_code_act
2323: FROM PA_FP_FCST_GEN_TMP1
2324: WHERE project_element_id = P_TASK_ID

Line 2323: FROM PA_FP_FCST_GEN_TMP1

2319: l_act_txn_pc_flag := 'TC';
2320: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
2321: DISTINCT TXN_CURRENCY_CODE
2322: INTO l_txn_currency_code_act
2323: FROM PA_FP_FCST_GEN_TMP1
2324: WHERE project_element_id = P_TASK_ID
2325: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
2326: AND data_type_code = P_ETC_SOURCE_CODE;
2327:

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

2325: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
2326: AND data_type_code = P_ETC_SOURCE_CODE;
2327:
2328: BEGIN
2329: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
2330: SUM(NVL(quantity,0)),
2331: SUM(NVL(txn_raw_cost,0)),
2332: SUM(NVL(txn_brdn_cost,0)),
2333: SUM(NVL(prj_raw_cost,0)),

Line 2341: FROM PA_FP_FCST_GEN_TMP1

2337: l_act_txn_raw_cost,
2338: l_act_txn_brdn_cost,
2339: l_act_pc_raw_cost,
2340: l_act_pc_brdn_cost
2341: FROM PA_FP_FCST_GEN_TMP1
2342: WHERE project_element_id = P_TASK_ID
2343: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
2344: AND data_type_code = P_ETC_SOURCE_CODE;
2345: EXCEPTION

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

2353: ELSE
2354: l_act_exist_flag := 'Y';
2355: l_act_txn_pc_flag := 'PC';
2356: BEGIN
2357: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/
2358: SUM(NVL(quantity,0)),
2359: SUM(NVL(prj_raw_cost,0)),
2360: SUM(NVL(prj_brdn_cost,0))
2361: INTO

Line 2365: FROM PA_FP_FCST_GEN_TMP1

2361: INTO
2362: l_act_qty,
2363: l_act_pc_raw_cost,
2364: l_act_pc_brdn_cost
2365: FROM PA_FP_FCST_GEN_TMP1
2366: WHERE project_element_id = P_TASK_ID
2367: AND res_list_member_id = P_RESOURCE_LIST_MEMBER_ID
2368: AND data_type_code = P_ETC_SOURCE_CODE;
2369: EXCEPTION

APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_FP_FCST_GEN_TMP1

Line 849: INSERT INTO PA_FP_FCST_GEN_TMP1 (

Line 1040: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/

Line 1046: FROM PA_FP_FCST_GEN_TMP1 tmp,

Line 1129: SELECT /*+ INDEX(tmp,PA_FP_FCST_GEN_TMP1_N1)*/