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 1476: from pa_assignment_conflict_hist

1472: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1473: where (fi1.assignment_id = p_assignment_id
1474: or fi1.assignment_id in
1475: (select conflict_assignment_id
1476: from pa_assignment_conflict_hist
1477: where assignment_id = p_assignment_id
1478: and conflict_group_id = p_conflict_group_id
1479: and self_conflict_flag = 'N'
1480: and intra_txn_conflict_flag = 'Y'))

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

1490: select fi2.resource_id,
1491: item_quantity,
1492: fi2.item_date,
1493: fi2.delete_flag
1494: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
1495: where fi2.assignment_id = asgn.assignment_id
1496: and fi2.assignment_id = hist.conflict_assignment_id
1497: and hist.conflict_group_id = p_conflict_group_id
1498: and hist.assignment_id = p_assignment_id

Line 1631: from pa_assignment_conflict_hist

1627: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1628: where (fi1.assignment_id = p_assignment_id
1629: or fi1.assignment_id in
1630: (select conflict_assignment_id
1631: from pa_assignment_conflict_hist
1632: where assignment_id = p_assignment_id
1633: and conflict_group_id = p_conflict_group_id
1634: and self_conflict_flag = 'N'
1635: and intra_txn_conflict_flag = 'Y'))

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

1645: select fi2.resource_id,
1646: item_quantity,
1647: fi2.item_date,
1648: fi2.delete_flag
1649: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
1650: where fi2.assignment_id = asgn.assignment_id
1651: and fi2.assignment_id = hist.conflict_assignment_id
1652: and hist.conflict_group_id = p_conflict_group_id
1653: and hist.assignment_id = p_assignment_id

Line 1800: from pa_assignment_conflict_hist

1796: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1797: where (fi1.assignment_id = p_assignment_id
1798: or fi1.assignment_id in
1799: (select conflict_assignment_id
1800: from pa_assignment_conflict_hist
1801: where assignment_id = p_assignment_id
1802: and conflict_group_id = p_conflict_group_id
1803: and self_conflict_flag = 'N'
1804: and intra_txn_conflict_flag = 'Y'))

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

1814: select fi2.resource_id,
1815: item_quantity,
1816: fi2.item_date,
1817: fi2.delete_flag
1818: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
1819: where fi2.assignment_id = asgn.assignment_id
1820: and fi2.assignment_id = hist.conflict_assignment_id
1821: and hist.conflict_group_id = p_conflict_group_id
1822: and hist.assignment_id = p_assignment_id

Line 1863: from pa_assignment_conflict_hist

1859: from pa_forecast_items fi3, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1860: where (fi3.assignment_id = p_assignment_id
1861: or fi3.assignment_id in
1862: (select conflict_assignment_id
1863: from pa_assignment_conflict_hist
1864: where assignment_id = p_assignment_id
1865: and conflict_group_id = p_conflict_group_id
1866: and self_conflict_flag = 'N'
1867: and intra_txn_conflict_flag = 'Y'))

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

1877: select fi4.resource_id,
1878: fi4.item_quantity,
1879: fi4.global_exp_period_end_date,
1880: fi4.delete_flag
1881: from pa_forecast_items fi4, pa_project_assignments asgn, pa_assignment_conflict_hist hist
1882: where fi4.assignment_id = asgn.assignment_id
1883: and fi4.assignment_id = hist.conflict_assignment_id
1884: and hist.conflict_group_id = p_conflict_group_id
1885: and hist.assignment_id = p_assignment_id

Line 2038: from pa_assignment_conflict_hist

2034: from pa_forecast_items fi3, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
2035: where (fi3.assignment_id = p_assignment_id
2036: or fi3.assignment_id in
2037: (select conflict_assignment_id
2038: from pa_assignment_conflict_hist
2039: where assignment_id = p_assignment_id
2040: and conflict_group_id = p_conflict_group_id
2041: and self_conflict_flag = 'N'
2042: and intra_txn_conflict_flag = 'Y'))

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

2052: select fi4.resource_id,
2053: fi4.item_quantity,
2054: fi4.global_exp_period_end_date,
2055: fi4.delete_flag
2056: from pa_forecast_items fi4, pa_project_assignments asgn, pa_assignment_conflict_hist hist
2057: where fi4.assignment_id = asgn.assignment_id
2058: and fi4.assignment_id = hist.conflict_assignment_id
2059: and hist.conflict_group_id = p_conflict_group_id
2060: and hist.assignment_id = p_assignment_id