APPS.GML_ORUARPJ_XMLP_PKG SQL Statements

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

Line: 36

    SELECT
      DECODE(P_SORT_1
            ,'5'
            ,3
            ,'1'
            ,4
            ,'3'
            ,5
            ,'2'
            ,6
            ,'4'
            ,8)
    INTO DECODESQL
    FROM
      DUAL;

Line: 52

    SELECT
      DECODE(P_SORT_2
            ,'5'
            ,3
            ,'1'
            ,4
            ,'3'
            ,5
            ,'2'
            ,6
            ,'4'
            ,8)
    INTO DECODESQL
    FROM
      DUAL;

Line: 68

    SELECT
      DECODE(P_SORT_3
            ,'5'
            ,3
            ,'1'
            ,4
            ,'3'
            ,5
            ,'2'
            ,6
            ,'4'
            ,8)
    INTO DECODESQL
    FROM
      DUAL;

Line: 120

        SELECT
          SUM(SUMINV.ONHAND_SHIP_QTY),
          SUM(SUMINV.COMMITTEDSALES_QTY),
          SUM(SUMINV.COMMITTEDPROD_QTY)
        INTO V_SHIP_QTY,V_COMMITTEDSALES_QTY,V_COMMITTEDPROD_QTY
        FROM
          IC_SUMM_INV SUMINV
        WHERE SUMINV.ITEM_ID = ITEM_ID_1
          AND SUMINV.WHSE_CODE = FROM_WHSE;

Line: 130

        SELECT
          SUM(SUMINV.ONHAND_SHIP_QTY),
          SUM(SUMINV.COMMITTEDSALES_QTY),
          SUM(SUMINV.COMMITTEDPROD_QTY)
        INTO V_SHIP_QTY,V_COMMITTEDSALES_QTY,V_COMMITTEDPROD_QTY
        FROM
          IC_SUMM_INV SUMINV
        WHERE SUMINV.ITEM_ID = ITEM_ID_1
          AND SUMINV.WHSE_CODE = FROM_WHSE
          AND SUMINV.QC_GRADE = QC_GRADE_WANTED;

Line: 168

    select decimal_precision into xx
           from gl_curr_mst
           where currency_code = billing_currency ;

Line: 198

      SELECT
        ORGN_NAME
      INTO CP_ORGN_NAME
      FROM
        SY_ORGN_MST
      WHERE ORGN_CODE = P_DEFAULT_ORGN;

Line: 204

      SELECT
        USER_NAME
      INTO CP_USER
      FROM
        FND_USER
      WHERE P_DEFAULT_USER = USER_ID;

Line: 211

        SELECT
          MEANING
        INTO CP_SORT_1
        FROM
          GEM_LOOKUPS
        WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
          AND LOOKUP_CODE = P_SORT_1;

Line: 220

        SELECT
          MEANING
        INTO CP_SORT_2
        FROM
          GEM_LOOKUPS
        WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
          AND LOOKUP_CODE = P_SORT_2;

Line: 229

        SELECT
          MEANING
        INTO CP_SORT_3
        FROM
          GEM_LOOKUPS
        WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
          AND LOOKUP_CODE = P_SORT_3;

Line: 238

        SELECT
          MEANING
        INTO CP_SORT_4
        FROM
          GEM_LOOKUPS
        WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
          AND LOOKUP_CODE = P_SORT_4;

Line: 257

      SELECT
        MEANING
      INTO CP_SORT_1
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_1;

Line: 266

      SELECT
        MEANING
      INTO CP_SORT_2
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_2;

Line: 275

      SELECT
        MEANING
      INTO CP_SORT_3
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_3;

Line: 284

      SELECT
        MEANING
      INTO CP_SORT_4
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_4;