[Home] [Help]
499: lv_wf:= SYS_YES;
500: BEGIN
501: SELECT load_type
502: INTO lv_wf_load_type
503: FROM MSC_SUPPLIES s
504: WHERE s.plan_id = arg_plan_id
505: AND s.transaction_id = arg_transaction_id
506: and s.release_status = 1;
507: EXCEPTION
740: arg_loaded_scheds > 0 OR
741: arg_loaded_reqs > 0 OR
742: arg_resched_reqs > 0 THEN
743:
744: UPDATE MSC_SUPPLIES
745: SET implement_demand_class = NULL,
746: implement_date = NULL,
747: implement_quantity = NULL,
748: implement_firm = NULL,
899: INTO lv_transaction_id,
900: lv_instance_id,
901: lv_org_id,
902: lv_plan_id
903: FROM msc_supplies s,
904: msc_plan_organizations_v orgs,
905: msc_system_items msi,
906: msc_plans mp
907: WHERE mp.plan_id = arg_plan_id
928: s.sr_instance_id,
929:
930: s.organization_id,
931: s.plan_id
932: FROM msc_supplies s,
933: msc_plan_organizations_v orgs
934: WHERE s.release_errors is NULL
935: AND nvl(s.cfm_routing_flag,0) = 3
936: AND s.implement_quantity > 0
1084: nvl(s.requested_completion_date, s.need_by_date)
1085: FROM msc_trading_partners tp,
1086: msc_parameters param,
1087: msc_item_id_lid item_lid,
1088: msc_supplies s
1089: WHERE tp.sr_tp_id= s.organization_id
1090: AND tp.sr_instance_id= s.sr_instance_id
1091: AND tp.partner_type=3
1092: AND param.organization_id = s.organization_id
1151: nwk.from_op_seq_num,
1152: nwk.to_op_seq_num,
1153: 3,
1154: s.sr_instance_id
1155: From msc_supplies s,
1156: msc_operation_networks nwk,
1157: msc_apps_instances ins,
1158: msc_parameters param
1159: Where nwk.plan_id = -1
1209: max(res.END_DATE),
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
1326: res.RESOURCE_HOURS
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,
1413: md.USING_REQUIREMENT_QUANTITY,
1414: md.USING_REQUIREMENT_QUANTITY,
1415: 3,
1416: s.sr_instance_id
1417: From msc_supplies s,
1418: msc_demands md,
1419: msc_system_items icomp,
1420: msc_system_items icomp1,
1421: msc_system_items icomp2,
1505: s.sr_instance_id,
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
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
1606: WHERE
1607: tp.sr_tp_id=s.organization_id
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
1713: WHERE
1714: tp.sr_tp_id=s.organization_id
1793: lv_instance_id,
1794: lv_org_id,
1795: lv_plan_id
1796: FROM msc_plans mp,
1797: msc_supplies s,
1798: msc_plan_organizations_v orgs
1799: WHERE mp.plan_id = arg_plan_id
1800: AND s.release_errors is NULL
1801: AND s.implement_quantity > 0
1943: FROM msc_trading_partners tp,
1944: msc_parameters param,
1945: msc_item_id_lid item_lid,
1946:
1947: msc_supplies s,
1948: msc_plan_organizations_v orgs
1949: WHERE tp.sr_tp_id= s.organization_id
1950: AND tp.sr_instance_id= s.sr_instance_id
1951: AND tp.partner_type=3
2019: decode(nwk.from_op_seq_num, 50000 ,null,nwk.from_op_seq_num),
2020: nwk.to_op_seq_num,
2021: 3,
2022: s.sr_instance_id
2023: From msc_supplies s,
2024: msc_job_operation_networks nwk,
2025: msc_apps_instances ins,
2026: msc_parameters param
2027: Where nwk.plan_id = -1
2080: max(res.END_DATE),
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
2203: ),
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,
2293: md.USING_REQUIREMENT_QUANTITY,
2294: md.USING_REQUIREMENT_QUANTITY,
2295: 3,
2296: s.sr_instance_id
2297: From msc_supplies s,
2298: msc_demands md,
2299: msc_system_items icomp,
2300: msc_system_items icomp1,
2301: msc_system_items icomp2,
2388: s.sr_instance_id,
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
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
2491: WHERE
2492: tp.sr_tp_id=s.organization_id
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
2598: WHERE
2599: tp.sr_tp_id=s.organization_id
2697: lv_instance_id,
2698: lv_org_id,
2699: lv_plan_id,
2700: lv_round_primary_item
2701: FROM msc_supplies s,
2702: msc_plan_organizations_v orgs,
2703: msc_system_items msi, -- REMOVE
2704: msc_plans mp
2705: WHERE mp.plan_id = arg_plan_id
2726: s.sr_instance_id,
2727: s.organization_id,
2728: s.plan_id,
2729: 2 /* setting rounding control to 2 ,since details are not released and this flag is used in details*/
2730: FROM msc_supplies s,
2731: msc_plan_organizations_v orgs
2732: WHERE s.release_errors is NULL
2733: AND s.implement_quantity > 0
2734: AND s.organization_id = orgs.planned_organization
2881: nvl(s.requested_completion_date, s.need_by_date)
2882: FROM msc_trading_partners tp,
2883: msc_parameters param,
2884: msc_item_id_lid item_lid,
2885: msc_supplies s
2886: WHERE tp.sr_tp_id= s.organization_id
2887: AND tp.sr_instance_id= s.sr_instance_id
2888: AND tp.partner_type=3
2889: AND param.organization_id = s.organization_id
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
2979: AND tp.partner_type=3
2980: AND resreq.sr_instance_id= s.sr_instance_id
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
3123: AND tp.sr_instance_id= s.sr_instance_id
3124: AND tp.partner_type=3
3222: FROM msc_trading_partners tp,
3223: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?
3224: msc_demands md,
3225: msc_parameters param,
3226: msc_supplies s
3227: WHERE
3228: tp.sr_tp_id= icomp.organization_id
3229: AND tp.sr_instance_id= icomp.sr_instance_id
3230: AND tp.partner_type=3
3309: s.implement_uom_code, -- bugbug MN: again is this correct?
3310: s.sr_instance_id
3311: FROM msc_trading_partners tp,
3312: msc_item_id_lid icomp,
3313: msc_supplies co,
3314: msc_parameters param,
3315: msc_supplies s
3316: WHERE tp.sr_tp_id = s.organization_id
3317: AND tp.sr_instance_id = s.sr_instance_id
3311: FROM msc_trading_partners tp,
3312: msc_item_id_lid icomp,
3313: msc_supplies co,
3314: msc_parameters param,
3315: msc_supplies s
3316: WHERE tp.sr_tp_id = s.organization_id
3317: AND tp.sr_instance_id = s.sr_instance_id
3318: AND tp.partner_type = 3
3319: AND icomp.inventory_item_id = co.inventory_item_id
3403: msc_component_substitutes bsub,
3404: /* msc_bom_components bcomp, */
3405: msc_item_id_lid icomp,
3406: msc_demands md,
3407: msc_supplies s
3408:
3409: WHERE tp.sr_tp_id= s.organization_id
3410: AND tp.sr_instance_id= s.sr_instance_id
3411: AND tp.partner_type=3
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
3526: AND tp.sr_instance_id= s.sr_instance_id
3527: AND tp.partner_type=3
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
3626: tp.sr_tp_id=s.organization_id
3627: AND tp.sr_instance_id= s.sr_instance_id
3628: AND tp.partner_type=3
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
3731: AND tp.sr_instance_id= s.sr_instance_id
3732: AND tp.partner_type=3
3801: INTO lv_transaction_id,
3802: lv_instance_id,
3803: lv_org_id,
3804: lv_plan_id
3805: FROM msc_supplies s,
3806: msc_plan_organizations_v orgs,
3807: msc_plans mp
3808: WHERE s.release_errors is NULL
3809: AND s.implement_quantity > 0
3970: s.schedule_priority, --dsr
3971: s.requested_completion_date -- dsr
3972: FROM msc_trading_partners tp,
3973: msc_parameters param,
3974: msc_supplies s,
3975: msc_item_id_lid item_lid,
3976: msc_plan_organizations_v orgs,
3977: msc_demands md
3978: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
4110: s.schedule_priority, --dsr
4111: s.requested_completion_date -- dsr
4112: FROM msc_trading_partners tp,
4113: msc_parameters param,
4114: msc_supplies s,
4115: msc_item_id_lid item_lid,
4116: msc_plan_organizations_v orgs
4117: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
4118: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
4247: s.schedule_priority, --dsr
4248: s.requested_completion_date -- dsr
4249: FROM msc_trading_partners tp,
4250: msc_parameters param,
4251: msc_supplies s,
4252: msc_item_id_lid item_lid,
4253: msc_plan_organizations_v orgs
4254: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
4255: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
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
4357: AND tp.partner_type=3
4358: AND resreq.sr_instance_id= s.sr_instance_id
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
4494: AND tp.partner_type=3
4495: AND resreq.sr_instance_id= s.sr_instance_id
4585: s.disposition_id
4586: FROM msc_trading_partners tp,
4587: msc_demands md,
4588: msc_system_items msi,
4589: msc_supplies s
4590: -- bugbug Is this join correct?
4591: WHERE tp.sr_tp_id= msi.organization_id -- ey, should be s.organization_id
4592: AND tp.sr_instance_id= s.sr_instance_id -- ey, s.sr_instance_id
4593: AND tp.partner_type=3
4680: 1,
4681: TO_CHAR(NULL),
4682: s.sr_instance_id,
4683: s.implement_uom_code, -- bugbug MN: again, is this correct?
4684: -- ey, need to default it from uom_code for the item from msc_supplies s
4685: s.disposition_id
4686: FROM msc_trading_partners tp,
4687: msc_supplies co,
4688: msc_parameters param,
4683: s.implement_uom_code, -- bugbug MN: again, is this correct?
4684: -- ey, need to default it from uom_code for the item from msc_supplies s
4685: s.disposition_id
4686: FROM msc_trading_partners tp,
4687: msc_supplies co,
4688: msc_parameters param,
4689: msc_item_id_lid icomp,
4690: msc_supplies s
4691: WHERE tp.sr_tp_id = s.organization_id
4686: FROM msc_trading_partners tp,
4687: msc_supplies co,
4688: msc_parameters param,
4689: msc_item_id_lid icomp,
4690: msc_supplies s
4691: WHERE tp.sr_tp_id = s.organization_id
4692: --MN: again, is this correct? -- ey, correct
4693: AND tp.sr_instance_id = s.sr_instance_id --MN: again, is this correct? -- ey, correct
4694: AND tp.partner_type = 3
4781: msc_component_substitutes bsub,
4782: /* msc_bom_components bcomp, */
4783: msc_item_id_lid icomp,
4784: msc_demands md,
4785: msc_supplies s
4786:
4787: WHERE tp.sr_tp_id= s.organization_id
4788: AND tp.sr_instance_id= s.sr_instance_id
4789: AND tp.partner_type=3
4861: s.implement_uom_code,
4862: s.sr_instance_id
4863: FROM msc_trading_partners tp,
4864: msc_demands md,
4865: msc_supplies s,
4866: msc_system_items icompold,
4867: msc_system_items icompnew
4868: WHERE tp.sr_tp_id= s.organization_id
4869: AND tp.sr_instance_id= s.sr_instance_id
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
4981: AND tp.partner_type=3
4982: AND resreq.sr_instance_id= s.sr_instance_id
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
5076: AND tp.sr_instance_id= s.sr_instance_id
5077: AND tp.partner_type=3
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
5175: AND tp.sr_instance_id= s.sr_instance_id
5176: AND tp.partner_type=3