[Home] [Help]
1055: -- Run a test.
1056: s.sr_instance_id,
1057: s.schedule_priority,
1058: nvl(s.requested_completion_date, s.need_by_date)
1059: FROM msc_trading_partners tp,
1060: msc_parameters param,
1061: msc_item_id_lid item_lid,
1062: msc_supplies s
1063: WHERE tp.sr_tp_id= s.organization_id
1570: , 3
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,
1677: , 3
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,
1912:
1913: s.transaction_id, --Outbound Changes for XML
1914: s.schedule_priority,
1915: s.requested_completion_date
1916: FROM msc_trading_partners tp,
1917: msc_parameters param,
1918: msc_item_id_lid item_lid,
1919:
1920: msc_supplies s,
2454: resreq.parent_seq_num,
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,
2561: , 3
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,
2851: NULL,
2852: s.sr_instance_id,
2853: s.schedule_priority,
2854: nvl(s.requested_completion_date, s.need_by_date)
2855: FROM msc_trading_partners tp,
2856: msc_parameters param,
2857: msc_item_id_lid item_lid,
2858: msc_supplies s
2859: WHERE tp.sr_tp_id= s.organization_id
2942: 2,
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
3086: resreq.maximum_assigned_units,
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 ??
3191: TO_CHAR(NULL),
3192: -- bugbug Should we check sys_items for uom_code?
3193: s.implement_uom_code,
3194: s.sr_instance_id
3195: FROM msc_trading_partners tp,
3196: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?
3197: msc_demands md,
3198: msc_parameters param,
3199: msc_supplies s
3280: 1,
3281: TO_CHAR(NULL),
3282: s.implement_uom_code, -- bugbug MN: again is this correct?
3283: s.sr_instance_id
3284: FROM msc_trading_partners tp,
3285: msc_item_id_lid icomp,
3286: msc_supplies co,
3287: msc_parameters param,
3288: msc_supplies s
3369: TO_CHAR(NULL),
3370: -- md.operation_seq_id,
3371: s.implement_uom_code, -- bugbug again should fall back to sys_items?
3372: s.sr_instance_id
3373: FROM msc_trading_partners tp,
3374: msc_item_id_lid sr_item,
3375: msc_bom_components subcomp,
3376: msc_component_substitutes bsub,
3377: /* msc_bom_components bcomp, */
3489: decode(nvl(resreq.firm_flag,0),0,2,1),
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
3589: resreq.resource_seq_num,
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
3694: resreq.resource_seq_num,
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
3940: 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
3941: s.transaction_id, --Outbound Changes for XML
3942: s.schedule_priority, --dsr
3943: s.requested_completion_date -- dsr
3944: FROM msc_trading_partners tp,
3945: msc_parameters param,
3946: msc_supplies s,
3947: msc_item_id_lid item_lid,
3948: msc_plan_organizations_v orgs
4041: 1,
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
4177: resreq.maximum_assigned_units,
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
4277: s.sr_instance_id,
4278: -- md.operation_seq_id,
4279: s.implement_uom_code, -- bugbug MN: again, is this correct?
4280: s.disposition_id
4281: FROM msc_trading_partners tp,
4282: msc_demands md,
4283: msc_parameters param,
4284: msc_system_items msi,
4285: msc_supplies s
4377: s.sr_instance_id,
4378: s.implement_uom_code, -- bugbug MN: again, is this correct?
4379: -- ey, need to default it from uom_code for the item from msc_supplies s
4380: s.disposition_id
4381: FROM msc_trading_partners tp,
4382: msc_supplies co,
4383: msc_parameters param,
4384: msc_item_id_lid icomp,
4385: msc_supplies s
4467: TO_CHAR(NULL),
4468: -- md.operation_seq_id,
4469: s.implement_uom_code, -- bugbug again should fall back to sys_items?
4470: s.sr_instance_id
4471: FROM msc_trading_partners tp,
4472: msc_item_id_lid sr_item,
4473: msc_bom_components subcomp,
4474: msc_component_substitutes bsub,
4475: /* msc_bom_components bcomp, */
4587: resreq.resource_hours,
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
4682: resreq.resource_seq_num
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
4781: , s.disposition_id -- for reschedule
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