DBA Data[Home] [Help]

APPS.CTO_WIP_WORKFLOW_API_PK dependencies on WIP_FLOW_SCHEDULES

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

339: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
340: and demand_source_line_id = order_line_id
341: and primary_reservation_quantity > 0;
342:
343: -- bugfix 1799874 : as per adrian suherman, we need not worry about internal SO for wip_flow_schedules.
344:
345:
346: v_counter2 := 0;
347:

Line 358: from wip_flow_schedules

354: select 1
355: into v_counter2
356: from dual
357: where exists(select 'x'
358: from wip_flow_schedules
359: where demand_source_type = 2
360: and demand_source_line = to_char(order_line_id)); --Bugfix 6330114
361: Exception when no_data_found then
362: v_counter2 := 0;

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

636: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
637: and demand_source_line_id = order_line_id
638: and primary_reservation_quantity > 0;
639:
640: -- bugfix 1799874 : as per adrian suherman, we need not worry about internal SO for wip_flow_schedules.
641:
642: v_counter2 := 0;
643:
644: -- bug 3840900. rkaza. 08/18/2004. select count(*) logic

Line 652: from wip_flow_schedules

648: select 1
649: into v_counter2
650: from dual
651: where exists(select 'x'
652: from wip_flow_schedules
653: where demand_source_type = 2
654: and demand_source_line = to_char(order_line_id)); --Bugfix 6330114
655: Exception when no_data_found then
656: v_counter2 := 0;