[Home] [Help]
1081: -- Run a test.
1082: s.sr_instance_id,
1083: s.schedule_priority,
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
1596: , 3
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,
1703: , 3
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,
1939:
1940: s.transaction_id, --Outbound Changes for XML
1941: s.schedule_priority,
1942: s.requested_completion_date
1943: FROM msc_trading_partners tp,
1944: msc_parameters param,
1945: msc_item_id_lid item_lid,
1946:
1947: msc_supplies s,
2481: resreq.parent_seq_num,
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,
2588: , 3
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,
2878: NULL,
2879: s.sr_instance_id,
2880: s.schedule_priority,
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
2969: 2,
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
3113: resreq.maximum_assigned_units,
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 ??
3218: TO_CHAR(NULL),
3219: -- bugbug Should we check sys_items for uom_code?
3220: s.implement_uom_code,
3221: s.sr_instance_id
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
3307: 1,
3308: TO_CHAR(NULL),
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
3396: TO_CHAR(NULL),
3397: -- md.operation_seq_id,
3398: s.implement_uom_code, -- bugbug again should fall back to sys_items?
3399: s.sr_instance_id
3400: FROM msc_trading_partners tp,
3401: msc_item_id_lid sr_item,
3402: msc_bom_components subcomp,
3403: msc_component_substitutes bsub,
3404: /* msc_bom_components bcomp, */
3516: decode(nvl(resreq.firm_flag,0),0,2,1),
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
3616: resreq.resource_seq_num,
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
3721: resreq.resource_seq_num,
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
3968: item_lid.sr_inventory_item_id, -- msi.sr_inventory_item_id, -- ey, if you don't flush msc_system_items, you need to somehow pass the source_inventory_item_id to here MN: use msc_iten_id_lid
3969: s.transaction_id, --Outbound Changes for XML
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,
4108: item_lid.sr_inventory_item_id, -- msi.sr_inventory_item_id, -- ey, if you don't flush msc_system_items, you need to somehow pass the source_inventory_item_id to here MN: use msc_iten_id_lid
4109: s.transaction_id, --Outbound Changes for XML
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
4245: item_lid.sr_inventory_item_id, -- msi.sr_inventory_item_id, -- ey, if you don't flush msc_system_items, you need to somehow pass the source_inventory_item_id to here MN: use msc_iten_id_lid
4246: s.transaction_id, --Outbound Changes for XML
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
4347: 1,
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
4484: resreq.maximum_assigned_units,
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
4582: s.sr_instance_id,
4583: -- md.operation_seq_id,
4584: s.implement_uom_code, -- bugbug MN: again, is this correct?
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?
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,
4689: msc_item_id_lid icomp,
4690: msc_supplies s
4774: TO_CHAR(NULL),
4775: -- md.operation_seq_id,
4776: s.implement_uom_code, -- bugbug again should fall back to sys_items?
4777: s.sr_instance_id
4778: FROM msc_trading_partners tp,
4779: msc_item_id_lid sr_item,
4780: msc_bom_components subcomp,
4781: msc_component_substitutes bsub,
4782: /* msc_bom_components bcomp, */
4859: SUBST_CHANGE,
4860: 5,
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
4971: resreq.resource_hours,
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
5066: resreq.resource_seq_num
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
5165: , s.disposition_id -- for reschedule
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