APPS.OE_OEOL_SCH dependencies on WF_PROCESS_ACTIVITIES

Line 39: FROM wf_item_activity_statuses wias, wf_process_activities wpa

35: sch_elg_cached_line_id)
36: THEN
37: SELECT ACTIVITY_STATUS
38: INTO l_activity_status
39: FROM wf_item_activity_statuses wias, wf_process_activities wpa
40: WHERE wias.item_type = 'OEOL'
41: AND wias.item_key = to_char(p_line_id)
42: AND wias.process_activity = wpa.instance_id
43: AND wpa.ACTIVITY_ITEM_TYPE = 'OEOL'

Line 192: ' FROM oe_order_lines_all ola, wf_item_activity_statuses wias, wf_process_activities wpa '||

188: END IF;
189: IF l_where_clause IS NOT NULL
190: THEN
191: l_stmt :=' SELECT ola.line_id '||
192: ' FROM oe_order_lines_all ola, wf_item_activity_statuses wias, wf_process_activities wpa '||
193: l_where_clause||
194: ' AND wias.item_key = to_char(ola.line_id)'||
195: ' AND wias.item_type = '||'''OEOL'''||
196: ' AND wias.process_activity = wpa.instance_id'||

Line 801: FROM wf_item_activity_statuses wias, wf_process_activities wpa

797: --Check whether the Parent line is in Schedule Eligible state
798:
799: SELECT ACTIVITY_STATUS
800: INTO l_activity_status_code
801: FROM wf_item_activity_statuses wias, wf_process_activities wpa
802: WHERE wias.item_type = 'OEOL' AND
803: wias.item_key = to_char(l_top_model_line_id) AND
804: wias.process_activity = wpa.instance_id AND
805: wpa.ACTIVITY_ITEM_TYPE = 'OEOL' AND

Line 844: FROM wf_item_activity_statuses wias, wf_process_activities wpa

840: --Check whether the Parent line is in Schedule Eligible state
841:
842: SELECT ACTIVITY_STATUS
843: INTO l_activity_status_code
844: FROM wf_item_activity_statuses wias, wf_process_activities wpa
845: WHERE wias.item_type = 'OEOL' AND
846: wias.item_key = to_char(l_ato_line_id) AND
847: wias.process_activity = wpa.instance_id AND
848: wpa.ACTIVITY_ITEM_TYPE = 'OEOL' AND

Line 1715: wf_process_activities wpa

1711: CURSOR model is
1712: SELECT ola.line_id line_id
1713: FROM oe_order_lines_all ola,
1714: wf_item_activity_statuses wias,
1715: wf_process_activities wpa
1716: WHERE top_model_line_id = nvl(l_top_model_line_id, ola.top_model_line_id)
1717: And ato_line_id = nvl(l_ato_line_id, ola.ato_line_id)
1718: And wias.item_key = ola.line_id
1719: And wias.item_type = 'OEOL'