[Home] [Help]
525: apps.instance_type,
526: DECODE(apps.m2a_dblink,NULL,' ', '@' || m2a_dblink),
527: DECODE(apps.a2m_dblink,NULL,NULL_DBLINK,a2m_dblink),
528: LENGTH( apps.instance_code)+2
529: FROM msc_apps_instances apps,
530: ( SELECT distinct
531: sr_instance_id
532: FROM msc_plan_organizations_v plan_org
533: WHERE plan_org.plan_id = arg_plan_id
896: apps.apps_ver,
897: apps.instance_type,
898: DECODE(apps.m2a_dblink,NULL,' ', '@' || m2a_dblink),
899: LENGTH( apps.instance_code)+2
900: FROM msc_apps_instances apps,
901: ( SELECT distinct
902: sr_instance_id
903: FROM msc_plan_organizations_v plan_org
904: WHERE plan_org.plan_id = arg_plan_id
4126: 3,
4127: s.sr_instance_id
4128: From msc_supplies s,
4129: msc_operation_networks nwk,
4130: msc_apps_instances ins,
4131: msc_parameters param
4132: Where nwk.plan_id = s.plan_id
4133: AND nwk.sr_instance_id = s.sr_instance_id
4134: AND nwk.routing_sequence_id = s.routing_sequence_id
4184: s.sr_instance_id,
4185: max(nvl(res.CUMMULATIVE_QUANTITY,0))
4186: From msc_supplies s,
4187: msc_resource_requirements res,
4188: msc_apps_instances ins,
4189: msc_parameters param
4190: Where res.plan_id = s.plan_id
4191: AND res.sr_instance_id = s.sr_instance_id
4192: AND s.transaction_id = res.supply_id
4284: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
4285: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
4286: From msc_supplies s,
4287: msc_resource_requirements res,
4288: msc_apps_instances ins,
4289: msc_parameters param,
4290: msc_department_resources mdr,
4291: msc_system_items msi
4292: Where res.plan_id = s.plan_id
4373: msc_demands md,
4374: msc_system_items icomp,
4375: msc_system_items icomp1,
4376: msc_system_items icomp2,
4377: msc_apps_instances ins,
4378: msc_parameters param
4379: Where /* not exists (select 'x'
4380: from msc_exception_details excp
4381: where excp.plan_id = s.plan_id
4467: , res.resource_seq_num
4468: , res.parent_seq_num
4469: From msc_supplies s,
4470: msc_resource_requirements res,
4471: msc_apps_instances ins,
4472: msc_parameters param
4473: Where res.plan_id = s.plan_id
4474: AND res.sr_instance_id = s.sr_instance_id
4475: AND s.transaction_id = res.supply_id
4563: msc_resource_requirements resreq,
4564: msc_resource_instance_reqs res_instreq, -- changed from design doc
4565: msc_dept_res_instances dep_res_inst,
4566: msc_supplies s,
4567: msc_apps_instances ins,
4568: msc_parameters param
4569: WHERE
4570: tp.sr_tp_id=s.organization_id
4571: AND tp.sr_instance_id= s.sr_instance_id
4682: msc_resource_requirements resreq,
4683: msc_resource_instance_reqs res_instreq,
4684: msc_dept_res_instances dep_res_inst,
4685: msc_supplies s,
4686: msc_apps_instances ins,
4687: msc_parameters param
4688: WHERE
4689: tp.sr_tp_id=s.organization_id
4690: AND tp.sr_instance_id= s.sr_instance_id
5057: 3,
5058: s.sr_instance_id
5059: From msc_supplies s,
5060: msc_job_operation_networks nwk,
5061: msc_apps_instances ins,
5062: msc_parameters param
5063: Where nwk.plan_id = s.plan_id
5064: AND nwk.sr_instance_id = s.sr_instance_id
5065: AND nwk.transaction_id = s.transaction_id
5117: s.sr_instance_id,
5118: max(nvl(res.CUMMULATIVE_QUANTITY,0))
5119: From msc_supplies s,
5120: msc_resource_requirements res,
5121: msc_apps_instances ins,
5122: msc_parameters param
5123: Where res.plan_id = s.plan_id
5124: AND res.sr_instance_id = s.sr_instance_id
5125: AND s.transaction_id = res.supply_id
5222: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
5223: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
5224: From msc_supplies s,
5225: msc_resource_requirements res,
5226: msc_apps_instances ins,
5227: msc_parameters param,
5228: msc_department_resources mdr,
5229: msc_system_items msi
5230: Where res.plan_id = s.plan_id
5313: msc_demands md,
5314: msc_system_items icomp,
5315: msc_system_items icomp1,
5316: msc_system_items icomp2,
5317: msc_apps_instances ins,
5318: msc_parameters param
5319: Where /* not exists (select 'x'
5320: from msc_exception_details excp
5321: where excp.plan_id = s.plan_id
5408: res.resource_seq_num,
5409: res.parent_seq_num
5410: From msc_supplies s,
5411: msc_resource_requirements res,
5412: msc_apps_instances ins,
5413: msc_parameters param
5414: Where res.plan_id = s.plan_id
5415: AND res.sr_instance_id = s.sr_instance_id
5416: AND s.transaction_id = res.supply_id
5508: msc_resource_requirements resreq,
5509: msc_resource_instance_reqs res_instreq, -- changed from design doc
5510: msc_dept_res_instances dep_res_inst,
5511: msc_supplies s,
5512: msc_apps_instances ins,
5513: msc_parameters param
5514: WHERE
5515: tp.sr_tp_id=s.organization_id
5516: AND tp.sr_instance_id= s.sr_instance_id
5626: msc_resource_requirements resreq,
5627: msc_resource_instance_reqs res_instreq,
5628: msc_dept_res_instances dep_res_inst,
5629: msc_supplies s,
5630: msc_apps_instances ins,
5631: msc_parameters param
5632: WHERE
5633: tp.sr_tp_id=s.organization_id
5634: AND tp.sr_instance_id= s.sr_instance_id
9229: --msc_calendar_dates cal2,
9230: msc_trading_partners mp,
9231: msc_system_items msi,
9232: msc_supplies s,
9233: msc_apps_instances mai, -- IR/ISO resch Proj
9234: msc_plan_organizations_v orgs
9235: WHERE --cal1.sr_instance_id= mp.sr_instance_id
9236: --AND cal1.calendar_code = mp.calendar_code
9237: --AND cal1.exception_set_id = mp.calendar_exception_set_id