APPS.GMI_RILMS_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      DECODE(FROM_ITEM
            ,NULL
            ,DECODE(TO_ITEM
                  ,NULL
                  ,'Item Range: All'
                  ,' Item Range: All - ' || TO_ITEM)
            ,DECODE(TO_ITEM
                  ,NULL
                  ,'Item Range: ' || FROM_ITEM || ' - All '
                  ,'Item Range: ' || FROM_ITEM || ' - ' || TO_ITEM))
    INTO RANGEV
    FROM
      DUAL;

Line: 26

    SELECT
      USER_NAME
    INTO USERNAME
    FROM
      FND_USER
    WHERE USER_ID = GMI_RILMS_XMLP_PKG.USER_ID;

Line: 38

      SELECT
        'All'
      INTO FROM_ITEMCP
      FROM
        DUAL;

Line: 52

      SELECT
        'All'
      INTO TO_ITEMCP
      FROM
        DUAL;