APPS.INV_INVIRSLO_XMLP_PKG SQL Statements

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

Line: 55

      SELECT
        CATEGORY_SET_NAME
      INTO CAT_SET_NAME
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = CAT_SET_ID;

Line: 67

                   ,'No category set selected')*/NULL;

Line: 99

      SELECT
        STRUCTURE_ID
      INTO P_CAT_STRUCT_NUM
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = P_CAT_SET_ID;