DBA Data[Home] [Help]

APPS.PO_CO_TOLERANCES_PVT SQL Statements

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

Line: 116

      SELECT cotl.tolerance_name,
         cotl.maximum_increment,
         cotl.maximum_decrement,
         nvl(cotl.routing_flag, 'N')
      BULK  COLLECT INTO x_tolerances_tbl
      FROM  po_change_order_tolerances_all cotl
      WHERE cotl.org_id = p_organization_id
        AND cotl.change_order_type = p_change_order_type
      ORDER BY cotl.sequence_number;