APPS.OE_SCH_CONC_REQUESTS dependencies on WF_PROCESS_ACTIVITIES

Line 89: FROM wf_item_activity_statuses wias, wf_process_activities wpa

85:
86: -- Check for workflow status to be Purchase Release Eligible
87: SELECT ACTIVITY_STATUS
88: INTO l_activity_status_code
89: FROM wf_item_activity_statuses wias, wf_process_activities wpa
90: WHERE wias.item_type = 'OEOL' AND
91: wias.item_key = to_char(p_line_id) AND
92: wias.process_activity = wpa.instance_id AND
93: wpa.activity_item_type = 'OEOL' AND

Line 209: wf_process_activities wpa,

205: -- Moac. Changed the below cursor logic to also join to oe_order_lines for OU.
206: CURSOR wf_item IS
207: SELECT item_key, l.org_id
208: FROM wf_item_activity_statuses wias,
209: wf_process_activities wpa,
210: oe_order_lines l
211: WHERE wias.item_type = 'OEOL'
212: AND wias.process_activity = wpa.instance_id
213: AND wpa.activity_item_type = 'OEOL'

Line 461: || ' wf_item_activity_statuses wias, wf_process_activities wpa ';

457: /*Start MOAC_SQL_CHANGE */
458: l_stmt := 'SELECT H.header_id, L.Line_id, L.org_id ';
459: IF NVL(p_sch_mode, 'LINE_ELIGIBLE') = 'LINE_ELIGIBLE' THEN
460: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L, '
461: || ' wf_item_activity_statuses wias, wf_process_activities wpa ';
462: ELSE
463: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L ';
464: END IF;
465: l_stmt := l_stmt || 'WHERE H.header_id = L.header_id '