DBA Data[Home] [Help]

APPS.MSC_ATP_REQ dependencies on MSC_OPERATION_NETWORKS

Line 6211: FROM MSC_OPERATION_NETWORKS

6207: AND (l_network_scheduling_method = 2
6208: OR
6209: OP.OPERATION_SEQUENCE_ID IN
6210: ( SELECT FROM_OP_SEQ_ID
6211: FROM MSC_OPERATION_NETWORKS
6212: WHERE PLAN_ID = p_plan_id
6213: AND SR_INSTANCE_ID = p_instance_id
6214: AND ROUTING_SEQUENCE_ID = l_routing_seq_id
6215: -- AND ROUTING_SEQUENCE_ID = p_routing_seq_id

Line 6221: FROM MSC_OPERATION_NETWORKS

6217:
6218: UNION ALL
6219:
6220: SELECT TO_OP_SEQ_ID
6221: FROM MSC_OPERATION_NETWORKS
6222: WHERE PLAN_ID = p_plan_id
6223: AND SR_INSTANCE_ID = p_instance_id
6224: AND ROUTING_SEQUENCE_ID = l_routing_seq_id
6225: -- AND ROUTING_SEQUENCE_ID = p_routing_seq_id

Line 6461: FROM MSC_OPERATION_NETWORKS

6457: AND (l_network_scheduling_method = 2
6458: OR
6459: OP.OPERATION_SEQUENCE_ID IN
6460: ( SELECT FROM_OP_SEQ_ID
6461: FROM MSC_OPERATION_NETWORKS
6462: WHERE PLAN_ID = p_plan_id
6463: AND SR_INSTANCE_ID = p_instance_id
6464: AND ROUTING_SEQUENCE_ID = l_routing_seq_id
6465: AND TRANSITION_TYPE = 1

Line 6470: FROM MSC_OPERATION_NETWORKS

6466:
6467: UNION ALL
6468:
6469: SELECT TO_OP_SEQ_ID
6470: FROM MSC_OPERATION_NETWORKS
6471: WHERE PLAN_ID = p_plan_id
6472: AND SR_INSTANCE_ID = p_instance_id
6473: AND ROUTING_SEQUENCE_ID = l_routing_seq_id
6474: AND TRANSITION_TYPE = 1

Line 6650: FROM MSC_OPERATION_NETWORKS

6646: AND (l_network_scheduling_method = 2
6647: OR
6648: OP.OPERATION_SEQUENCE_ID IN
6649: ( SELECT FROM_OP_SEQ_ID
6650: FROM MSC_OPERATION_NETWORKS
6651: WHERE PLAN_ID = p_plan_id
6652: AND SR_INSTANCE_ID = p_instance_id
6653: AND ROUTING_SEQUENCE_ID = l_routing_seq_id
6654: AND TRANSITION_TYPE = 1

Line 6659: FROM MSC_OPERATION_NETWORKS

6655:
6656: UNION ALL
6657:
6658: SELECT TO_OP_SEQ_ID
6659: FROM MSC_OPERATION_NETWORKS
6660: WHERE PLAN_ID = p_plan_id
6661: AND SR_INSTANCE_ID = p_instance_id
6662: AND ROUTING_SEQUENCE_ID = l_routing_seq_id
6663: AND TRANSITION_TYPE = 1

Line 9472: FROM MSC_OPERATION_NETWORKS

9468: OR l_network_scheduling_method = 2
9469: OR v1.OPERATION_SEQUENCE_ID IS NULL
9470: OR v1.OPERATION_SEQUENCE_ID IN
9471: ( SELECT FROM_OP_SEQ_ID
9472: FROM MSC_OPERATION_NETWORKS
9473: WHERE PLAN_ID = p_plan_id
9474: AND SR_INSTANCE_ID = p_instance_id
9475: AND ROUTING_SEQUENCE_ID = p_routing_seq_id
9476: AND TRANSITION_TYPE = 1

Line 9481: FROM MSC_OPERATION_NETWORKS

9477:
9478: UNION ALL
9479:
9480: SELECT TO_OP_SEQ_ID
9481: FROM MSC_OPERATION_NETWORKS
9482: WHERE PLAN_ID = p_plan_id
9483: AND SR_INSTANCE_ID = p_instance_id
9484: AND ROUTING_SEQUENCE_ID = p_routing_seq_id
9485: AND TRANSITION_TYPE = 1