DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on WSM_COPY_OP_NETWORKS

Line 2437: FROM WSM_COPY_OP_NETWORKS WCON

2433: --bug 3370199 introduced the if block after this SQL
2434: BEGIN
2435: SELECT 1
2436: INTO l_temp
2437: FROM WSM_COPY_OP_NETWORKS WCON
2438: WHERE WCON.wip_entity_id=l_wip_entity_id
2439: AND WCON.from_op_seq_id=l_wo_op_seq_id
2440: AND WCON.to_op_seq_num=p_to_op_seq_num;
2441: EXCEPTION

Line 2450: FROM WSM_COPY_OP_NETWORKS WCON

2446: IF (l_temp = 0) THEN
2447: BEGIN
2448: SELECT 1
2449: INTO l_temp
2450: FROM WSM_COPY_OP_NETWORKS WCON
2451: WHERE WCON.wip_entity_id=l_wip_entity_id
2452: AND WCON.from_op_seq_num = l_wo_rtg_op_seq_num
2453: AND WCON.to_op_seq_num=p_to_op_seq_num;
2454:

Line 12485: FROM wsm_copy_op_networks wcon

12481: INTO l_next_links_exist
12482: FROM dual
12483: WHERE EXISTS
12484: (SELECT 'next_links_exist'
12485: FROM wsm_copy_op_networks wcon
12486: WHERE wcon.wip_entity_id = p_wip_entity_id
12487: AND wcon.from_op_seq_num = p_routing_operation
12488: );
12489: EXCEPTION