APPS.OE_DEFAULT_LINE dependencies on MTL_SYSTEM_ITEMS

Line 2886: FROM mtl_system_items msi

2882: -- specified item and serial number combination.
2883:
2884: CURSOR control_codes IS
2885: SELECT decode(msi.lot_control_code,2,'Y','N')
2886: FROM mtl_system_items msi
2887: WHERE msi.inventory_item_id = l_inventory_item_id
2888: AND msi.organization_id =
2889: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
2890:

Line 3856: from mtl_system_items

3852:
3853: Begin
3854: select decode(revision_qty_control_code, 2, 'Y', 'N')
3855: into l_revision_controlled
3856: from mtl_system_items
3857: where inventory_item_id = p_x_line_rec.inventory_item_id
3858: and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3859: Exception
3860: When NO_DATA_FOUND Then