APPS.MSC_REL_PLAN_PUB dependencies on MSC_PROCESS_EFFECTIVITY

Line 228: from msc_process_effectivity mpe,

224: BEGIN
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

Line 287: from msc_process_effectivity mpe,

283: END IF;
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

Line 349: from msc_process_effectivity mpe,

345: END IF;
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

Line 415: msc_process_effectivity mpe

411:
412: SELECT mbc.WIP_SUPPLY_TYPE
413: INTO lv_wip_sup_type
414: FROM MSC_BOM_COMPONENTS mbc,
415: msc_process_effectivity mpe
416: where mpe.sr_instance_id = p_inst_id
417: and mpe.plan_id = p_plan_id
418: and mpe.process_sequence_id = p_process_seq_id
419: AND mpe.organization_id = p_org_id

Line 4606: msc_process_effectivity mpe,

4602: , nvl(s.requested_completion_date, s.need_by_date)
4603: FROM msc_trading_partners tp,
4604: msc_parameters param,
4605: msc_system_items msi,
4606: msc_process_effectivity mpe,
4607: msc_supplies s
4608: WHERE tp.sr_tp_id= msi.organization_id
4609: AND tp.sr_instance_id= msi.sr_instance_id
4610: AND tp.partner_type=3

Line 6746: msc_process_effectivity mpe,

6742: , nvl(s.requested_completion_date, s.need_by_date)
6743: FROM msc_trading_partners tp,
6744: msc_parameters param,
6745: msc_system_items msi,
6746: msc_process_effectivity mpe,
6747: msc_supplies s,
6748: msc_boms mb
6749: WHERE tp.sr_tp_id= msi.organization_id
6750: AND tp.sr_instance_id= msi.sr_instance_id

Line 9411: msc_process_effectivity mpe,

9407: s.sr_instance_id
9408: FROM msc_trading_partners tp,
9409: msc_parameters param,
9410: msc_system_items msi,
9411: msc_process_effectivity mpe,
9412: msc_supplies s,
9413: msc_plan_organizations_v orgs
9414: WHERE tp.sr_tp_id= msi.organization_id
9415: AND tp.sr_instance_id= msi.sr_instance_id

Line 10654: msc_process_effectivity mpe,

10650: , nvl(s.requested_completion_date, s.need_by_date)
10651: FROM msc_trading_partners tp,
10652: msc_parameters param,
10653: msc_system_items msi,
10654: msc_process_effectivity mpe,
10655: msc_supplies s
10656: WHERE tp.sr_tp_id= msi.organization_id
10657: AND tp.sr_instance_id= msi.sr_instance_id
10658: AND tp.partner_type=3