DBA Data[Home] [Help]

APPS.OE_SALES_CAN_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1721: wf_item_activity_statuses WIAS,

1717: -- Count the lines that are awaiting fulfillment for this set
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

Line 1741: wf_item_activity_statuses WIAS,

1737: -- This is to pick up 1 line in the set in Fulfill:Notified
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