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 1789: -- bugfix 1799874 : as per adrian suherman, we need not worry about internal SO for wip_flow_schedules.

1785:
1786: v_counter2 := 0;
1787: l_stmt_num := 40;
1788:
1789: -- bugfix 1799874 : as per adrian suherman, we need not worry about internal SO for wip_flow_schedules.
1790:
1791: -- Look at the reservation qty in Flow schedule table
1792:
1793: select count(*)

Line 1795: from wip_flow_schedules

1791: -- Look at the reservation qty in Flow schedule table
1792:
1793: select count(*)
1794: into v_counter2
1795: from wip_flow_schedules
1796: where demand_source_type = 2
1797: and demand_source_line = to_char(p_order_line_id)
1798: and status <> 2; -- 3076061 Flow Schedule status : 1 = Open 2 = Closed/Completed
1799: