[Home] [Help]
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,
1422: msc_apps_instances ins,
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,
2302: msc_apps_instances ins,
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
3227: WHERE
3228: tp.sr_tp_id= icomp.organization_id
3402: msc_bom_components subcomp,
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
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
3979: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
3980: AND item_lid.inventory_item_id = s.inventory_item_id
3981: AND tp.sr_instance_id= s.sr_instance_id --MN: again, is this correct ? -- ey, should be s.sr_instance_id -- MN:done
4137: AND s.sr_instance_id= lv_instance_id(j)
4138: AND s.release_status = 1
4139: AND s.order_type = 70
4140: AND s.maintenance_object_source = 2
4141: AND not exists (select * from msc_demands md where md.plan_id= s.plan_id AND md.sr_instance_Id= s.sr_instance_Id AND md.disposition_id= s.transaction_id
4142: AND md.organization_id= s.organization_id
4143: AND md.primary_component_id <> md.inventory_item_id) ;
4144:
4145: IF SQL%ROWCOUNT > 0
4557: s.organization_id,
4558: decode(s.order_type,70,arg_wip_group_id*-1,arg_wip_group_id),--for cmro --arg_wip_group_id,
4559: s.transaction_id,
4560: nvl(md.op_seq_num,1),
4561: msi.sr_inventory_item_id, -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands
4562: decode(l_apps_ver,'3',null,msi.sr_inventory_item_id),
4563: -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands
4564: decode(md.component_scaling_type,1,NULL,md.component_scaling_type),
4565: TO_NUMBER(NULL), --decode(l_apps_ver,'4',TO_NUMBER(NULL),'3',TO_NUMBER(NULL),(md.USING_REQUIREMENT_QUANTITY/s.implement_quantity)),
4559: s.transaction_id,
4560: nvl(md.op_seq_num,1),
4561: msi.sr_inventory_item_id, -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands
4562: decode(l_apps_ver,'3',null,msi.sr_inventory_item_id),
4563: -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands
4564: decode(md.component_scaling_type,1,NULL,md.component_scaling_type),
4565: TO_NUMBER(NULL), --decode(l_apps_ver,'4',TO_NUMBER(NULL),'3',TO_NUMBER(NULL),(md.USING_REQUIREMENT_QUANTITY/s.implement_quantity)),
4566: TO_NUMBER(NULL), --md.component_yield_factor, -- bugbug is this correct?
4567: TO_NUMBER(NULL), --Department_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?
4591: WHERE tp.sr_tp_id= msi.organization_id -- ey, should be s.organization_id
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
4594: AND s.inventory_item_id= md.using_assembly_item_id
4595: --MN: again, is this correct? -- /* ey, no, this link should be removed, the original link is to find the source item_id for the item in msc_demands */
4596: AND s.organization_id= md.organization_id --MN: again, is this correct? -- ey, no, this link should be
4597: AND s.sr_instance_id= md.sr_instance_id --MN: again, is this correct? -- ey, no, this link should be
4598: AND nvl(md.wip_supply_type,0) <> 6 -- ey, you need to find the wip_supply_type for the item_id in msc_demands
4599: AND (md.PRIMARY_COMPONENT_ID is null or md.PRIMARY_COMPONENT_ID = md.inventory_item_id)
4594: AND s.inventory_item_id= md.using_assembly_item_id
4595: --MN: again, is this correct? -- /* ey, no, this link should be removed, the original link is to find the source item_id for the item in msc_demands */
4596: AND s.organization_id= md.organization_id --MN: again, is this correct? -- ey, no, this link should be
4597: AND s.sr_instance_id= md.sr_instance_id --MN: again, is this correct? -- ey, no, this link should be
4598: AND nvl(md.wip_supply_type,0) <> 6 -- ey, you need to find the wip_supply_type for the item_id in msc_demands
4599: AND (md.PRIMARY_COMPONENT_ID is null or md.PRIMARY_COMPONENT_ID = md.inventory_item_id)
4600: AND md.origination_type = 3
4601: AND md.sr_instance_id= s.sr_instance_id
4602: AND md.disposition_id= s.transaction_id
4780: msc_bom_components subcomp,
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
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
4868: WHERE tp.sr_tp_id= s.organization_id