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_ARCHIVE dependencies on AZ_PROCESSES_ALL_V

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

53: *
54: * Private procedure. Called by procedure Run.
55: * Populate implementation process hierarchies in the intermediate table.
56: * It performs the following steps:
57: * 1. Get all distinct processes of the given phase from az_processes_all_v and
58: * az_flow_phases_v into the intermediate table.
59: * 2. Find all distinct parent ids for the processes found in Step 1.
60: * 3. For each parent id in Step 2, get all distinct hierarchy ancestors
61: * in az_groups_v into the intermediate table.

Line 101: FROM az_processes_all_v apv,

97: apv.context_name context_display_name,
98: apv.status,
99: fl.meaning status_display_name,
100: apv.comments
101: FROM az_processes_all_v apv,
102: az_groups ag,
103: fnd_lookups fl
104: WHERE apv.parent_id = ag.group_id
105: AND apv.status = fl.lookup_code

Line 128: ,az_processes_all_v apv

124: ,atv.begin_date
125: ,atv.end_date
126: ,atv.duration
127: FROM az_tasks_v atv
128: ,az_processes_all_v apv
129: ,fnd_lookups fl
130: WHERE atv.item_type = apv.item_type
131: AND atv.root_activity = apv.process_name
132: AND atv.context_id = apv.context_id