APPS.OE_DEFAULT_LINE dependencies on MTL_SYSTEM_ITEMS

Line 3005: FROM mtl_system_items msi

3001: -- specified item and serial number combination.
3002:
3003: CURSOR control_codes IS
3004: SELECT decode(msi.lot_control_code,2,'Y','N')
3005: FROM mtl_system_items msi
3006: WHERE msi.inventory_item_id = l_inventory_item_id
3007: AND msi.organization_id =
3008: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3009:

Line 3983: from mtl_system_items

3979:
3980: Begin
3981: select decode(revision_qty_control_code, 2, 'Y', 'N')
3982: into l_revision_controlled
3983: from mtl_system_items
3984: where inventory_item_id = p_x_line_rec.inventory_item_id
3985: and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3986: Exception
3987: When NO_DATA_FOUND Then