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_PLANNING_REPORTS

Line 121: phase AZ_PLANNING_REPORTS.PHASE%TYPE,

117:
118: TYPE id_tbl_t IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
119:
120: TYPE PlanProcessGroupRec IS RECORD(
121: phase AZ_PLANNING_REPORTS.PHASE%TYPE,
122: display_name AZ_PLANNING_REPORTS.DISPLAY_NAME%TYPE,
123: processes_count PLS_INTEGER,
124: node_id AZ_PLANNING_REPORTS.NODE_ID%TYPE
125: );

Line 122: display_name AZ_PLANNING_REPORTS.DISPLAY_NAME%TYPE,

118: TYPE id_tbl_t IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
119:
120: TYPE PlanProcessGroupRec IS RECORD(
121: phase AZ_PLANNING_REPORTS.PHASE%TYPE,
122: display_name AZ_PLANNING_REPORTS.DISPLAY_NAME%TYPE,
123: processes_count PLS_INTEGER,
124: node_id AZ_PLANNING_REPORTS.NODE_ID%TYPE
125: );
126:

Line 124: node_id AZ_PLANNING_REPORTS.NODE_ID%TYPE

120: TYPE PlanProcessGroupRec IS RECORD(
121: phase AZ_PLANNING_REPORTS.PHASE%TYPE,
122: display_name AZ_PLANNING_REPORTS.DISPLAY_NAME%TYPE,
123: processes_count PLS_INTEGER,
124: node_id AZ_PLANNING_REPORTS.NODE_ID%TYPE
125: );
126:
127: TYPE StatusProcessGroupRec IS RECORD(
128: node_id AZ_MONITOR_REPORTS.NODE_ID%TYPE,

Line 693: FROM az_planning_reports

689: description,
690: parent_node_id,
691: node_id,
692: LEVEL
693: FROM az_planning_reports
694: START WITH parent_node_id IS NULL
695: CONNECT BY PRIOR node_id = parent_node_id
696: AND PRIOR phase = phase;
697:

Line 822: INSERT INTO az_planning_reports

818: v_locator NUMBER;
819: BEGIN
820: v_locator := 1;
821: FOR one_proc IN processes_cursor LOOP
822: INSERT INTO az_planning_reports
823: (NODE_ID, PHASE, NODE_TYPE, DISPLAY_NAME,
824: CONTEXT_TYPE_NAME,PARENT_NODE_ID, DESCRIPTION)
825: VALUES
826: (one_proc.node_id, -1, 'P', one_proc.display_name,

Line 887: INSERT INTO az_planning_reports

883: v_locator NUMBER;
884: BEGIN
885: v_locator := 1;
886: FOR one_process IN processes_cursor LOOP
887: INSERT INTO az_planning_reports
888: (NODE_ID, PHASE, NODE_TYPE, DISPLAY_NAME,
889: CONTEXT_TYPE_NAME,PARENT_NODE_ID, DESCRIPTION)
890: VALUES
891: (one_process.node_id, p_phase, 'P', one_process.display_name, '',

Line 989: * Private procedure. Called by reports that use az_planning_reports as the

985:
986: /*------------------------------------------------------------------------
987: * GET_PLANNING_GROUP_PARENT
988: *
989: * Private procedure. Called by reports that use az_planning_reports as the
990: * intermediate data storage (get_implementation_processes,
991: * get_context_processes, get_product_processes).
992: * Given a group id, recursively get all its group parents into the
993: * intermediate table if the parent does not exist in the table.

Line 1032: FROM az_planning_reports apr

1028:
1029: v_locator := 2;
1030: SELECT COUNT(*)
1031: INTO v_exist_cnt
1032: FROM az_planning_reports apr
1033: WHERE apr.node_id = v_group.node_id
1034: AND apr.phase = p_phase;
1035:
1036: IF (v_exist_cnt = 0) THEN

Line 1038: INSERT INTO az_planning_reports

1034: AND apr.phase = p_phase;
1035:
1036: IF (v_exist_cnt = 0) THEN
1037: v_locator := 3;
1038: INSERT INTO az_planning_reports
1039: (NODE_ID, PHASE, NODE_TYPE, DISPLAY_NAME,
1040: CONTEXT_TYPE_NAME,PARENT_NODE_ID, DESCRIPTION)
1041: VALUES
1042: (v_group.node_id, p_phase, 'G', v_group.display_name, '',

Line 1118: FROM az_planning_reports apr

1114: v_exist_cnt := -1;
1115: v_locator := 2;
1116: SELECT COUNT(*)
1117: INTO v_exist_cnt
1118: FROM az_planning_reports apr
1119: WHERE apr.node_id = one_process.node_id
1120: AND apr.phase = -1;
1121: v_locator := 3;
1122: IF (v_exist_cnt = 0) THEN

Line 1123: INSERT INTO az_planning_reports

1119: WHERE apr.node_id = one_process.node_id
1120: AND apr.phase = -1;
1121: v_locator := 3;
1122: IF (v_exist_cnt = 0) THEN
1123: INSERT INTO az_planning_reports
1124: (NODE_ID, PHASE, NODE_TYPE, DISPLAY_NAME,
1125: CONTEXT_TYPE_NAME,PARENT_NODE_ID, DESCRIPTION)
1126: VALUES
1127: (one_process.node_id, -1, 'P', one_process.display_name,

Line 2348: ** The node id specified in the az_planning_reports temp

2344: **
2345: ** GET_PROCESS_TYPE_KEY
2346: ** ====================
2347: **
2348: ** The node id specified in the az_planning_reports temp
2349: ** table is composed of multiple fields. two of them are
2350: ** the item_type and process name fields.
2351: ** this procedure extracts and returns these two fields
2352: ** from the input node_id.

Line 2475: FROM az_planning_reports

2471: description,
2472: node_id,
2473: parent_node_id,
2474: LEVEL
2475: FROM az_planning_reports
2476: WHERE phase = x_phase
2477: START WITH parent_node_id IS NULL
2478: CONNECT BY PRIOR node_id = parent_node_id
2479: AND PRIOR phase = phase;

Line 3162: FROM az_planning_reports

3158: display_name,
3159: node_type,
3160: parent_node_id,
3161: node_id
3162: FROM az_planning_reports
3163: START WITH parent_node_id IS NULL
3164: CONNECT BY PRIOR node_id = parent_node_id
3165: AND PRIOR phase = phase;
3166:

Line 3173: FROM az_planning_reports

3169: display_name,
3170: node_type,
3171: parent_node_id,
3172: node_id
3173: FROM az_planning_reports
3174: WHERE phase = x_phase
3175: START WITH parent_node_id IS NULL
3176: CONNECT BY PRIOR node_id = parent_node_id
3177: AND PRIOR phase = phase;

Line 4515: FROM az_planning_reports

4511: parent_node_id,
4512: node_id,
4513: context_type_name,
4514: LEVEL
4515: FROM az_planning_reports
4516: START WITH parent_node_id IS NULL
4517: CONNECT BY PRIOR node_id = parent_node_id
4518: AND PRIOR phase = phase;
4519:

Line 5996: FROM az_planning_reports

5992: parent_node_id,
5993: node_id,
5994: context_type_name,
5995: LEVEL
5996: FROM az_planning_reports
5997: START WITH parent_node_id IS NULL
5998: CONNECT BY PRIOR node_id = parent_node_id
5999: AND PRIOR phase = phase;
6000: