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.OE_EXPORT_COMPLIANCE_CONC dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 30: FROM wf_item_activity_statuses WIAS,

26: -- Get Work Flow status for Line Id
27:
28: SELECT WIAS.Activity_Status
29: INTO l_activity_status
30: FROM wf_item_activity_statuses WIAS,
31: wf_process_activities WPA
32: WHERE WIAS.Process_Activity = WPA.instance_id
33: AND WPA.activity_name = 'EXPORT_COMPLIANCE_ELIGIBLE'
34: AND WIAS.item_type = 'OEOL'

Line 212: 'wf_item_activity_statuses WIAS, wf_process_activities WPA ' ||

208:
209: -- The cursor is being built based on the parameters passed, bug 4632747
210: l_sql_stmt := 'SELECT L.line_id, L.org_id '||
211: 'FROM oe_order_lines L, oe_order_headers_all H, '||
212: 'wf_item_activity_statuses WIAS, wf_process_activities WPA ' ||
213: 'WHERE L.header_id = H.header_id '||
214: 'AND WIAS.item_key = to_char(L.line_id) '||
215: 'AND WIAS.Process_Activity = WPA.instance_id '||
216: 'AND WPA.activity_name = ''EXPORT_COMPLIANCE_ELIGIBLE'' '||