[Home] [Help]
3220:
3221: -- l_component_code VARCHAR2(2000);
3222: CURSOR rma_children IS
3223: SELECT l.header_id, l.line_id, l.ordered_quantity
3224: FROM oe_order_lines l,mtl_system_items m
3225: WHERE l.top_model_line_id = l_top_model_line_id
3226: AND nvl(l.ato_line_id,1) = nvl(l_ato_line_id,nvl(l.ato_line_id,1))
3227: AND l.link_to_line_id = nvl(l_link_to_line_id,l.link_to_line_id)
3228: AND line_id <> l_reference_line_id
3519: CURSOR control_codes_org(p_ref_org_id NUMBER) IS
3520: SELECT decode(msi.lot_control_code,2,'Y','N'),
3521: decode(msi.serial_number_control_code,2,'Y',5,'Y',6,'Y','N'),
3522: primary_uom_code
3523: FROM mtl_system_items msi
3524: WHERE msi.inventory_item_id = l_inventory_item_id
3525: AND msi.organization_id = p_ref_org_id;
3526: -- End of 10204440
3527:
3529: CURSOR control_codes IS
3530: SELECT decode(msi.lot_control_code,2,'Y','N'),
3531: decode(msi.serial_number_control_code,2,'Y',5,'Y',6,'Y','N'),
3532: primary_uom_code
3533: FROM mtl_system_items msi
3534: WHERE msi.inventory_item_id = l_inventory_item_id
3535: AND msi.organization_id =
3536: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3537:
4274: -- l.ordered_quantity
4275: -- FROM oe_order_lines l
4276: -- WHERE l.top_model_line_id = l_service_reference_line_id
4277: -- AND l.item_type_code in ('INCLUDED','CLASS','OPTION')
4278: -- AND exists (select null from mtl_system_items mtl where
4279: -- mtl.inventory_item_id = l.inventory_item_id and
4280: -- mtl.serviceable_product_flag = 'Y' and
4281: -- mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4282: --lchen added check for organizations to fix bug 2039304
4387: l.ordered_quantity
4388: FROM oe_order_lines l
4389: WHERE l.top_model_line_id = l_service_reference_line_id
4390: AND l.item_type_code = 'INCLUDED'
4391: AND exists (select null from mtl_system_items mtl where
4392: mtl.inventory_item_id = l.inventory_item_id and
4393: mtl.serviceable_product_flag = 'Y' and
4394: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4395: ELSE
4412: FROM oe_order_lines l
4413: WHERE l.top_model_line_id = l_service_reference_line_id
4414: AND l.top_model_line_id <> l.line_id -- For bug 2938790
4415: AND l.item_type_code in ('INCLUDED','CLASS','OPTION', 'KIT') -- For bug 2447402
4416: AND exists (select null from mtl_system_items mtl where
4417: mtl.inventory_item_id = l.inventory_item_id and
4418: mtl.serviceable_product_flag = 'Y' and
4419: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4420: END IF; /* source_type_doc_id = 2 */