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_PROCESSES

Line 792: * az_processes_all_v into the intermediate table.

788: * Private procedure. Called by context_report.
789: * Populate context process hierarchies in the intermediate table.
790: * It performs the following steps:
791: * 1. Get all distinct processes of the given context type from
792: * az_processes_all_v into the intermediate table.
793: * 2. Find all distinct parent ids for the processes found in Step 1.
794: * 3. For each parent id in Step 2, get all distinct hierarchy ancestors
795: * in az_groups_v into the intermediate table.
796: *-----------------------------------------------------------------------*/

Line 806: FROM az_processes_all_v apv,

802: apv.context_type_name,
803: TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
804: parent_node_id,
805: apv.description
806: FROM az_processes_all_v apv,
807: az_groups ag
808: WHERE (apv.context_type = p_context OR apv.context_type = 'NONE')
809: AND apv.process_type = 'IMP'
810: AND apv.parent_id = ag.group_id

Line 815: FROM az_processes_all_v apv

811: AND ag.process_type = apv.process_type;
812:
813: CURSOR parents_cursor IS
814: SELECT DISTINCT apv.parent_id
815: FROM az_processes_all_v apv
816: WHERE apv.context_type = p_context OR apv.context_type = 'NONE';
817:
818: v_locator NUMBER;
819: BEGIN

Line 850: * 1. Get all distinct processes of the given phase from az_processes_all_v

846: *
847: * Private procedure. Called by implementation_report.
848: * Populate implementation process hierarchies in the intermediate table.
849: * It performs the following steps:
850: * 1. Get all distinct processes of the given phase from az_processes_all_v
851: * and az_flow_phases_v into the intermediate table.
852: * 2. Find all distinct parent ids for the processes found in Step 1.
853: * 3. For each parent id in Step 2, get all distinct hierarchy ancestors
854: * in az_groups_v into the intermediate table.

Line 864: FROM az_processes_all_v apv,

860: apv.item_type ||'.'||apv.process_name node_id,
861: apv.display_name,
862: TO_CHAR(agv.display_order, '0000')||'.'|| apv.parent_id parent_node_id,
863: apv.description
864: FROM az_processes_all_v apv,
865: az_groups agv,
866: az_flow_phases_v afpv
867: WHERE afpv.phase = p_phase
868: AND afpv.item_type = apv.item_type

Line 876: FROM az_processes apv,

872: AND agv.process_type = apv.process_type;
873:
874: CURSOR parents_cursor IS
875: SELECT DISTINCT apv.parent_id
876: FROM az_processes apv,
877: az_flow_phases_v afpv
878: WHERE apv.item_type = afpv.item_type
879: AND apv.process_name = afpv.process_name
880: AND apv.process_type = 'IMP'

Line 1198: FROM az_processes apv

1194: /* distinct parents for one status (A, C, N) */
1195:
1196: CURSOR status_parents_cursor IS
1197: SELECT DISTINCT apv.parent_id
1198: FROM az_processes apv
1199: WHERE apv.status_code = p_status
1200: AND apv.process_type = g_current_mode;
1201:
1202: /* distinct parents for 'I' status */

Line 1205: FROM az_processes apv

1201:
1202: /* distinct parents for 'I' status */
1203: CURSOR incomplete_parents_cursor IS
1204: SELECT DISTINCT apv.parent_id
1205: FROM az_processes apv
1206: WHERE (apv.status_code = 'N'
1207: OR apv.status_code = 'A')
1208: AND apv.process_type = g_current_mode;
1209:

Line 1214: FROM az_processes apv

1210: /* distinct parents for all statuses */
1211:
1212: CURSOR all_parents_cursor IS
1213: SELECT DISTINCT apv.parent_id
1214: FROM az_processes apv
1215: WHERE apv.process_type = g_current_mode;
1216:
1217: v_status fnd_lookups.meaning%TYPE;
1218: v_locator PLS_INTEGER := 0;

Line 1254: * 1. If all statuses is chosen, get all processes from az_processes_all_v

1250: *
1251: * Private procedure. Called by status_report.
1252: * Populate processes with a particular status in the intermediate table.
1253: * Performs the following steps:
1254: * 1. If all statuses is chosen, get all processes from az_processes_all_v
1255: * into the intermediate table.
1256: * 2. Otherwise, get processes of the specified status form
1257: * az_processes_all_v into the intermediate table.
1258: *-----------------------------------------------------------------------*/

Line 1257: * az_processes_all_v into the intermediate table.

1253: * Performs the following steps:
1254: * 1. If all statuses is chosen, get all processes from az_processes_all_v
1255: * into the intermediate table.
1256: * 2. Otherwise, get processes of the specified status form
1257: * az_processes_all_v into the intermediate table.
1258: *-----------------------------------------------------------------------*/
1259: PROCEDURE get_status_processes(p_status IN VARCHAR2)
1260: IS
1261: /* processes for A, C, or N status */

Line 1272: FROM az_processes_all_v apv,

1268: apv.status,
1269: apv.context_type_name,
1270: apv.context_name,
1271: apv.comments
1272: FROM az_processes_all_v apv,
1273: az_groups ag
1274: WHERE apv.status = p_status
1275: AND apv.process_type = g_current_mode
1276: AND ag.process_type = g_current_mode

Line 1290: FROM az_processes_all_v apv,

1286: apv.status,
1287: apv.context_type_name,
1288: apv.context_name,
1289: apv.comments
1290: FROM az_processes_all_v apv,
1291: az_groups ag
1292: WHERE (apv.status = 'N' OR apv.status = 'A')
1293: AND apv.process_type = g_current_mode
1294: AND ag.process_type = g_current_mode

Line 1308: FROM az_processes_all_v apv,

1304: apv.status,
1305: apv.context_type_name,
1306: apv.context_name,
1307: apv.comments
1308: FROM az_processes_all_v apv,
1309: az_groups ag
1310: WHERE apv.process_type = g_current_mode
1311: AND ag.process_type = g_current_mode
1312: AND apv.parent_id = ag.group_id;

Line 1398: az_processes_all_v apv

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
1402: AND apv.process_type = g_current_mode

Line 1420: az_processes_all_v apv

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
1424: AND atv.root_activity = apv.process_name

Line 1443: az_processes_all_v apv

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
1447: AND atv.context_id = apv.context_id;

Line 1660: az_processes_all_v apv

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
1664: AND atv.item_type = apv.item_type

Line 1679: FROM az_processes_all_v apv,

1675: TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
1676: parent_node_id,
1677: apv.status,
1678: apv.comments
1679: FROM az_processes_all_v apv,
1680: az_groups ag
1681: WHERE apv.parent_id = ag.group_id
1682: AND apv.process_type = g_current_mode
1683: AND ag.process_type = g_current_mode

Line 1696: FROM az_processes_all_v apv

1692: AND atv.duration >= p_duration);
1693:
1694: CURSOR atleast_parents_cursor IS
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

Line 1723: az_processes_all_v apv

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
1727: AND atv.root_activity = apv.process_name

Line 1741: FROM az_processes_all_v apv,

1737: TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
1738: parent_node_id,
1739: apv.status,
1740: apv.comments
1741: FROM az_processes_all_v apv,
1742: az_groups ag
1743: WHERE apv.parent_id = ag.group_id
1744: AND apv.process_type = g_current_mode
1745: AND ag.process_type = g_current_mode

Line 1757: FROM az_processes_all_v apv

1753: AND atv.duration >= p_duration);
1754:
1755: CURSOR atleast_both_parents_cursor IS
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

Line 1882: az_processes_all_v apv

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
1886: AND atv.item_type = apv.item_type

Line 1901: FROM az_processes_all_v apv,

1897: TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
1898: parent_node_id,
1899: apv.status,
1900: apv.comments
1901: FROM az_processes_all_v apv,
1902: az_groups ag
1903: WHERE apv.parent_id = ag.group_id
1904: AND apv.process_type = g_current_mode
1905: AND ag.process_type = apv.process_type

Line 1918: FROM az_processes_all_v apv

1914: AND atv.duration <= p_duration);
1915:
1916: CURSOR atmost_parents_cursor IS
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

Line 1945: az_processes_all_v apv

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
1949: AND atv.root_activity = apv.process_name

Line 1963: FROM az_processes_all_v apv,

1959: TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
1960: parent_node_id,
1961: apv.status,
1962: apv.comments
1963: FROM az_processes_all_v apv,
1964: az_groups ag
1965: WHERE apv.parent_id = ag.group_id
1966: AND apv.process_type = g_current_mode
1967: AND ag.process_type = apv.process_type

Line 1979: FROM az_processes_all_v apv

1975: AND atv.duration <= p_duration);
1976:
1977: CURSOR atmost_both_parents_cursor IS
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

Line 2103: az_processes_all_v apv

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)
2107: OR (atv.end_date >= p_startdate AND atv.end_date <= p_enddate)

Line 2125: FROM az_processes_all_v apv,

2121: TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
2122: parent_node_id,
2123: apv.status,
2124: apv.comments
2125: FROM az_processes_all_v apv,
2126: az_groups ag
2127: WHERE apv.parent_id = ag.group_id
2128: AND apv.process_type = g_current_mode
2129: AND ag.process_type = apv.process_type

Line 2145: FROM az_processes_all_v apv

2141: (atv.end_date >= p_enddate OR atv.end_date IS NULL))));
2142:
2143: CURSOR period_parents_cursor IS
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

Line 2174: az_processes_all_v apv

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)
2178: OR (atv.begin_date <= p_startdate AND

Line 2195: FROM az_processes_all_v apv,

2191: TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
2192: parent_node_id,
2193: apv.status,
2194: apv.comments
2195: FROM az_processes_all_v apv,
2196: az_groups ag
2197: WHERE apv.parent_id = ag.group_id
2198: AND apv.process_type = g_current_mode
2199: AND ag.process_type = apv.process_type

Line 2214: FROM az_processes_all_v apv

2210: (atv.end_date >= p_enddate OR atv.end_date IS NULL))));
2211:
2212: CURSOR period_both_parents_cursor IS
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