DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 3003: FROM oe_order_lines l,mtl_system_items m

2999:
3000: -- l_component_code VARCHAR2(2000);
3001: CURSOR rma_children IS
3002: SELECT l.header_id, l.line_id, l.ordered_quantity
3003: FROM oe_order_lines l,mtl_system_items m
3004: WHERE l.top_model_line_id = l_top_model_line_id
3005: AND nvl(l.ato_line_id,1) = nvl(l_ato_line_id,nvl(l.ato_line_id,1))
3006: AND l.link_to_line_id = nvl(l_link_to_line_id,l.link_to_line_id)
3007: AND line_id <> l_reference_line_id

Line 3290: FROM mtl_system_items msi

3286: CURSOR control_codes IS
3287: SELECT decode(msi.lot_control_code,2,'Y','N'),
3288: decode(msi.serial_number_control_code,2,'Y',5,'Y',6,'Y','N'),
3289: primary_uom_code
3290: FROM mtl_system_items msi
3291: WHERE msi.inventory_item_id = l_inventory_item_id
3292: AND msi.organization_id =
3293: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3294:

Line 3997: -- AND exists (select null from mtl_system_items mtl where

3993: -- l.ordered_quantity
3994: -- FROM oe_order_lines l
3995: -- WHERE l.top_model_line_id = l_service_reference_line_id
3996: -- AND l.item_type_code in ('INCLUDED','CLASS','OPTION')
3997: -- AND exists (select null from mtl_system_items mtl where
3998: -- mtl.inventory_item_id = l.inventory_item_id and
3999: -- mtl.serviceable_product_flag = 'Y' and
4000: -- mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4001: --lchen added check for organizations to fix bug 2039304

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

4068: l.ordered_quantity
4069: FROM oe_order_lines l
4070: WHERE l.top_model_line_id = l_service_reference_line_id
4071: AND l.item_type_code = 'INCLUDED'
4072: AND exists (select null from mtl_system_items mtl where
4073: mtl.inventory_item_id = l.inventory_item_id and
4074: mtl.serviceable_product_flag = 'Y' and
4075: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4076: ELSE

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

4093: FROM oe_order_lines l
4094: WHERE l.top_model_line_id = l_service_reference_line_id
4095: AND l.top_model_line_id <> l.line_id -- For bug 2938790
4096: AND l.item_type_code in ('INCLUDED','CLASS','OPTION', 'KIT') -- For bug 2447402
4097: AND exists (select null from mtl_system_items mtl where
4098: mtl.inventory_item_id = l.inventory_item_id and
4099: mtl.serviceable_product_flag = 'Y' and
4100: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4101: END IF; /* source_type_doc_id = 2 */