APPS.CTO_WORKFLOW_API_PK dependencies on WIP_FLOW_SCHEDULES

Line 199: | -qyery on wip_flow_schedules has been removed

195: | -cursor c-resv chnaged to include secondary
196: | reservation qty
197: | -sec rsv qty has been assigned to record
198: | structure x_rsv_rec(l_index) and debug messages
199: | -qyery on wip_flow_schedules has been removed
200: | and existing FLM api get_flow_qty is used to
201: | get flow qty in both cases of fresh order line
202: | and split order line
203: | -new query to get external and internal

Line 1762: -- bugfix 1799874 : as per adrian suherman, we need not worry about internal SO for wip_flow_schedules.

1758:
1759: v_counter2 := 0;
1760: l_stmt_num := 40;
1761:
1762: -- bugfix 1799874 : as per adrian suherman, we need not worry about internal SO for wip_flow_schedules.
1763:
1764: -- Look at the reservation qty in Flow schedule table
1765:
1766: select count(*)

Line 1768: from wip_flow_schedules

1764: -- Look at the reservation qty in Flow schedule table
1765:
1766: select count(*)
1767: into v_counter2
1768: from wip_flow_schedules
1769: where demand_source_type = 2
1770: and demand_source_line = to_char(p_order_line_id)
1771: and status <> 2; -- 3076061 Flow Schedule status : 1 = Open 2 = Closed/Completed
1772: