[Home] [Help]
963: Begin
964: SELECT 2
965: Into lv_agg_details(k)
966: FROM msc_department_resources deptres,
967: msc_resource_requirements resreq
968: WHERE resreq.sr_instance_id= lv_instance_id(k)
969: AND resreq.supply_id = lv_transaction_id(k)
970: AND resreq.organization_id= lv_org_id(k)
971: AND resreq.plan_id = lv_plan_id(k)
1210: 3,
1211: s.sr_instance_id,
1212: max(res.CUMMULATIVE_QUANTITY)
1213: From msc_supplies s,
1214: msc_resource_requirements res,
1215: msc_apps_instances ins,
1216: msc_parameters param
1217: Where res.plan_id = s.plan_id
1218: AND res.sr_instance_id = s.sr_instance_id
1327: ),
1328:
1329: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
1330: From msc_supplies s,
1331: msc_resource_requirements res,
1332: msc_apps_instances ins,
1333: msc_parameters param,
1334: msc_department_resources mdr,
1335: msc_system_items msi
1506: res.orig_resource_seq_num,
1507: res.resource_seq_num,
1508: res.parent_seq_num
1509: From msc_supplies s,
1510: msc_resource_requirements res,
1511: msc_apps_instances ins,
1512: msc_parameters param
1513: Where res.plan_id = s.plan_id
1514: AND res.sr_instance_id = s.sr_instance_id
1597: , resreq.resource_id
1598: , 1
1599: FROM
1600: msc_trading_partners tp,
1601: msc_resource_requirements resreq,
1602: msc_resource_instance_reqs res_instreq,
1603: msc_supplies s,
1604: msc_apps_instances ins,
1605: msc_parameters param
1704: , resreq.resource_id
1705: , 1
1706: FROM
1707: msc_trading_partners tp,
1708: msc_resource_requirements resreq,
1709: msc_resource_instance_reqs res_instreq,
1710: msc_supplies s,
1711: msc_apps_instances ins,
1712: msc_parameters param
1819: Begin
1820: SELECT 2
1821: Into lv_agg_details(k)
1822: FROM msc_department_resources deptres,
1823: msc_resource_requirements resreq
1824: WHERE resreq.sr_instance_id= lv_instance_id(k)
1825: AND resreq.supply_id = lv_transaction_id(k)
1826: AND resreq.organization_id= lv_org_id(k)
1827: AND resreq.plan_id = lv_plan_id(k)
2081: 3,
2082: s.sr_instance_id,
2083: max(res.CUMMULATIVE_QUANTITY)
2084: From msc_supplies s,
2085: msc_resource_requirements res,
2086: msc_apps_instances ins,
2087: msc_parameters param
2088: Where res.plan_id = s.plan_id
2089: AND res.sr_instance_id = s.sr_instance_id
2204: res.RESOURCE_HOURS
2205: ),
2206: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
2207: From msc_supplies s,
2208: msc_resource_requirements res,
2209: msc_apps_instances ins,
2210: msc_parameters param,
2211: msc_department_resources mdr,
2212: msc_system_items msi
2389: res.orig_resource_seq_num,
2390: res.resource_seq_num,
2391: res.parent_seq_num
2392: From msc_supplies s,
2393: msc_resource_requirements res,
2394: msc_apps_instances ins,
2395: msc_parameters param
2396: Where res.plan_id = s.plan_id
2397: AND res.sr_instance_id = s.sr_instance_id
2482: 3,
2483: resreq.resource_id,
2484: 1
2485: FROM msc_trading_partners tp,
2486: msc_resource_requirements resreq,
2487: msc_resource_instance_reqs res_instreq,
2488: msc_supplies s,
2489: msc_apps_instances ins,
2490: msc_parameters param
2589: , resreq.resource_id
2590: , 1
2591: FROM
2592: msc_trading_partners tp,
2593: msc_resource_requirements resreq,
2594: msc_resource_instance_reqs res_instreq,
2595: msc_supplies s,
2596: msc_apps_instances ins,
2597: msc_parameters param
2759: Begin
2760: SELECT 2
2761: Into lv_agg_details(k)
2762: FROM msc_department_resources deptres,
2763: msc_resource_requirements resreq
2764: WHERE resreq.sr_instance_id= lv_instance_id(k)
2765: AND resreq.supply_id = lv_transaction_id(k)
2766: AND resreq.organization_id= lv_org_id(k)
2767: AND resreq.plan_id = lv_plan_id(k)
2970: 1,
2971: resreq.operation_sequence_id, --Outbound changes for XML
2972: s.sr_instance_id
2973: FROM msc_trading_partners tp,
2974: msc_resource_requirements resreq,
2975: msc_parameters param,
2976: msc_supplies s
2977: WHERE tp.sr_tp_id= s.organization_id
2978: AND tp.sr_instance_id= s.sr_instance_id
3114: resreq.parent_seq_num,
3115: resreq.orig_resource_seq_num,
3116: resreq.resource_seq_num
3117: FROM msc_trading_partners tp,
3118: msc_resource_requirements resreq,
3119: msc_parameters param,
3120: msc_supplies s,
3121: msc_department_resources mdr --MN: "C" type , can we just say mdr.plan_id = -1 ??
3122: WHERE tp.sr_tp_id= s.organization_id
3517: resreq.department_id,
3518: resreq.resource_hours,
3519: resreq.parent_seq_num
3520: FROM msc_trading_partners tp,
3521: msc_resource_requirements resreq,
3522: msc_parameters param,
3523: msc_supplies s,
3524: msc_department_resources mdr
3525: WHERE tp.sr_tp_id= s.organization_id
3617: 1 ,
3618: resreq.parent_seq_num
3619: FROM
3620: msc_trading_partners tp,
3621: msc_resource_requirements resreq,
3622: msc_resource_instance_reqs res_instreq,
3623: msc_dept_res_instances dep_res_inst,
3624: msc_supplies s
3625: WHERE
3722: 1 ,
3723: resreq.parent_seq_num
3724: FROM
3725: msc_trading_partners tp,
3726: msc_resource_requirements resreq,
3727: msc_resource_instance_reqs res_instreq,
3728: msc_supplies s
3729: WHERE
3730: tp.sr_tp_id=s.organization_id
3849: Begin
3850: SELECT 2
3851: Into lv_agg_details(k)
3852: FROM msc_department_resources deptres,
3853: msc_resource_requirements resreq
3854: WHERE resreq.sr_instance_id= lv_instance_id(k)
3855: AND resreq.supply_id = lv_transaction_id(k)
3856: AND resreq.organization_id= lv_org_id(k)
3857: AND resreq.plan_id = lv_plan_id(k)
4348: s.sr_instance_id,
4349: resreq.operation_sequence_id, --Outbound Changes for XML
4350: s.disposition_id
4351: FROM msc_trading_partners tp,
4352: msc_resource_requirements resreq,
4353: msc_parameters param,
4354: msc_supplies s
4355: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct? -- ey, correct
4356: AND tp.sr_instance_id= s.sr_instance_id --MN: again, is this correct? -- ey, correct
4485: resreq.parent_seq_num,
4486: resreq.orig_resource_seq_num,
4487: resreq.resource_seq_num
4488: FROM msc_trading_partners tp,
4489: msc_resource_requirements resreq,
4490: msc_parameters param,
4491: msc_supplies s
4492: WHERE tp.sr_tp_id= s.organization_id
4493: AND tp.sr_instance_id= s.sr_instance_id
4972: resreq.orig_resource_seq_num,
4973: resreq.resource_seq_num,
4974: resreq.parent_seq_num
4975: FROM msc_trading_partners tp,
4976: msc_resource_requirements resreq,
4977: msc_parameters param,
4978: msc_supplies s
4979: WHERE tp.sr_tp_id= s.organization_id
4980: AND tp.sr_instance_id=s.sr_instance_id
5067: , s.disposition_id -- for reschedule
5068: , resreq.parent_seq_num
5069: FROM
5070: msc_trading_partners tp,
5071: msc_resource_requirements resreq,
5072: msc_resource_instance_reqs res_instreq,
5073: msc_supplies s
5074: WHERE
5075: tp.sr_tp_id=s.organization_id
5166: , 1 -- jguo
5167: ,resreq.parent_seq_num
5168: FROM
5169: msc_trading_partners tp,
5170: msc_resource_requirements resreq,
5171: msc_resource_instance_reqs res_instreq,
5172: msc_supplies s
5173: WHERE
5174: tp.sr_tp_id=s.organization_id