APPS.AZW_ARCHIVE dependencies on AZ_GROUPS

Line 61: * in az_groups_v into the intermediate table.

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.
62: *-----------------------------------------------------------------------*/
63: PROCEDURE processes IS
64: CURSOR all_groups_cursor IS
65: SELECT TO_CHAR(agv.display_order, '0000')||'.'||agv.group_id node_id

Line 71: FROM az_groups_v agv

67: ,TO_CHAR(ag.display_order, '0000')||'.'||
68: agv.hierarchy_parent_id parent_node_id
69: ,agv.status
70: ,fl.meaning status_display_name
71: FROM az_groups_v agv
72: ,az_groups ag
73: ,fnd_lookups fl
74: WHERE agv.hierarchy_parent_id = ag.group_id
75: AND agv.status = fl.lookup_code

Line 72: ,az_groups ag

68: agv.hierarchy_parent_id parent_node_id
69: ,agv.status
70: ,fl.meaning status_display_name
71: FROM az_groups_v agv
72: ,az_groups ag
73: ,fnd_lookups fl
74: WHERE agv.hierarchy_parent_id = ag.group_id
75: AND agv.status = fl.lookup_code
76: AND fl.lookup_type = 'AZ_PROCESS_STATUS'

Line 83: FROM az_groups_v agv

79: ,agv.display_name
80: ,agv.hierarchy_parent_id parent_node_id
81: ,agv.status
82: ,fl.meaning status_display_name
83: FROM az_groups_v agv
84: ,fnd_lookups fl
85: WHERE agv.hierarchy_parent_id is NULL
86: AND agv.status = fl.lookup_code
87: AND fl.lookup_type = 'AZ_PROCESS_STATUS';

Line 102: az_groups ag,

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
106: AND fl.lookup_type = 'AZ_PROCESS_STATUS';