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_TIMELINE_PVT dependencies on PA_ASSIGNMENT_CONFLICT_HIST

Line 1444: from pa_assignment_conflict_hist

1440: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1441: where (fi1.assignment_id = p_assignment_id
1442: or fi1.assignment_id in
1443: (select conflict_assignment_id
1444: from pa_assignment_conflict_hist
1445: where assignment_id = p_assignment_id
1446: and conflict_group_id = p_conflict_group_id
1447: and self_conflict_flag = 'N'
1448: and intra_txn_conflict_flag = 'Y'))

Line 1462: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist

1458: select fi2.resource_id,
1459: item_quantity,
1460: fi2.item_date,
1461: fi2.delete_flag
1462: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
1463: where fi2.assignment_id = asgn.assignment_id
1464: and fi2.assignment_id = hist.conflict_assignment_id
1465: and hist.conflict_group_id = p_conflict_group_id
1466: and hist.assignment_id = p_assignment_id

Line 1596: from pa_assignment_conflict_hist

1592: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1593: where (fi1.assignment_id = p_assignment_id
1594: or fi1.assignment_id in
1595: (select conflict_assignment_id
1596: from pa_assignment_conflict_hist
1597: where assignment_id = p_assignment_id
1598: and conflict_group_id = p_conflict_group_id
1599: and self_conflict_flag = 'N'
1600: and intra_txn_conflict_flag = 'Y'))

Line 1614: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist

1610: select fi2.resource_id,
1611: item_quantity,
1612: fi2.item_date,
1613: fi2.delete_flag
1614: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
1615: where fi2.assignment_id = asgn.assignment_id
1616: and fi2.assignment_id = hist.conflict_assignment_id
1617: and hist.conflict_group_id = p_conflict_group_id
1618: and hist.assignment_id = p_assignment_id

Line 1762: from pa_assignment_conflict_hist

1758: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1759: where (fi1.assignment_id = p_assignment_id
1760: or fi1.assignment_id in
1761: (select conflict_assignment_id
1762: from pa_assignment_conflict_hist
1763: where assignment_id = p_assignment_id
1764: and conflict_group_id = p_conflict_group_id
1765: and self_conflict_flag = 'N'
1766: and intra_txn_conflict_flag = 'Y'))

Line 1780: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist

1776: select fi2.resource_id,
1777: item_quantity,
1778: fi2.item_date,
1779: fi2.delete_flag
1780: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
1781: where fi2.assignment_id = asgn.assignment_id
1782: and fi2.assignment_id = hist.conflict_assignment_id
1783: and hist.conflict_group_id = p_conflict_group_id
1784: and hist.assignment_id = p_assignment_id

Line 1825: from pa_assignment_conflict_hist

1821: from pa_forecast_items fi3, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1822: where (fi3.assignment_id = p_assignment_id
1823: or fi3.assignment_id in
1824: (select conflict_assignment_id
1825: from pa_assignment_conflict_hist
1826: where assignment_id = p_assignment_id
1827: and conflict_group_id = p_conflict_group_id
1828: and self_conflict_flag = 'N'
1829: and intra_txn_conflict_flag = 'Y'))

Line 1843: from pa_forecast_items fi4, pa_project_assignments asgn, pa_assignment_conflict_hist hist

1839: select fi4.resource_id,
1840: fi4.item_quantity,
1841: fi4.global_exp_period_end_date,
1842: fi4.delete_flag
1843: from pa_forecast_items fi4, pa_project_assignments asgn, pa_assignment_conflict_hist hist
1844: where fi4.assignment_id = asgn.assignment_id
1845: and fi4.assignment_id = hist.conflict_assignment_id
1846: and hist.conflict_group_id = p_conflict_group_id
1847: and hist.assignment_id = p_assignment_id

Line 1997: from pa_assignment_conflict_hist

1993: from pa_forecast_items fi3, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1994: where (fi3.assignment_id = p_assignment_id
1995: or fi3.assignment_id in
1996: (select conflict_assignment_id
1997: from pa_assignment_conflict_hist
1998: where assignment_id = p_assignment_id
1999: and conflict_group_id = p_conflict_group_id
2000: and self_conflict_flag = 'N'
2001: and intra_txn_conflict_flag = 'Y'))

Line 2015: from pa_forecast_items fi4, pa_project_assignments asgn, pa_assignment_conflict_hist hist

2011: select fi4.resource_id,
2012: fi4.item_quantity,
2013: fi4.global_exp_period_end_date,
2014: fi4.delete_flag
2015: from pa_forecast_items fi4, pa_project_assignments asgn, pa_assignment_conflict_hist hist
2016: where fi4.assignment_id = asgn.assignment_id
2017: and fi4.assignment_id = hist.conflict_assignment_id
2018: and hist.conflict_group_id = p_conflict_group_id
2019: and hist.assignment_id = p_assignment_id