APPS.GMI_RILOC_XMLP_PKG SQL Statements

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

Line: 59

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

Line: 72

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

Line: 87

      SELECT
        DECODE(FROM_LOCATION
              ,NULL
              ,DECODE(TO_LOCATION
                    ,NULL
                    ,' Range : All '
                    ,' Range From: All - ' || TO_LOCATION)
              ,DECODE(TO_LOCATION
                    ,NULL
                    ,' Range From: ' || FROM_LOCATION || ' - All '
                    ,' Range From: ' || FROM_LOCATION || ' - ' || TO_LOCATION))
      INTO RANGEV
      FROM
        DUAL;

Line: 108

      SELECT
        'All'
      INTO FROM_LOCATIONCP
      FROM
        DUAL;

Line: 122

      SELECT
        'All'
      INTO TO_LOCATIONCP
      FROM
        DUAL;

Line: 136

      SELECT
        'All'
      INTO FROM_WHSECP
      FROM
        DUAL;

Line: 150

      SELECT
        'All'
      INTO TO_WHSECP
      FROM
        DUAL;