APPS.GMI_PIR01_XMLP_PKG SQL Statements

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

Line: 88

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

Line: 103

      SELECT
        DECODE(FROM_RANK
              ,NULL
              ,DECODE(TO_RANK
                    ,NULL
                    ,' Range  All '
                    ,' Range From: All   Range To: ' || TO_RANK)
              ,DECODE(TO_RANK
                    ,NULL
                    ,' Range From ' || FROM_RANK || '  Range To All '
                    ,' Range From ' || FROM_RANK || '   Range To ' || TO_RANK))
      INTO RANGEV
      FROM
        DUAL;

Line: 123

      select argument2 into order1  from FND_CONCURRENT_REQUESTS
where request_id =P_CONC_REQUEST_ID;

Line: 133

      SELECT
        MEANING
      INTO ORDER2      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_CODE = '1'
        AND LOOKUP_TYPE = 'PI_ORDER';

Line: 140

      SELECT
        MEANING
      INTO ORDER2
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_CODE = '2'
        AND LOOKUP_TYPE = 'PI_ORDER';

Line: 154

      SELECT
        MEANING
      INTO SORT1
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_CODE = '1'
        AND LOOKUP_TYPE = 'PI_PIR01_SORT';

Line: 162

      SELECT
        MEANING
      INTO SORT1
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_CODE = '2'
        AND LOOKUP_TYPE = 'PI_PIR01_SORT';

Line: 172

  FUNCTION SELECTCFFORMULA RETURN VARCHAR2 IS
    SELECT1 VARCHAR2(17);

Line: 175

    IF SELECT_CRITERIA = '1' THEN
      SELECT
        MEANING
      INTO SELECT1
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_CODE = '1'
        AND LOOKUP_TYPE = 'PI_SELECTCRITERIA';

Line: 183

    ELSIF SELECT_CRITERIA = '2' THEN
      SELECT
        MEANING
      INTO SELECT1
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_CODE = '2'
        AND LOOKUP_TYPE = 'PI_SELECTCRITERIA';

Line: 191

    ELSIF SELECT_CRITERIA = '3' THEN
      SELECT
        MEANING
      INTO SELECT1
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_CODE = '3'
        AND LOOKUP_TYPE = 'PI_SELECTCRITERIA';

Line: 200

    RETURN (SELECT1);

Line: 201

  END SELECTCFFORMULA;