APPS.XDP_OM_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 129

  SELECT NVL( msi.comms_activation_reqd_flag,'N')
    INTO l_activation_flag
    FROM oe_order_lines_all l,
         mtl_system_items_b msi
   WHERE l.line_id = p_line_id
     AND msi.inventory_item_id = l.inventory_item_id
     AND msi.organization_id   = l.ship_from_org_id   ;