APPS.MSC_ATP_PROC dependencies on MSC_PROCESS_EFFECTIVITY

Line 8966: FROM msc_process_effectivity

8962: FROM
8963: (
8964: /*
8965: SELECT process_sequence_id,routing_sequence_id,bill_sequence_id
8966: FROM msc_process_effectivity
8967: WHERE plan_id = p_plan_id
8968: AND organization_id = p_organization_id
8969: AND item_id = p_item_id
8970: AND sr_instance_id = p_sr_instance_id

Line 8982: SELECT /*+ leading(eff) INDEX(eff MSC_PROCESS_EFFECTIVITY_U2) */

8978: > TRUNC(GREATEST(p_new_schedule_date, sysdate, MSC_ATP_PVT.G_PTF_DATE))
8979: ORDER BY preference */
8980:
8981: --4570421 --bug 10139262
8982: SELECT /*+ leading(eff) INDEX(eff MSC_PROCESS_EFFECTIVITY_U2) */
8983: eff.process_sequence_id, eff.routing_sequence_id, eff.bill_sequence_id, op.operation_sequence_id
8984: FROM msc_process_effectivity eff, msc_routing_operations op
8985: WHERE eff.plan_id = p_plan_id
8986: AND eff.organization_id = p_organization_id

Line 8984: FROM msc_process_effectivity eff, msc_routing_operations op

8980:
8981: --4570421 --bug 10139262
8982: SELECT /*+ leading(eff) INDEX(eff MSC_PROCESS_EFFECTIVITY_U2) */
8983: eff.process_sequence_id, eff.routing_sequence_id, eff.bill_sequence_id, op.operation_sequence_id
8984: FROM msc_process_effectivity eff, msc_routing_operations op
8985: WHERE eff.plan_id = p_plan_id
8986: AND eff.organization_id = p_organization_id
8987: AND eff.item_id = p_item_id
8988: AND eff.sr_instance_id = p_sr_instance_id