DBA Data[Home] [Help]

APPS.CTO_WORKFLOW dependencies on WIP_FLOW_SCHEDULES

Line 2513: -- Check to see if reservns exist in wip_flow_schedules

2509: and rownum = 1;
2510:
2511:
2512: if lRsvCount = 0 then
2513: -- Check to see if reservns exist in wip_flow_schedules
2514: select count(*)
2515: into lFloCount
2516: from wip_flow_schedules
2517: where demand_source_type = inv_reservation_global.g_source_type_oe

Line 2516: from wip_flow_schedules

2512: if lRsvCount = 0 then
2513: -- Check to see if reservns exist in wip_flow_schedules
2514: select count(*)
2515: into lFloCount
2516: from wip_flow_schedules
2517: where demand_source_type = inv_reservation_global.g_source_type_oe
2518: and demand_source_line = to_char(pLineId)
2519: and status <> 2; -- Flow Schedule status : 1 = Open 2 = Closed/Completed
2520: else

Line 4446: from wip_flow_schedules wfs,

4442: begin
4443:
4444: select wip_entity_id
4445: into lWipEntityId
4446: from wip_flow_schedules wfs,
4447: oe_order_lines_all oel,
4448: oe_order_headers_all oeh,
4449: oe_transaction_types_all ota,
4450: oe_transaction_types_tl otl,