DBA Data[Home] [Help]

APPS.OE_SALES_CAN_UTIL dependencies on WF_PROCESS_ACTIVITIES

Line 1785: wf_process_activities WPA

1781: IF l_lines_in_set > 0 THEN
1782: SELECT count(1) INTO l_lines_awaiting
1783: FROM oe_order_lines ol, oe_line_sets ols,
1784: wf_item_activity_statuses WIAS,
1785: wf_process_activities WPA
1786: WHERE ol.header_id = p_header_id
1787: AND ols.set_id = C_Set.set_id
1788: AND ols.line_id = ol.line_id
1789: AND WPA.activity_name = 'FULFILL_LINE'

Line 1805: wf_process_activities WPA

1801: SELECT WIAS.Process_Activity, ol.line_id
1802: INTO l_activity_id, l_line_id
1803: FROM oe_order_lines ol, oe_line_sets ols,
1804: wf_item_activity_statuses WIAS,
1805: wf_process_activities WPA
1806: WHERE ol.header_id = p_header_id
1807: AND ols.set_id = C_Set.set_id
1808: AND ols.line_id = ol.line_id
1809: AND WPA.activity_name = 'FULFILL_LINE'