DBA Data[Home] [Help]

APPS.MSC_ATP_REQ dependencies on MSC_OPERATION_NETWORKS

Line 6210: FROM MSC_OPERATION_NETWORKS

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

Line 6219: FROM MSC_OPERATION_NETWORKS

6215:
6216: UNION ALL
6217:
6218: SELECT TO_OP_SEQ_ID
6219: FROM MSC_OPERATION_NETWORKS
6220: WHERE PLAN_ID = p_plan_id
6221: AND SR_INSTANCE_ID = p_instance_id
6222: AND ROUTING_SEQUENCE_ID = p_routing_seq_id
6223: AND TRANSITION_TYPE = 1

Line 6457: FROM MSC_OPERATION_NETWORKS

6453: AND (l_network_scheduling_method = 2
6454: OR
6455: OP.OPERATION_SEQUENCE_ID IN
6456: ( SELECT FROM_OP_SEQ_ID
6457: FROM MSC_OPERATION_NETWORKS
6458: WHERE PLAN_ID = p_plan_id
6459: AND SR_INSTANCE_ID = p_instance_id
6460: AND ROUTING_SEQUENCE_ID = p_routing_seq_id
6461: AND TRANSITION_TYPE = 1

Line 6466: FROM MSC_OPERATION_NETWORKS

6462:
6463: UNION ALL
6464:
6465: SELECT TO_OP_SEQ_ID
6466: FROM MSC_OPERATION_NETWORKS
6467: WHERE PLAN_ID = p_plan_id
6468: AND SR_INSTANCE_ID = p_instance_id
6469: AND ROUTING_SEQUENCE_ID = p_routing_seq_id
6470: AND TRANSITION_TYPE = 1

Line 6646: FROM MSC_OPERATION_NETWORKS

6642: AND (l_network_scheduling_method = 2
6643: OR
6644: OP.OPERATION_SEQUENCE_ID IN
6645: ( SELECT FROM_OP_SEQ_ID
6646: FROM MSC_OPERATION_NETWORKS
6647: WHERE PLAN_ID = p_plan_id
6648: AND SR_INSTANCE_ID = p_instance_id
6649: AND ROUTING_SEQUENCE_ID = p_routing_seq_id
6650: AND TRANSITION_TYPE = 1

Line 6655: FROM MSC_OPERATION_NETWORKS

6651:
6652: UNION ALL
6653:
6654: SELECT TO_OP_SEQ_ID
6655: FROM MSC_OPERATION_NETWORKS
6656: WHERE PLAN_ID = p_plan_id
6657: AND SR_INSTANCE_ID = p_instance_id
6658: AND ROUTING_SEQUENCE_ID = p_routing_seq_id
6659: AND TRANSITION_TYPE = 1

Line 9466: FROM MSC_OPERATION_NETWORKS

9462: OR l_network_scheduling_method = 2
9463: OR v1.OPERATION_SEQUENCE_ID IS NULL
9464: OR v1.OPERATION_SEQUENCE_ID IN
9465: ( SELECT FROM_OP_SEQ_ID
9466: FROM MSC_OPERATION_NETWORKS
9467: WHERE PLAN_ID = p_plan_id
9468: AND SR_INSTANCE_ID = p_instance_id
9469: AND ROUTING_SEQUENCE_ID = p_routing_seq_id
9470: AND TRANSITION_TYPE = 1

Line 9475: FROM MSC_OPERATION_NETWORKS

9471:
9472: UNION ALL
9473:
9474: SELECT TO_OP_SEQ_ID
9475: FROM MSC_OPERATION_NETWORKS
9476: WHERE PLAN_ID = p_plan_id
9477: AND SR_INSTANCE_ID = p_instance_id
9478: AND ROUTING_SEQUENCE_ID = p_routing_seq_id
9479: AND TRANSITION_TYPE = 1