DBA Data[Home] [Help]

APPS.CTO_WORKBENCH_UTIL_PK dependencies on WIP_FLOW_SCHEDULES

Line 236: from wip_flow_schedules

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

Line 688: -- while querying from wip_flow_schedules

684: -- process for Top, Ato, Std items.
685: --
686: -- bug 6833994
687: -- Added a to_char() clause on the l_config_line_id
688: -- while querying from wip_flow_schedules
689: -- ntungare
690: --
691: Select max(exp_comp_date) into l_date
692: from

Line 704: FROM wip_flow_schedules wfs

700:
701: UNION
702:
703: SELECT wfs.scheduled_completion_date exp_comp_date
704: FROM wip_flow_schedules wfs
705: WHERE wfs.demand_source_line = to_char(l_config_line_id)
706: AND wfs.status = 1
707:
708: UNION