DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 3537: AND exists (select null from mtl_system_items mtl where

3533: INTO l_is_model
3534: FROM oe_order_lines l
3535: WHERE top_model_line_id = p_x_line_rec.service_reference_line_id
3536: AND item_type_code = 'INCLUDED'
3537: AND exists (select null from mtl_system_items mtl where
3538: mtl.inventory_item_id = l.inventory_item_id and
3539: mtl.serviceable_product_flag = 'Y' and
3540: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') )
3541: AND ROWNUM = 1;

Line 3610: from mtl_system_items mtl

3606: end if;
3607: BEGIN
3608: select distinct 'Y'
3609: into l_serviceable_item
3610: from mtl_system_items mtl
3611: where mtl.inventory_item_id = p_x_line_rec.inventory_item_id
3612: and mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
3613: and mtl.serviceable_product_flag='Y';
3614: -- lchen added check for organizations to fix bug 2039304