DBA Data[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on MSC_ROUTINGS

Line 221: msc_routings mr,

217:
218: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
219: into lv_yield
220: from msc_process_effectivity mpe,
221: msc_routings mr,
222: msc_resource_requirements mrr
223: where mpe.sr_instance_id = inst_id
224: and mpe.plan_id = pln_id
225: and mpe.process_sequence_id = process_seq_id

Line 280: msc_routings mr,

276:
277: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
278: into lv_yield_dis
279: from msc_process_effectivity mpe,
280: msc_routings mr,
281: msc_resource_requirements mrr
282: where mpe.sr_instance_id = inst_id
283: and mpe.plan_id = pln_id
284: and mpe.process_sequence_id = process_seq_id

Line 342: msc_routings mr,

338:
339: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
340: into lv_yield_dis
341: from msc_process_effectivity mpe,
342: msc_routings mr,
343: msc_resource_requirements mrr
344: where mpe.sr_instance_id = inst_id
345: and mpe.plan_id = pln_id
346: and mpe.process_sequence_id = process_seq_id