APPS.AZW_ARCHIVE dependencies on FND_LOOKUPS

Line 73: ,fnd_lookups fl

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'
77: UNION ALL

Line 84: ,fnd_lookups fl

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';
88:

Line 103: fnd_lookups fl

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';
107:

Line 129: ,fnd_lookups fl

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
133: AND atv.status = fl.lookup_code