APPS.OE_OEOL_SCH dependencies on WF_ITEM_ACTIVITY_STATUSES

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 858: FROM wf_item_activity_statuses wias, wf_process_activities wpa

854: --Check whether the Parent line is in Schedule Eligible state
855:
856: SELECT ACTIVITY_STATUS
857: INTO l_activity_status_code
858: FROM wf_item_activity_statuses wias, wf_process_activities wpa
859: WHERE wias.item_type = 'OEOL' AND
860: wias.item_key = to_char(l_top_model_line_id) AND
861: wias.process_activity = wpa.instance_id AND
862: wpa.ACTIVITY_ITEM_TYPE = 'OEOL' AND

Line 901: FROM wf_item_activity_statuses wias, wf_process_activities wpa

897: --Check whether the Parent line is in Schedule Eligible state
898:
899: SELECT ACTIVITY_STATUS
900: INTO l_activity_status_code
901: FROM wf_item_activity_statuses wias, wf_process_activities wpa
902: WHERE wias.item_type = 'OEOL' AND
903: wias.item_key = to_char(l_ato_line_id) AND
904: wias.process_activity = wpa.instance_id AND
905: wpa.ACTIVITY_ITEM_TYPE = 'OEOL' AND

Line 1845: wf_item_activity_statuses wias,

1841:
1842: CURSOR model is
1843: SELECT ola.line_id line_id
1844: FROM oe_order_lines_all ola,
1845: wf_item_activity_statuses wias,
1846: wf_process_activities wpa
1847: WHERE top_model_line_id = nvl(l_top_model_line_id, ola.top_model_line_id)
1848: And ato_line_id = nvl(l_ato_line_id, ola.ato_line_id)
1849: And wias.item_key = ola.line_id