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_GROUPS

Line 795: * in az_groups_v into the intermediate table.

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: *-----------------------------------------------------------------------*/
797: PROCEDURE get_context_processes(p_context IN VARCHAR2) IS
798: CURSOR processes_cursor IS
799: SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type

Line 807: az_groups ag

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
811: AND ag.process_type = apv.process_type;

Line 854: * in az_groups_v into the intermediate table.

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.
855: *-----------------------------------------------------------------------*/
856: PROCEDURE get_implementation_processes(p_phase IN NUMBER)
857: IS
858: CURSOR processes_cursor IS

Line 865: az_groups agv,

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
869: AND afpv.process_name = apv.process_name

Line 926: FROM az_groups_v agv,

922: agv.display_name,
923: TO_CHAR(ag.display_order, '0000')||'.'|| agv.hierarchy_parent_id parent_node_id,
924: agv.status,
925: agv.hierarchy_parent_id h_parent_id
926: FROM az_groups_v agv,
927: az_groups ag
928: WHERE agv.group_id = p_group_id
929: AND agv.process_type = g_current_mode
930: AND ag.process_type = g_current_mode

Line 927: az_groups ag

923: TO_CHAR(ag.display_order, '0000')||'.'|| agv.hierarchy_parent_id parent_node_id,
924: agv.status,
925: agv.hierarchy_parent_id h_parent_id
926: FROM az_groups_v agv,
927: az_groups ag
928: WHERE agv.group_id = p_group_id
929: AND agv.process_type = g_current_mode
930: AND ag.process_type = g_current_mode
931: AND agv.hierarchy_parent_id = ag.group_id

Line 938: FROM az_groups_v agv

934: agv.display_name,
935: NULL parent_node_id,
936: agv.status,
937: NULL h_parent_id
938: FROM az_groups_v agv
939: WHERE agv.group_id = p_group_id
940: AND agv.process_type = g_current_mode
941: AND agv.hierarchy_parent_id IS NULL;
942:

Line 1005: FROM az_groups_v agv,

1001: DECODE(agv.hierarchy_parent_id, '', '',
1002: TO_CHAR(ag.display_order, '0000')||'.'||
1003: agv.hierarchy_parent_id) parent_node_id,
1004: agv.hierarchy_parent_id h_parent_id
1005: FROM az_groups_v agv,
1006: az_groups ag
1007: WHERE agv.group_id = p_group_id
1008: AND agv.process_type = g_current_mode
1009: AND ag.process_type = g_current_mode

Line 1006: az_groups ag

1002: TO_CHAR(ag.display_order, '0000')||'.'||
1003: agv.hierarchy_parent_id) parent_node_id,
1004: agv.hierarchy_parent_id h_parent_id
1005: FROM az_groups_v agv,
1006: az_groups ag
1007: WHERE agv.group_id = p_group_id
1008: AND agv.process_type = g_current_mode
1009: AND ag.process_type = g_current_mode
1010: AND agv.hierarchy_parent_id = ag.group_id

Line 1016: FROM az_groups_v agv

1012: SELECT TO_CHAR(agv.display_order, '0000')||'.'||agv.group_id node_id,
1013: agv.display_name,
1014: NULL,
1015: NULL
1016: FROM az_groups_v agv
1017: WHERE agv.group_id = p_group_id
1018: AND agv.process_type = g_current_mode
1019: AND agv.hierarchy_parent_id IS NULL;
1020:

Line 1073: * in az_groups_v into the intermediate table if the parent does not

1069: * az_product_flows into the intermediate table if the process does
1070: * not exist in the table.
1071: * 2. Find all distinct parent ids for the processes found in Step 1.
1072: * 3. For each parent id in Step 2, get all distinct hierarchy ancestors
1073: * in az_groups_v into the intermediate table if the parent does not
1074: * exist in the table.
1075: *-----------------------------------------------------------------------*/
1076: PROCEDURE get_product_processes(p_application_id IN NUMBER)
1077: IS

Line 1087: az_groups ag,

1083: parent_node_id,
1084: meaning context_type_name,
1085: wav.description
1086: FROM az_product_flows apf,
1087: az_groups ag,
1088: wf_activities_vl wav,
1089: fnd_lookups fnd
1090: WHERE apf.application_id = p_application_id
1091: AND apf.process_type = 'IMP'

Line 1186: * 1. If all statuses is chosen, get all group parents in az_groups_v into

1182: *
1183: * Private procedure. Called by status_report.
1184: * Populate groups with processes with a particular status into the
1185: * intermediate table. Performs the following steps:
1186: * 1. If all statuses is chosen, get all group parents in az_groups_v into
1187: * the intermediate table.
1188: * 2. Otherwise, find all distinct group parents that has a process with
1189: * the status. For each parent found, recursively get all its ancestors
1190: * into the table if the parent does not exist in the table.

Line 1273: az_groups ag

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
1277: AND apv.parent_id = ag.group_id;

Line 1291: az_groups ag

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
1295: AND apv.parent_id = ag.group_id;

Line 1309: az_groups ag

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;
1313:

Line 1680: az_groups ag

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
1684: AND EXISTS(

Line 1742: az_groups ag

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
1746: AND EXISTS(

Line 1902: az_groups ag

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
1906: AND EXISTS(

Line 1964: az_groups ag

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
1968: AND EXISTS(

Line 2126: az_groups ag

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
2130: AND EXISTS(

Line 2196: az_groups ag

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
2200: AND EXISTS(

Line 4305: FROM az_groups ag,

4301: CURSOR product_list_cursor IS
4302: SELECT ag.dependency_parent_id,
4303: ag.application_id,
4304: fav.application_name
4305: FROM az_groups ag,
4306: fnd_application_vl fav
4307: WHERE ag.application_id IS NOT NULL
4308: AND ag.application_id = fav.application_id
4309: AND ag.process_type = g_current_mode

Line 4314: v_group az_groups.dependency_parent_id%TYPE;

4310: ORDER BY ag.dependency_parent_id,
4311: ag.display_order;
4312:
4313: v_product product_list_cursor%ROWTYPE;
4314: v_group az_groups.dependency_parent_id%TYPE;
4315: v_column INTEGER := 0;
4316: v_product_cnt INTEGER := 0;
4317: v_locator PLS_INTEGER := 0;
4318: BEGIN

Line 5985: v_current_id az_groups.application_id%TYPE;

5981: */
5982: PROCEDURE show_all_steps(p_selected_products IN VARCHAR2) IS
5983:
5984:
5985: v_current_id az_groups.application_id%TYPE;
5986: i INTEGER;
5987:
5988: CURSOR hierarchies_cursor IS
5989: SELECT display_name hierarchy,