1311: IS
1312: SELECT 'Y' has_ops
1313: FROM sys.dual
1314: WHERE exists ( Select null
1315: FROM Bom_Operation_Sequences
1316: WHERE routing_sequence_id =
1317: p_routing_sequence_id );
1318:
1319: -- CTP flag check for routing type
1342: IS
1343: SELECT 'Y'
1344: FROM sys.dual
1345: WHERE exists ( Select null
1346: FROM Bom_Operation_Sequences
1347: WHERE routing_sequence_id =p_routing_sequence_id
1348: AND NVL(disable_date, trunc(sysdate) + 1)
1349: > trunc(sysdate)
1350: );
2578: Select 'IsNotValid'
2579: from dual
2580: where p_rtg_header_rec.ser_start_op_seq NOT IN
2581: (select bos.OPERATION_SEQ_NUM
2582: from bom_operation_sequences bos
2583: where bos.ROUTING_SEQUENCE_ID = p_rtg_header_unexp_rec.routing_sequence_id
2584: and nvl(bos.OPERATION_TYPE,1) = 1
2585: and nvl(bos.EFFECTIVITY_DATE, sysdate-1) <= sysdate
2586: and nvl(bos.disable_date , sysdate + 1) >= sysdate
2661: x_return_status := FND_API.G_RET_STS_SUCCESS;
2662:
2663: SELECT COUNT(1)
2664: INTO l_nw_opern_count
2665: FROM BOM_OPERATION_SEQUENCES bos,
2666: BOM_OPERATION_NETWORKS bon
2667: WHERE
2668: bon.FROM_OP_SEQ_ID = bos.OPERATION_SEQUENCE_ID
2669: AND bos.ROUTING_SEQUENCE_ID = p_routing_sequence_id;