[Home] [Help]
172: apps.instance_type,
173: DECODE(apps.m2a_dblink,NULL,' ', '@' || m2a_dblink),
174: DECODE(apps.a2m_dblink,NULL,NULL_DBLINK,a2m_dblink),
175: LENGTH( apps.instance_code)+2
176: FROM msc_apps_instances apps,
177: ( SELECT distinct
178: sr_instance_id
179: FROM msc_plan_organizations_v plan_org
180: WHERE plan_org.plan_id = arg_plan_id
1127: 3,
1128: s.sr_instance_id
1129: From msc_supplies s,
1130: msc_operation_networks nwk,
1131: msc_apps_instances ins,
1132: msc_parameters param
1133: Where nwk.plan_id = -1
1134: AND nwk.sr_instance_id = s.sr_instance_id
1135: AND nwk.routing_sequence_id = s.routing_sequence_id
1185: s.sr_instance_id,
1186: max(res.CUMMULATIVE_QUANTITY)
1187: From msc_supplies s,
1188: msc_resource_requirements res,
1189: msc_apps_instances ins,
1190: msc_parameters param
1191: Where res.plan_id = s.plan_id
1192: AND res.sr_instance_id = s.sr_instance_id
1193: AND s.transaction_id = res.supply_id
1302:
1303: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
1304: From msc_supplies s,
1305: msc_resource_requirements res,
1306: msc_apps_instances ins,
1307: msc_parameters param,
1308: msc_department_resources mdr,
1309: msc_system_items msi
1310: Where res.plan_id = s.plan_id
1392: msc_demands md,
1393: msc_system_items icomp,
1394: msc_system_items icomp1,
1395: msc_system_items icomp2,
1396: msc_apps_instances ins,
1397: msc_parameters param
1398: Where /* not exists (select 'x'
1399: from msc_exception_details excp
1400: where excp.plan_id = s.plan_id
1481: res.resource_seq_num,
1482: res.parent_seq_num
1483: From msc_supplies s,
1484: msc_resource_requirements res,
1485: msc_apps_instances ins,
1486: msc_parameters param
1487: Where res.plan_id = s.plan_id
1488: AND res.sr_instance_id = s.sr_instance_id
1489: AND s.transaction_id = res.supply_id
1574: msc_trading_partners tp,
1575: msc_resource_requirements resreq,
1576: msc_resource_instance_reqs res_instreq,
1577: msc_supplies s,
1578: msc_apps_instances ins,
1579: msc_parameters param
1580: WHERE
1581: tp.sr_tp_id=s.organization_id
1582: AND tp.sr_instance_id= s.sr_instance_id
1681: msc_trading_partners tp,
1682: msc_resource_requirements resreq,
1683: msc_resource_instance_reqs res_instreq,
1684: msc_supplies s,
1685: msc_apps_instances ins,
1686: msc_parameters param
1687: WHERE
1688: tp.sr_tp_id=s.organization_id
1689: AND tp.sr_instance_id= s.sr_instance_id
1994: 3,
1995: s.sr_instance_id
1996: From msc_supplies s,
1997: msc_job_operation_networks nwk,
1998: msc_apps_instances ins,
1999: msc_parameters param
2000: Where nwk.plan_id = -1
2001: AND nwk.sr_instance_id = s.sr_instance_id
2002: AND nwk.transaction_id = s.transaction_id
2055: s.sr_instance_id,
2056: max(res.CUMMULATIVE_QUANTITY)
2057: From msc_supplies s,
2058: msc_resource_requirements res,
2059: msc_apps_instances ins,
2060: msc_parameters param
2061: Where res.plan_id = s.plan_id
2062: AND res.sr_instance_id = s.sr_instance_id
2063: AND s.transaction_id = res.supply_id
2178: ),
2179: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
2180: From msc_supplies s,
2181: msc_resource_requirements res,
2182: msc_apps_instances ins,
2183: msc_parameters param,
2184: msc_department_resources mdr,
2185: msc_system_items msi
2186: Where res.plan_id = s.plan_id
2271: msc_demands md,
2272: msc_system_items icomp,
2273: msc_system_items icomp1,
2274: msc_system_items icomp2,
2275: msc_apps_instances ins,
2276: msc_parameters param
2277: Where /* not exists (select 'x'
2278: from msc_exception_details excp
2279: where excp.plan_id = s.plan_id
2363: res.resource_seq_num,
2364: res.parent_seq_num
2365: From msc_supplies s,
2366: msc_resource_requirements res,
2367: msc_apps_instances ins,
2368: msc_parameters param
2369: Where res.plan_id = s.plan_id
2370: AND res.sr_instance_id = s.sr_instance_id
2371: AND s.transaction_id = res.supply_id
2458: FROM msc_trading_partners tp,
2459: msc_resource_requirements resreq,
2460: msc_resource_instance_reqs res_instreq,
2461: msc_supplies s,
2462: msc_apps_instances ins,
2463: msc_parameters param
2464: WHERE
2465: tp.sr_tp_id=s.organization_id
2466: AND tp.sr_instance_id= s.sr_instance_id
2565: msc_trading_partners tp,
2566: msc_resource_requirements resreq,
2567: msc_resource_instance_reqs res_instreq,
2568: msc_supplies s,
2569: msc_apps_instances ins,
2570: msc_parameters param
2571: WHERE
2572: tp.sr_tp_id=s.organization_id
2573: AND tp.sr_instance_id= s.sr_instance_id