[Home] [Help]
654: apps1.instance_type,
655: DECODE(apps1.m2a_dblink,NULL,' ', '@' || m2a_dblink),
656: DECODE(apps1.a2m_dblink,NULL,NULL_DBLINK,a2m_dblink),
657: LENGTH( apps1.instance_code)+2
658: FROM msc_apps_instances apps1,
659: ( SELECT distinct
660: sr_instance_id
661: FROM msc_plan_organizations_v plan_org
662: WHERE plan_org.plan_id = arg_plan_id
1087: apps1.apps_ver,
1088: apps1.instance_type,
1089: DECODE(apps1.m2a_dblink,NULL,' ', '@' || m2a_dblink),
1090: LENGTH( apps1.instance_code)+2
1091: FROM msc_apps_instances apps1,
1092: ( SELECT distinct
1093: sr_instance_id
1094: FROM msc_plan_organizations_v plan_org
1095: WHERE plan_org.plan_id = arg_plan_id
1578: OPEN c_plan_completion_date(arg_plan_id);
1579: FETCH c_plan_completion_date into l_plan_completion_date;
1580: CLOSE c_plan_completion_date;
1581:
1582: select instance_type into lv_inst_type from msc_apps_instances where instance_id = arg_org_instance;
1583:
1584: v_plan_type := l_plan_type; -- For RP Release
1585: -- Get the hour uom code
1586: -- Get the profile MRP_PURCHASING_BY_REVISION is set
4675: 3,
4676: s.sr_instance_id
4677: From msc_supplies s,
4678: msc_operation_networks nwk,
4679: msc_apps_instances ins,
4680: msc_parameters param
4681: Where nwk.plan_id = s.plan_id
4682: AND nwk.sr_instance_id = s.sr_instance_id
4683: AND nwk.routing_sequence_id = s.routing_sequence_id
4733: s.sr_instance_id,
4734: max(nvl(res.CUMMULATIVE_QUANTITY,0))
4735: From msc_supplies s,
4736: msc_resource_requirements res,
4737: msc_apps_instances ins,
4738: msc_parameters param
4739: Where res.plan_id = s.plan_id
4740: AND res.sr_instance_id = s.sr_instance_id
4741: AND s.transaction_id = res.supply_id
4833: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
4834: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
4835: From msc_supplies s,
4836: msc_resource_requirements res,
4837: msc_apps_instances ins,
4838: msc_parameters param,
4839: msc_department_resources mdr,
4840: msc_system_items msi
4841: Where res.plan_id = s.plan_id
4922: msc_demands md,
4923: msc_system_items icomp,
4924: msc_system_items icomp1,
4925: msc_system_items icomp2,
4926: msc_apps_instances ins,
4927: msc_parameters param
4928: Where /* not exists (select 'x'
4929: from msc_exception_details excp
4930: where excp.plan_id = s.plan_id
5016: , res.resource_seq_num
5017: , res.parent_seq_num
5018: From msc_supplies s,
5019: msc_resource_requirements res,
5020: msc_apps_instances ins,
5021: msc_parameters param
5022: Where res.plan_id = s.plan_id
5023: AND res.sr_instance_id = s.sr_instance_id
5024: AND s.transaction_id = res.supply_id
5112: msc_resource_requirements resreq,
5113: msc_resource_instance_reqs res_instreq, -- changed from design doc
5114: msc_dept_res_instances dep_res_inst,
5115: msc_supplies s,
5116: msc_apps_instances ins,
5117: msc_parameters param
5118: WHERE
5119: tp.sr_tp_id=s.organization_id
5120: AND tp.sr_instance_id= s.sr_instance_id
5231: msc_resource_requirements resreq,
5232: msc_resource_instance_reqs res_instreq,
5233: msc_dept_res_instances dep_res_inst,
5234: msc_supplies s,
5235: msc_apps_instances ins,
5236: msc_parameters param
5237: WHERE
5238: tp.sr_tp_id=s.organization_id
5239: AND tp.sr_instance_id= s.sr_instance_id
5613: 3,
5614: s.sr_instance_id
5615: From msc_supplies s,
5616: msc_job_operation_networks nwk,
5617: msc_apps_instances ins,
5618: msc_parameters param
5619: Where nwk.plan_id = s.plan_id
5620: AND nwk.sr_instance_id = s.sr_instance_id
5621: AND nwk.transaction_id = s.transaction_id
5673: s.sr_instance_id,
5674: max(nvl(res.CUMMULATIVE_QUANTITY,0))
5675: From msc_supplies s,
5676: msc_resource_requirements res,
5677: msc_apps_instances ins,
5678: msc_parameters param
5679: Where res.plan_id = s.plan_id
5680: AND res.sr_instance_id = s.sr_instance_id
5681: AND s.transaction_id = res.supply_id
5778: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
5779: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
5780: From msc_supplies s,
5781: msc_resource_requirements res,
5782: msc_apps_instances ins,
5783: msc_parameters param,
5784: msc_department_resources mdr,
5785: msc_system_items msi
5786: Where res.plan_id = s.plan_id
5869: msc_demands md,
5870: msc_system_items icomp,
5871: msc_system_items icomp1,
5872: msc_system_items icomp2,
5873: msc_apps_instances ins,
5874: msc_parameters param
5875: Where /* not exists (select 'x'
5876: from msc_exception_details excp
5877: where excp.plan_id = s.plan_id
5964: res.resource_seq_num,
5965: res.parent_seq_num
5966: From msc_supplies s,
5967: msc_resource_requirements res,
5968: msc_apps_instances ins,
5969: msc_parameters param
5970: Where res.plan_id = s.plan_id
5971: AND res.sr_instance_id = s.sr_instance_id
5972: AND s.transaction_id = res.supply_id
6064: msc_resource_requirements resreq,
6065: msc_resource_instance_reqs res_instreq, -- changed from design doc
6066: msc_dept_res_instances dep_res_inst,
6067: msc_supplies s,
6068: msc_apps_instances ins,
6069: msc_parameters param
6070: WHERE
6071: tp.sr_tp_id=s.organization_id
6072: AND tp.sr_instance_id= s.sr_instance_id
6182: msc_resource_requirements resreq,
6183: msc_resource_instance_reqs res_instreq,
6184: msc_dept_res_instances dep_res_inst,
6185: msc_supplies s,
6186: msc_apps_instances ins,
6187: msc_parameters param
6188: WHERE
6189: tp.sr_tp_id=s.organization_id
6190: AND tp.sr_instance_id= s.sr_instance_id
10098: --msc_calendar_dates cal2,
10099: msc_trading_partners mp,
10100: msc_system_items msi,
10101: msc_supplies s,
10102: msc_apps_instances mai, -- IR/ISO resch Proj
10103: msc_plan_organizations_v orgs
10104: WHERE --cal1.sr_instance_id= mp.sr_instance_id
10105: --AND cal1.calendar_code = mp.calendar_code
10106: --AND cal1.exception_set_id = mp.calendar_exception_set_id