[Home] [Help]
216: BEGIN
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
275: END IF;
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
337: END IF;
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
403:
404: SELECT mbc.WIP_SUPPLY_TYPE
405: INTO lv_wip_sup_type
406: FROM MSC_BOM_COMPONENTS mbc,
407: msc_process_effectivity mpe
408: where mpe.sr_instance_id = p_inst_id
409: and mpe.plan_id = p_plan_id
410: and mpe.process_sequence_id = p_process_seq_id
411: AND mpe.organization_id = p_org_id
4053: , nvl(s.requested_completion_date, s.need_by_date)
4054: FROM msc_trading_partners tp,
4055: msc_parameters param,
4056: msc_system_items msi,
4057: msc_process_effectivity mpe,
4058: msc_supplies s
4059: WHERE tp.sr_tp_id= msi.organization_id
4060: AND tp.sr_instance_id= msi.sr_instance_id
4061: AND tp.partner_type=3
6081: , nvl(s.requested_completion_date, s.need_by_date)
6082: FROM msc_trading_partners tp,
6083: msc_parameters param,
6084: msc_system_items msi,
6085: msc_process_effectivity mpe,
6086: msc_supplies s
6087: WHERE tp.sr_tp_id= msi.organization_id
6088: AND tp.sr_instance_id= msi.sr_instance_id
6089: AND tp.partner_type=3
8564: s.sr_instance_id
8565: FROM msc_trading_partners tp,
8566: msc_parameters param,
8567: msc_system_items msi,
8568: msc_process_effectivity mpe,
8569: msc_supplies s,
8570: msc_plan_organizations_v orgs
8571: WHERE tp.sr_tp_id= msi.organization_id
8572: AND tp.sr_instance_id= msi.sr_instance_id