APPS.GMI_RIWHM_XMLP_PKG SQL Statements

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

Line: 30

      SELECT
        DECODE(FROM_WHSE
              ,NULL
              ,DECODE(TO_WHSE
                    ,NULL
                    ,' Range : All '
                    ,' Warehouse Range: All - ' || TO_WHSE)
              ,DECODE(TO_WHSE
                    ,NULL
                    ,' Warehouse Range: ' || FROM_WHSE || ' - All '
                    ,' Warehouse Range: ' || FROM_WHSE || ' - ' || TO_WHSE))
      INTO RANGEV
      FROM
        DUAL;

Line: 45

      SELECT
        DECODE(FROM_DESCRIPTION
              ,NULL
              ,DECODE(TO_DESCRIPTION
                    ,NULL
                    ,' Description Range: All '
                    ,' Description Range: All - ' || TO_DESCRIPTION)
              ,DECODE(TO_DESCRIPTION
                    ,NULL
                    ,' Description Range: ' || FROM_DESCRIPTION || ' - All '
                    ,' Description Range: ' || FROM_DESCRIPTION || ' - ' || TO_DESCRIPTION))
      INTO RANGEV
      FROM
        DUAL;

Line: 60

      SELECT
        DECODE(FROM_REGION
              ,NULL
              ,DECODE(TO_REGION
                    ,NULL
                    ,' Range : All '
                    ,' Region Range: All - ' || TO_REGION)
              ,DECODE(TO_REGION
                    ,NULL
                    ,' Region Range: ' || FROM_REGION || ' - All '
                    ,' Region Range: ' || FROM_REGION || ' - ' || TO_REGION))
      INTO RANGEV
      FROM
        DUAL;

Line: 75

      SELECT
        DECODE(FROM_CLASS
              ,NULL
              ,DECODE(TO_CLASS
                    ,NULL
                    ,' Range : All '
                    ,' class Range: All - ' || TO_CLASS)
              ,DECODE(TO_CLASS
                    ,NULL
                    ,' class Range: ' || FROM_CLASS || ' - All '
                    ,' class Range: ' || FROM_CLASS || ' - ' || TO_CLASS))
      INTO RANGEV
      FROM
        DUAL;

Line: 97

      SELECT
        'Whse'
      INTO SORT1
      FROM
        DUAL;

Line: 103

      SELECT
        'Description'
      INTO SORT1
      FROM
        DUAL;

Line: 109

      SELECT
        'Region'
      INTO SORT1
      FROM
        DUAL;

Line: 115

      SELECT
        'Class'
      INTO SORT1
      FROM
        DUAL;

Line: 157

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

Line: 169

      SELECT
        'All'
      INTO FROM_WHSECP
      FROM
        DUAL;

Line: 183

      SELECT
        'All'
      INTO FROM_DESCRIPTIONCP
      FROM
        DUAL;

Line: 197

      SELECT
        'All'
      INTO TO_WHSECP
      FROM
        DUAL;

Line: 211

      SELECT
        'All'
      INTO TO_DESCRIPTIONCP
      FROM
        DUAL;

Line: 232

      SELECT
        'All'
      INTO FROM_REGIONCP
      FROM
        DUAL;

Line: 246

      SELECT
        'All'
      INTO TO_REGIONCP
      FROM
        DUAL;

Line: 260

      SELECT
        'All'
      INTO FROM_CLASSCP
      FROM
        DUAL;

Line: 274

      SELECT
        'All'
      INTO TO_CLASSCP
      FROM
        DUAL;