APPS.BOM_VALIDATE_OP_NETWORK dependencies on BOM_OPERATIONAL_ROUTINGS

Line 81: FROM bom_operational_routings

77: THEN
78: BEGIN
79: SELECT common_routing_sequence_id
80: INTO l_common_routing_sequence_id
81: FROM bom_operational_routings
82: WHERE routing_sequence_id =
83: p_op_network_unexp_rec.routing_sequence_id ;
84: END ;
85:

Line 1401: from bom_operational_routings where

1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398:
1399: select routing_sequence_id, cfm_routing_flag
1400: into l_routing_sequence_id,l_cfm_routing_flag
1401: from bom_operational_routings where
1402: routing_sequence_id = p_routing_sequence_id;
1403:
1404: -- Get Common Routing Seq Id from System Info Rec.
1405: -- If the value is Null, set Common Routing Seq Id.

Line 1412: FROM bom_operational_routings

1408: l_common_routing_sequence_id = FND_API.G_MISS_NUM THEN
1409: BEGIN
1410: SELECT common_routing_sequence_id
1411: INTO l_common_routing_sequence_id
1412: FROM bom_operational_routings
1413: WHERE routing_sequence_id = l_routing_sequence_id;
1414: END ;
1415: BOM_Rtg_Globals.Set_Common_Rtg_Seq_id
1416: ( p_common_rtg_seq_id => l_common_routing_sequence_id );