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.AZW_REPORT dependencies on AZ_TASKS_V

Line 1376: * 1. If all statuses is chosen, get all tasks in az_tasks_v into the

1372: *
1373: * Private procedure. Called by status_report.
1374: * Populate tasks belong to processes with a particular status into the
1375: * intermediate table. Performs the following steps:
1376: * 1. If all statuses is chosen, get all tasks in az_tasks_v into the
1377: * intermediate table.
1378: * 2. Otherwise, get all tasks that belong to processes with the specified
1379: * status into the intermediate table.
1380: *-----------------------------------------------------------------------*/

Line 1397: FROM az_tasks_v atv,

1393: atv.assigned_user,
1394: atv.begin_date,
1395: atv.end_date,
1396: atv.duration
1397: FROM az_tasks_v atv,
1398: az_processes_all_v apv
1399: WHERE apv.status = p_status
1400: AND atv.item_type = apv.item_type
1401: AND atv.root_activity = apv.process_name

Line 1419: FROM az_tasks_v atv,

1415: atv.assigned_user,
1416: atv.begin_date,
1417: atv.end_date,
1418: atv.duration
1419: FROM az_tasks_v atv,
1420: az_processes_all_v apv
1421: WHERE (apv.status = 'N'
1422: OR apv.status = 'A')
1423: AND atv.item_type = apv.item_type

Line 1442: FROM az_tasks_v atv,

1438: atv.assigned_user,
1439: atv.begin_date,
1440: atv.end_date,
1441: atv.duration
1442: FROM az_tasks_v atv,
1443: az_processes_all_v apv
1444: WHERE atv.item_type = apv.item_type
1445: AND atv.root_activity = apv.process_name
1446: AND apv.process_type = g_current_mode

Line 1659: FROM az_tasks_v atv,

1655: atv.assigned_user,
1656: atv.begin_date,
1657: atv.end_date,
1658: atv.duration
1659: FROM az_tasks_v atv,
1660: az_processes_all_v apv
1661: WHERE atv.assigned_user = p_user
1662: AND atv.status = p_status
1663: AND atv.duration >= p_duration

Line 1686: FROM az_tasks_v atv

1682: AND apv.process_type = g_current_mode
1683: AND ag.process_type = g_current_mode
1684: AND EXISTS(
1685: SELECT 1
1686: FROM az_tasks_v atv
1687: WHERE apv.context_id = atv.context_id
1688: AND apv.item_type = atv.item_type
1689: AND apv.process_name = atv.root_activity
1690: AND atv.assigned_user = p_user

Line 1699: FROM az_tasks_v atv

1695: SELECT DISTINCT apv.parent_id
1696: FROM az_processes_all_v apv
1697: WHERE EXISTS(
1698: SELECT 1
1699: FROM az_tasks_v atv
1700: WHERE apv.item_type = atv.item_type
1701: AND apv.process_name = atv.root_activity
1702: AND apv.context_id = atv.context_id
1703: AND atv.status = p_status

Line 1722: FROM az_tasks_v atv,

1718: atv.assigned_user,
1719: atv.begin_date,
1720: atv.end_date,
1721: atv.duration
1722: FROM az_tasks_v atv,
1723: az_processes_all_v apv
1724: WHERE atv.assigned_user = p_user
1725: AND atv.duration >= p_duration
1726: AND atv.item_type = apv.item_type

Line 1748: FROM az_tasks_v atv

1744: AND apv.process_type = g_current_mode
1745: AND ag.process_type = g_current_mode
1746: AND EXISTS(
1747: SELECT 1
1748: FROM az_tasks_v atv
1749: WHERE apv.item_type = atv.item_type
1750: AND apv.process_name = atv.root_activity
1751: AND apv.context_id = atv.context_id
1752: AND atv.assigned_user = p_user

Line 1760: FROM az_tasks_v atv

1756: SELECT DISTINCT apv.parent_id
1757: FROM az_processes_all_v apv
1758: WHERE EXISTS(
1759: SELECT 1
1760: FROM az_tasks_v atv
1761: WHERE apv.item_type = atv.item_type
1762: AND apv.process_name = atv.root_activity
1763: AND apv.context_id = atv.context_id
1764: AND atv.assigned_user = p_user

Line 1881: FROM az_tasks_v atv,

1877: atv.assigned_user,
1878: atv.begin_date,
1879: atv.end_date,
1880: atv.duration
1881: FROM az_tasks_v atv,
1882: az_processes_all_v apv
1883: WHERE atv.assigned_user = p_user
1884: AND atv.status = p_status
1885: AND atv.duration <= p_duration

Line 1908: FROM az_tasks_v atv

1904: AND apv.process_type = g_current_mode
1905: AND ag.process_type = apv.process_type
1906: AND EXISTS(
1907: SELECT 1
1908: FROM az_tasks_v atv
1909: WHERE apv.item_type = atv.item_type
1910: AND apv.process_name = atv.root_activity
1911: AND apv.context_id = atv.context_id
1912: AND atv.assigned_user = p_user

Line 1921: FROM az_tasks_v atv

1917: SELECT DISTINCT apv.parent_id
1918: FROM az_processes_all_v apv
1919: WHERE EXISTS(
1920: SELECT 1
1921: FROM az_tasks_v atv
1922: WHERE apv.item_type = atv.item_type
1923: AND apv.process_name = atv.root_activity
1924: AND apv.context_id = atv.context_id
1925: AND atv.status = p_status

Line 1944: FROM az_tasks_v atv,

1940: atv.assigned_user,
1941: atv.begin_date,
1942: atv.end_date,
1943: atv.duration
1944: FROM az_tasks_v atv,
1945: az_processes_all_v apv
1946: WHERE atv.assigned_user = p_user
1947: AND atv.duration <= p_duration
1948: AND atv.item_type = apv.item_type

Line 1970: FROM az_tasks_v atv

1966: AND apv.process_type = g_current_mode
1967: AND ag.process_type = apv.process_type
1968: AND EXISTS(
1969: SELECT 1
1970: FROM az_tasks_v atv
1971: WHERE apv.item_type = atv.item_type
1972: AND apv.process_name = atv.root_activity
1973: AND apv.context_id = atv.context_id
1974: AND atv.assigned_user = p_user

Line 1982: FROM az_tasks_v atv

1978: SELECT DISTINCT apv.parent_id
1979: FROM az_processes_all_v apv
1980: WHERE EXISTS(
1981: SELECT 1
1982: FROM az_tasks_v atv
1983: WHERE apv.item_type = atv.item_type
1984: AND apv.process_name = atv.root_activity
1985: AND apv.context_id = atv.context_id
1986: AND atv.assigned_user = p_user

Line 2102: FROM az_tasks_v atv,

2098: atv.status,
2099: atv.begin_date,
2100: atv.end_date,
2101: atv.duration
2102: FROM az_tasks_v atv,
2103: az_processes_all_v apv
2104: WHERE atv.assigned_user = p_user
2105: AND atv.status = p_status
2106: AND ((atv.begin_date >= p_startdate AND atv.begin_date <= p_enddate)

Line 2132: FROM az_tasks_v atv

2128: AND apv.process_type = g_current_mode
2129: AND ag.process_type = apv.process_type
2130: AND EXISTS(
2131: SELECT 1
2132: FROM az_tasks_v atv
2133: WHERE apv.item_type = atv.item_type
2134: AND apv.process_name = atv.root_activity
2135: AND apv.context_id = atv.context_id
2136: AND atv.assigned_user = p_user

Line 2148: FROM az_tasks_v atv

2144: SELECT DISTINCT apv.parent_id
2145: FROM az_processes_all_v apv
2146: WHERE EXISTS(
2147: SELECT 1
2148: FROM az_tasks_v atv
2149: WHERE apv.item_type = atv.item_type
2150: AND apv.process_name = atv.root_activity
2151: AND apv.context_id = atv.context_id
2152: AND atv.status = p_status

Line 2173: FROM az_tasks_v atv,

2169: atv.status,
2170: atv.begin_date,
2171: atv.end_date,
2172: atv.duration
2173: FROM az_tasks_v atv,
2174: az_processes_all_v apv
2175: WHERE atv.assigned_user = p_user
2176: AND ((atv.begin_date >= p_startdate AND atv.begin_date <= p_enddate)
2177: OR (atv.end_date >= p_startdate AND atv.end_date <= p_enddate)

Line 2202: FROM az_tasks_v atv

2198: AND apv.process_type = g_current_mode
2199: AND ag.process_type = apv.process_type
2200: AND EXISTS(
2201: SELECT 1
2202: FROM az_tasks_v atv
2203: WHERE apv.item_type = atv.item_type
2204: AND apv.process_name = atv.root_activity
2205: AND apv.context_id = atv.context_id
2206: AND atv.assigned_user = p_user

Line 2217: FROM az_tasks_v atv

2213: SELECT DISTINCT apv.parent_id
2214: FROM az_processes_all_v apv
2215: WHERE EXISTS(
2216: SELECT 1
2217: FROM az_tasks_v atv
2218: WHERE apv.item_type = atv.item_type
2219: AND apv.process_name = atv.root_activity
2220: AND apv.context_id = atv.context_id
2221: AND atv.assigned_user = p_user

Line 4811: v_item_type AZ_TASKS_V.ITEM_TYPE%TYPE;

4807: v_upper_group_names HierarchyLevels;
4808:
4809: v_ctx_type_name az_monitor_reports.context_type_name%TYPE;
4810: v_process_groups VARCHAR2(4000);
4811: v_item_type AZ_TASKS_V.ITEM_TYPE%TYPE;
4812: v_item_key AZ_TASKS_V.ITEM_KEY%TYPE;
4813:
4814: BEGIN
4815: print_time_stamp('Start report');

Line 4812: v_item_key AZ_TASKS_V.ITEM_KEY%TYPE;

4808:
4809: v_ctx_type_name az_monitor_reports.context_type_name%TYPE;
4810: v_process_groups VARCHAR2(4000);
4811: v_item_type AZ_TASKS_V.ITEM_TYPE%TYPE;
4812: v_item_key AZ_TASKS_V.ITEM_KEY%TYPE;
4813:
4814: BEGIN
4815: print_time_stamp('Start report');
4816: g_help_target := get_report_procedure('AZW_RPT_ISRR');

Line 5287: v_item_type AZ_TASKS_V.ITEM_TYPE%TYPE;

5283:
5284: v_count INTEGER;
5285: i PLS_INTEGER;
5286: v_locator PLS_INTEGER := 0;
5287: v_item_type AZ_TASKS_V.ITEM_TYPE%TYPE;
5288: v_item_key AZ_TASKS_V.ITEM_KEY%TYPE;
5289: v_href VARCHAR2(4000);
5290: v_upper_group_names HierarchyLevels;
5291:

Line 5288: v_item_key AZ_TASKS_V.ITEM_KEY%TYPE;

5284: v_count INTEGER;
5285: i PLS_INTEGER;
5286: v_locator PLS_INTEGER := 0;
5287: v_item_type AZ_TASKS_V.ITEM_TYPE%TYPE;
5288: v_item_key AZ_TASKS_V.ITEM_KEY%TYPE;
5289: v_href VARCHAR2(4000);
5290: v_upper_group_names HierarchyLevels;
5291:
5292: v_ctx_type_name az_monitor_reports.context_type_name%TYPE;