DBA Data[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on MSC_ROUTINGS

Line 229: msc_routings mr,

225:
226: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
227: into lv_yield
228: from msc_process_effectivity mpe,
229: msc_routings mr,
230: msc_resource_requirements mrr
231: where mpe.sr_instance_id = inst_id
232: and mpe.plan_id = pln_id
233: and mpe.process_sequence_id = process_seq_id

Line 288: msc_routings mr,

284:
285: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
286: into lv_yield_dis
287: from msc_process_effectivity mpe,
288: msc_routings mr,
289: msc_resource_requirements mrr
290: where mpe.sr_instance_id = inst_id
291: and mpe.plan_id = pln_id
292: and mpe.process_sequence_id = process_seq_id

Line 350: msc_routings mr,

346:
347: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
348: into lv_yield_dis
349: from msc_process_effectivity mpe,
350: msc_routings mr,
351: msc_resource_requirements mrr
352: where mpe.sr_instance_id = inst_id
353: and mpe.plan_id = pln_id
354: and mpe.process_sequence_id = process_seq_id