APPS.INV_INVDRRSV_XMLP_PKG SQL Statements

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

Line: 261

      RETURN ('/* Do not select from category tables.*/');

Line: 418

        SELECT
          MAX(TRANSACTION_SOURCE_TYPE_NAME)
        INTO NAME
        FROM
          MTL_TXN_SOURCE_TYPES
        WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;

Line: 447

        SELECT
          CATEGORY_SET_NAME
        INTO NAME
        FROM
          MTL_CATEGORY_SETS
        WHERE CATEGORY_SET_ID = SET_ID;