[Home] [Help]
937: Begin
938: SELECT 2
939: Into lv_agg_details(k)
940: FROM msc_department_resources deptres,
941: msc_resource_requirements resreq
942: WHERE resreq.sr_instance_id= lv_instance_id(k)
943: AND resreq.supply_id = lv_transaction_id(k)
944: AND resreq.organization_id= lv_org_id(k)
945: AND resreq.plan_id = lv_plan_id(k)
1184: 3,
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
1301: ),
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
1480: res.orig_resource_seq_num,
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
1571: , resreq.resource_id
1572: , 1
1573: FROM
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
1678: , resreq.resource_id
1679: , 1
1680: FROM
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
1792: Begin
1793: SELECT 2
1794: Into lv_agg_details(k)
1795: FROM msc_department_resources deptres,
1796: msc_resource_requirements resreq
1797: WHERE resreq.sr_instance_id= lv_instance_id(k)
1798: AND resreq.supply_id = lv_transaction_id(k)
1799: AND resreq.organization_id= lv_org_id(k)
1800: AND resreq.plan_id = lv_plan_id(k)
2054: 3,
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
2177: res.RESOURCE_HOURS
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
2362: res.orig_resource_seq_num,
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
2455: 3,
2456: resreq.resource_id,
2457: 1
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
2562: , resreq.resource_id
2563: , 1
2564: FROM
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
2732: Begin
2733: SELECT 2
2734: Into lv_agg_details(k)
2735: FROM msc_department_resources deptres,
2736: msc_resource_requirements resreq
2737: WHERE resreq.sr_instance_id= lv_instance_id(k)
2738: AND resreq.supply_id = lv_transaction_id(k)
2739: AND resreq.organization_id= lv_org_id(k)
2740: AND resreq.plan_id = lv_plan_id(k)
2943: 1,
2944: resreq.operation_sequence_id, --Outbound changes for XML
2945: s.sr_instance_id
2946: FROM msc_trading_partners tp,
2947: msc_resource_requirements resreq,
2948: msc_parameters param,
2949: msc_supplies s
2950: WHERE tp.sr_tp_id= s.organization_id
2951: AND tp.sr_instance_id= s.sr_instance_id
3087: resreq.parent_seq_num,
3088: resreq.orig_resource_seq_num,
3089: resreq.resource_seq_num
3090: FROM msc_trading_partners tp,
3091: msc_resource_requirements resreq,
3092: msc_parameters param,
3093: msc_supplies s,
3094: msc_department_resources mdr --MN: "C" type , can we just say mdr.plan_id = -1 ??
3095: WHERE tp.sr_tp_id= s.organization_id
3490: resreq.department_id,
3491: resreq.resource_hours,
3492: resreq.parent_seq_num
3493: FROM msc_trading_partners tp,
3494: msc_resource_requirements resreq,
3495: msc_parameters param,
3496: msc_supplies s,
3497: msc_department_resources mdr
3498: WHERE tp.sr_tp_id= s.organization_id
3590: 1 ,
3591: resreq.parent_seq_num
3592: FROM
3593: msc_trading_partners tp,
3594: msc_resource_requirements resreq,
3595: msc_resource_instance_reqs res_instreq,
3596: msc_dept_res_instances dep_res_inst,
3597: msc_supplies s
3598: WHERE
3695: 1 ,
3696: resreq.parent_seq_num
3697: FROM
3698: msc_trading_partners tp,
3699: msc_resource_requirements resreq,
3700: msc_resource_instance_reqs res_instreq,
3701: msc_supplies s
3702: WHERE
3703: tp.sr_tp_id=s.organization_id
3822: Begin
3823: SELECT 2
3824: Into lv_agg_details(k)
3825: FROM msc_department_resources deptres,
3826: msc_resource_requirements resreq
3827: WHERE resreq.sr_instance_id= lv_instance_id(k)
3828: AND resreq.supply_id = lv_transaction_id(k)
3829: AND resreq.organization_id= lv_org_id(k)
3830: AND resreq.plan_id = lv_plan_id(k)
4042: s.sr_instance_id,
4043: resreq.operation_sequence_id, --Outbound Changes for XML
4044: s.disposition_id
4045: FROM msc_trading_partners tp,
4046: msc_resource_requirements resreq,
4047: msc_parameters param,
4048: msc_supplies s
4049: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct? -- ey, correct
4050: AND tp.sr_instance_id= s.sr_instance_id --MN: again, is this correct? -- ey, correct
4178: resreq.parent_seq_num,
4179: resreq.orig_resource_seq_num,
4180: resreq.resource_seq_num
4181: FROM msc_trading_partners tp,
4182: msc_resource_requirements resreq,
4183: msc_parameters param,
4184: msc_supplies s
4185: WHERE tp.sr_tp_id= s.organization_id
4186: AND tp.sr_instance_id= s.sr_instance_id
4588: resreq.orig_resource_seq_num,
4589: resreq.resource_seq_num,
4590: resreq.parent_seq_num
4591: FROM msc_trading_partners tp,
4592: msc_resource_requirements resreq,
4593: msc_parameters param,
4594: msc_supplies s
4595: WHERE tp.sr_tp_id= s.organization_id
4596: AND tp.sr_instance_id=s.sr_instance_id
4683: , s.disposition_id -- for reschedule
4684: , resreq.parent_seq_num
4685: FROM
4686: msc_trading_partners tp,
4687: msc_resource_requirements resreq,
4688: msc_resource_instance_reqs res_instreq,
4689: msc_supplies s
4690: WHERE
4691: tp.sr_tp_id=s.organization_id
4782: , 1 -- jguo
4783: ,resreq.parent_seq_num
4784: FROM
4785: msc_trading_partners tp,
4786: msc_resource_requirements resreq,
4787: msc_resource_instance_reqs res_instreq,
4788: msc_supplies s
4789: WHERE
4790: tp.sr_tp_id=s.organization_id