APPS.OE_SCH_CONC_REQUESTS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 96: FROM wf_item_activity_statuses wias, wf_process_activities wpa

92:
93: -- Check for workflow status to be Purchase Release Eligible
94: SELECT ACTIVITY_STATUS
95: INTO l_activity_status_code
96: FROM wf_item_activity_statuses wias, wf_process_activities wpa
97: WHERE wias.item_type = 'OEOL' AND
98: wias.item_key = to_char(p_line_id) AND
99: wias.process_activity = wpa.instance_id AND
100: wpa.activity_item_type = 'OEOL' AND

Line 264: FROM wf_item_activity_statuses wias,

260: l_prg_start_date DATE := sysdate; -- 12639770
261: -- Moac. Changed the below cursor logic to also join to oe_order_lines for OU.
262: CURSOR wf_item IS
263: SELECT item_key, l.org_id,wias.process_activity --added process_activity for bug 13542899
264: FROM wf_item_activity_statuses wias,
265: wf_process_activities wpa,
266: oe_order_lines l
267: WHERE wias.item_type = 'OEOL'
268: AND wias.process_activity = wpa.instance_id

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

582: --BUG 13901213 End
583:
584: IF NVL(p_sch_mode, 'LINE_ELIGIBLE') = 'LINE_ELIGIBLE' THEN
585: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L, '
586: || ' wf_item_activity_statuses wias, wf_process_activities wpa ';
587: ELSE
588: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L ';
589: END IF;
590: l_stmt := l_stmt || 'WHERE H.header_id = L.header_id '