DBA Data[Home] [Help]

APPS.CTO_WORKFLOW dependencies on WIP_FLOW_SCHEDULES

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

2542: and rownum = 1;
2543:
2544:
2545: if lRsvCount = 0 then
2546: -- Check to see if reservns exist in wip_flow_schedules
2547: select count(*)
2548: into lFloCount
2549: from wip_flow_schedules
2550: where demand_source_type = inv_reservation_global.g_source_type_oe

Line 2549: from wip_flow_schedules

2545: if lRsvCount = 0 then
2546: -- Check to see if reservns exist in wip_flow_schedules
2547: select count(*)
2548: into lFloCount
2549: from wip_flow_schedules
2550: where demand_source_type = inv_reservation_global.g_source_type_oe
2551: and demand_source_line = to_char(pLineId)
2552: and status <> 2; -- Flow Schedule status : 1 = Open 2 = Closed/Completed
2553: else

Line 4545: from wip_flow_schedules wfs,

4541: begin
4542:
4543: select wip_entity_id
4544: into lWipEntityId
4545: from wip_flow_schedules wfs,
4546: oe_order_lines_all oel,
4547: oe_order_headers_all oeh,
4548: oe_transaction_types_all ota,
4549: oe_transaction_types_tl otl,