DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_ROUTING_OPERATIONS

Line 8971: FROM msc_process_effectivity eff, msc_routing_operations op

8967: > TRUNC(GREATEST(p_new_schedule_date, sysdate, MSC_ATP_PVT.G_PTF_DATE))
8968: ORDER BY preference */
8969: --4570421
8970: SELECT eff.process_sequence_id, eff.routing_sequence_id, eff.bill_sequence_id, op.operation_sequence_id
8971: FROM msc_process_effectivity eff, msc_routing_operations op
8972: WHERE eff.plan_id = p_plan_id
8973: AND eff.organization_id = p_organization_id
8974: AND eff.item_id = p_item_id
8975: AND eff.sr_instance_id = p_sr_instance_id