DBA Data[Home] [Help]

APPS.OE_SALES_CAN_UTIL dependencies on WF_PROCESS_ACTIVITIES

Line 1722: wf_process_activities WPA

1718: IF l_lines_in_set > 0 THEN
1719: SELECT count(1) INTO l_lines_awaiting
1720: FROM oe_order_lines ol, oe_line_sets ols,
1721: wf_item_activity_statuses WIAS,
1722: wf_process_activities WPA
1723: WHERE ol.header_id = p_header_id
1724: AND ols.set_id = C_Set.set_id
1725: AND ols.line_id = ol.line_id
1726: AND WPA.activity_name = 'FULFILL_LINE'

Line 1742: wf_process_activities WPA

1738: SELECT WIAS.Process_Activity, ol.line_id
1739: INTO l_activity_id, l_line_id
1740: FROM oe_order_lines ol, oe_line_sets ols,
1741: wf_item_activity_statuses WIAS,
1742: wf_process_activities WPA
1743: WHERE ol.header_id = p_header_id
1744: AND ols.set_id = C_Set.set_id
1745: AND ols.line_id = ol.line_id
1746: AND WPA.activity_name = 'FULFILL_LINE'