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_VIEW_PLANS_TXN_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1226: p_filter_resource_id IN pa_resource_list_members.resource_id%TYPE,

1222: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
1223: p_project_currency IN pa_projects_all.project_currency_code%TYPE,
1224: p_get_display_from IN VARCHAR2, -- 'COST', 'REVENUE', 'BOTH', 'ANY'
1225: p_filter_task_id IN pa_resource_assignments.task_id%TYPE,
1226: p_filter_resource_id IN pa_resource_list_members.resource_id%TYPE,
1227: p_filter_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
1228: p_filter_txncurrency IN pa_budget_lines.txn_currency_code%TYPE,
1229: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1230: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1260: pa_resource_list_members rlm,

1256: 0 as margin,
1257: 0 as margin_percent
1258: from pa_resource_assignments ra_cost,
1259: pa_budget_lines bl_cost,
1260: pa_resource_list_members rlm,
1261: pa_resources pr -- added for bug 3463685
1262: where ra_cost.budget_version_id = p_cost_version_id and
1263: ra_cost.resource_assignment_type = 'USER_ENTERED' and
1264: ra_cost.resource_assignment_id = bl_cost.resource_assignment_id and

Line 1273: from pa_resource_list_members

1269: (p_filter_resource_id = -1 or
1270: rlm.parent_member_id = p_filter_resource_id or
1271: (rlm.parent_member_id is null and
1272: rlm.resource_id = (select resource_id
1273: from pa_resource_list_members
1274: where resource_list_member_id = p_filter_resource_id))) and
1275: /*
1276: (p_filter_resource_id = -1 or
1277: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

Line 1335: pa_resource_list_members rlm,

1331: 0, 0,
1332: (ra.total_plan_revenue - ra.total_plan_raw_cost)/
1333: ra.total_plan_revenue)) as margin_percent -- null
1334: from pa_resource_assignments ra,
1335: pa_resource_list_members rlm,
1336: pa_fp_txn_currencies ftc,
1337: pa_resources pr -- added for bug 3463685
1338: where ra.budget_version_id = p_cost_version_id and
1339: ra.resource_assignment_type = 'USER_ENTERED' and

Line 1349: from pa_resource_list_members

1345: (p_filter_resource_id = -1 or
1346: rlm.parent_member_id = p_filter_resource_id or
1347: (rlm.parent_member_id is null and
1348: rlm.resource_id = (select resource_id
1349: from pa_resource_list_members
1350: where resource_list_member_id = p_filter_resource_id))) and
1351: /*
1352: (p_filter_resource_id = -1 or
1353: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

Line 1393: pa_resource_list_members rlm,

1389: -- 0 as margin,
1390: -- 0 as margin_percent
1391: from pa_resource_assignments ra_revenue,
1392: pa_budget_lines bl_revenue,
1393: pa_resource_list_members rlm,
1394: pa_resources pr -- Added for bug 3463685
1395: where ra_revenue.budget_version_id = p_revenue_version_id and
1396: ra_revenue.resource_assignment_type = 'USER_ENTERED' and
1397: ra_revenue.resource_assignment_id = bl_revenue.resource_assignment_id and

Line 1406: from pa_resource_list_members

1402: (p_filter_resource_id = -1 or
1403: rlm.parent_member_id = p_filter_resource_id or
1404: (rlm.parent_member_id is null and
1405: rlm.resource_id = (select resource_id
1406: from pa_resource_list_members
1407: where resource_list_member_id = p_filter_resource_id))) and
1408: /*
1409: (p_filter_resource_id = -1 or
1410: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and

Line 1453: pa_resource_list_members rlm,

1449: ra.total_plan_revenue) as revenue -- null
1450: -- 0 as margin,
1451: -- 0 as margin_percent
1452: from pa_resource_assignments ra,
1453: pa_resource_list_members rlm,
1454: pa_fp_txn_currencies ftc,
1455: pa_resources pr -- added for bug 3463685
1456: where ra.budget_version_id = p_revenue_version_id and
1457: ra.resource_assignment_type = 'USER_ENTERED' and

Line 1466: from pa_resource_list_members

1462: (p_filter_resource_id = -1 or
1463: rlm.parent_member_id = p_filter_resource_id or
1464: (rlm.parent_member_id is null and
1465: rlm.resource_id = (select resource_id
1466: from pa_resource_list_members
1467: where resource_list_member_id = p_filter_resource_id))) and
1468: /*
1469: (p_filter_resource_id = -1 or
1470: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

Line 1522: pa_resource_list_members rlm,

1518: (SUM(nvl(bl.txn_revenue,0)) - SUM(nvl(bl.txn_burdened_cost,0)))/
1519: SUM(nvl(bl.txn_revenue,0)))) as margin_percent
1520: from pa_resource_assignments ra,
1521: pa_budget_lines bl,
1522: pa_resource_list_members rlm,
1523: pa_resources pr -- Added for bug 3463685
1524: where ra.budget_version_id = p_both_version_id and
1525: ra.resource_assignment_type = 'USER_ENTERED' and
1526: ra.resource_assignment_id = bl.resource_assignment_id and

Line 1535: from pa_resource_list_members

1531: (p_filter_resource_id = -1 or
1532: rlm.parent_member_id = p_filter_resource_id or
1533: (rlm.parent_member_id is null and
1534: rlm.resource_id = (select resource_id
1535: from pa_resource_list_members
1536: where resource_list_member_id = p_filter_resource_id))) and
1537: /*
1538: (p_filter_resource_id = -1 or
1539: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

Line 1595: pa_resource_list_members rlm,

1591: 0, 0,
1592: (ra.total_plan_revenue - ra.total_plan_raw_cost)/
1593: ra.total_plan_revenue)) as margin_percent -- null
1594: from pa_resource_assignments ra,
1595: pa_resource_list_members rlm,
1596: pa_fp_txn_currencies ftc,
1597: pa_resources pr -- Added for bug 3463685
1598: where ra.budget_version_id = p_both_version_id and
1599: ra.resource_assignment_type = 'USER_ENTERED' and

Line 1608: from pa_resource_list_members

1604: (p_filter_resource_id = -1 or
1605: rlm.parent_member_id = p_filter_resource_id or
1606: (rlm.parent_member_id is null and
1607: rlm.resource_id = (select resource_id
1608: from pa_resource_list_members
1609: where resource_list_member_id = p_filter_resource_id))) and
1610: /*
1611: (p_filter_resource_id = -1 or
1612: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

Line 1658: pa_resource_list_members rlm,

1654: 0 as revenue,
1655: 0 as margin,
1656: 0 as margin_percent
1657: from pa_resource_assignments ra,
1658: pa_resource_list_members rlm,
1659: pa_resources pr -- added for bug 3463685
1660: where ra.budget_version_id = p_cost_version_id and
1661: ra.resource_assignment_type = 'USER_ENTERED' and
1662: ra.resource_list_member_id = rlm.resource_list_member_id and

Line 1670: from pa_resource_list_members

1666: (p_filter_resource_id = -1 or
1667: rlm.parent_member_id = p_filter_resource_id or
1668: (rlm.parent_member_id is null and
1669: rlm.resource_id = (select resource_id
1670: from pa_resource_list_members
1671: where resource_list_member_id = p_filter_resource_id))) and
1672: /*
1673: (p_filter_resource_id = -1 or
1674: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

Line 1713: pa_resource_list_members rlm,

1709: ra.total_plan_revenue) as revenue
1710: -- 0 as margin,
1711: -- 0 as margin_percent
1712: from pa_resource_assignments ra,
1713: pa_resource_list_members rlm,
1714: pa_resources pr -- Added for bug 3463685
1715: where ra.budget_version_id = p_revenue_version_id and
1716: ra.resource_assignment_type = 'USER_ENTERED' and
1717: ra.resource_list_member_id = rlm.resource_list_member_id and

Line 1725: from pa_resource_list_members

1721: (p_filter_resource_id = -1 or
1722: rlm.parent_member_id = p_filter_resource_id or
1723: (rlm.parent_member_id is null and
1724: rlm.resource_id = (select resource_id
1725: from pa_resource_list_members
1726: where resource_list_member_id = p_filter_resource_id))) and
1727: /*
1728: (p_filter_resource_id = -1 or
1729: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and

Line 1796: pa_resource_list_members rlm,

1792: ra.total_plan_revenue,
1793: (ra.total_plan_revenue - ra.total_plan_burdened_cost)/
1794: ra.total_plan_revenue))) as margin_percent
1795: from pa_resource_assignments ra,
1796: pa_resource_list_members rlm,
1797: pa_resources pr -- Added for bug 3463685
1798: where ra.budget_version_id = p_both_version_id and
1799: ra.resource_assignment_type = 'USER_ENTERED' and
1800: ra.resource_list_member_id = rlm.resource_list_member_id and

Line 1808: from pa_resource_list_members

1804: (p_filter_resource_id = -1 or
1805: rlm.parent_member_id = p_filter_resource_id or
1806: (rlm.parent_member_id is null and
1807: rlm.resource_id = (select resource_id
1808: from pa_resource_list_members
1809: where resource_list_member_id = p_filter_resource_id))) and
1810: /*
1811: (p_filter_resource_id = -1 or
1812: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

Line 3242: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

3238:
3239: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type ;
3240: l_ra_id_tbl SYSTEM.pa_num_tbl_type ;
3241: l_task_id pa_tasks.task_id%TYPE;
3242: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3243: l_resource_id pa_resource_list_members.resource_id%TYPE;
3244: l_prev_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -99;
3245:
3246: CURSOR cur_sel_bud_line IS

Line 3243: l_resource_id pa_resource_list_members.resource_id%TYPE;

3239: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type ;
3240: l_ra_id_tbl SYSTEM.pa_num_tbl_type ;
3241: l_task_id pa_tasks.task_id%TYPE;
3242: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3243: l_resource_id pa_resource_list_members.resource_id%TYPE;
3244: l_prev_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -99;
3245:
3246: CURSOR cur_sel_bud_line IS
3247: SELECT budget_line_id,

Line 3359: pa_resource_list_members prlm

3355: l_project_id,
3356: l_resource_id,
3357: l_resource_list_id
3358: FROM pa_resource_assignments pra,
3359: pa_resource_list_members prlm
3360: WHERE pra.resource_assignment_id = l_ra_id_tbl(i)
3361: AND prlm.resource_list_member_id = pra.resource_list_member_id;
3362:
3363: l_prev_res_assignment_id := l_ra_id_tbl(i);