APPS.CTO_WORKBENCH_UTIL_PK dependencies on WIP_FLOW_SCHEDULES

Line 239: from wip_flow_schedules

235: END IF;
236:
237: select count(*)
238: into v_flow_count
239: from wip_flow_schedules
240: where demand_source_type = inv_reservation_global.g_source_type_oe
241: and demand_source_line =to_char(l_demand_line_id)
242: and status = 1;
243:

Line 778: -- while querying from wip_flow_schedules

774: -- process for Top, Ato, Std items.
775: --
776: -- bug 6833994
777: -- Added a to_char() clause on the l_config_line_id
778: -- while querying from wip_flow_schedules
779: -- ntungare
780: --
781: Select max(exp_comp_date) into l_date
782: from

Line 794: FROM wip_flow_schedules wfs

790:
791: UNION
792:
793: SELECT wfs.scheduled_completion_date exp_comp_date
794: FROM wip_flow_schedules wfs
795: WHERE wfs.demand_source_line = to_char(l_config_line_id)
796: AND wfs.status = 1
797:
798: UNION