APPS.INV_INVIRILC_XMLP_PKG SQL Statements

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

Line: 47

      SELECT
        F.CONVERSION_RATE,
        F.UOM_CLASS,
        T.CONVERSION_RATE,
        T.UOM_CLASS
      INTO FROM_RATE,FROM_CLASS,TO_RATE,TO_CLASS
      FROM
        MTL_UOM_CONVERSIONS F,
        MTL_UOM_CONVERSIONS T
      WHERE F.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
        AND F.UOM_CODE = FROM_CODE
        AND T.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
        AND T.UOM_CODE = TO_CODE;

Line: 73

      SELECT
        DECODE(TO_UOM_CLASS
              ,TO_CLASS
              ,1
              ,2),
        CONVERSION_RATE
      INTO TO_UOM_FLAG,CLASS_RATE
      FROM
        MTL_UOM_CLASS_CONVERSIONS
      WHERE INVENTORY_ITEM_ID = ITEM_ID
        AND TO_UOM_CLASS IN ( FROM_CLASS , TO_CLASS )
        AND FROM_UOM_CLASS IN ( FROM_CLASS , TO_CLASS )
        AND FROM_UOM_CLASS <> TO_UOM_CLASS;

Line: 107

      SELECT
        F.CONVERSION_RATE,
        T.CONVERSION_RATE
      INTO FROM_CLASS_RATE,TO_CLASS_RATE
      FROM
        MTL_UOM_CLASS_CONVERSIONS F,
        MTL_UOM_CLASS_CONVERSIONS T
      WHERE F.INVENTORY_ITEM_ID = ITEM_ID
        AND T.INVENTORY_ITEM_ID = ITEM_ID
        AND F.TO_UOM_CLASS = FROM_CLASS
        AND T.TO_UOM_CLASS = TO_CLASS;

Line: 158

        SELECT
          MEANING
        INTO CONV_RATE_DSPLY
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
          AND LOOKUP_CODE = 1;

Line: 167

        SELECT
          MEANING
        INTO CONV_RATE_DSPLY
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
          AND LOOKUP_CODE = 2;

Line: 176

        SELECT
          MEANING
        INTO CONV_RATE_DSPLY
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
          AND LOOKUP_CODE = 3;

Line: 228

      SELECT
        F.CONVERSION_RATE,
        F.UOM_CLASS,
        T.CONVERSION_RATE,
        T.UOM_CLASS
      INTO FROM_RATE,FROM_CLASS,TO_RATE,TO_CLASS
      FROM
        MTL_UOM_CONVERSIONS F,
        MTL_UOM_CONVERSIONS T
      WHERE F.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
        AND F.UOM_CODE = FROM_CODE
        AND T.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
        AND T.UOM_CODE = TO_CODE;

Line: 254

      SELECT
        DECODE(TO_UOM_CLASS
              ,TO_CLASS
              ,1
              ,2),
        CONVERSION_RATE
      INTO TO_UOM_FLAG,CLASS_RATE
      FROM
        MTL_UOM_CLASS_CONVERSIONS
      WHERE INVENTORY_ITEM_ID = ITEM_ID
        AND TO_UOM_CLASS IN ( FROM_CLASS , TO_CLASS )
        AND FROM_UOM_CLASS IN ( FROM_CLASS , TO_CLASS )
        AND FROM_UOM_CLASS <> TO_UOM_CLASS;

Line: 288

      SELECT
        F.CONVERSION_RATE,
        T.CONVERSION_RATE
      INTO FROM_CLASS_RATE,TO_CLASS_RATE
      FROM
        MTL_UOM_CLASS_CONVERSIONS F,
        MTL_UOM_CLASS_CONVERSIONS T
      WHERE F.INVENTORY_ITEM_ID = ITEM_ID
        AND T.INVENTORY_ITEM_ID = ITEM_ID
        AND F.TO_UOM_CLASS = FROM_CLASS
        AND T.TO_UOM_CLASS = TO_CLASS;

Line: 339

        SELECT
          MEANING
        INTO CONV_RATE_DSPLY
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
          AND LOOKUP_CODE = 1;

Line: 348

        SELECT
          MEANING
        INTO CONV_RATE_DSPLY
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
          AND LOOKUP_CODE = 2;

Line: 357

        SELECT
          MEANING
        INTO CONV_RATE_DSPLY
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
          AND LOOKUP_CODE = 3;

Line: 486

                   ,'Failed flexsql loc select in before report trigger')*/NULL;

Line: 510

                   ,'Failed flexsql item select in before report trigger')*/NULL;

Line: 590

    SELECT
      DECODE(INSTR(L_LOC_TEMP
                  ,L_DELIMITER)
            ,0
            ,L_LOC_TEMP
            ,SUBSTR(L_LOC_TEMP
                  ,1
                  ,INSTR(L_LOC_TEMP
                       ,L_DELIMITER) - 1)),
      DECODE(INSTR(L_LOC_TEMP
                  ,L_DELIMITER)
            ,0
            ,NULL
            ,SUBSTR(L_LOC_TEMP
                  ,INSTR(L_LOC_TEMP
                       ,L_DELIMITER)))
    INTO L_PROJECT_ID,L_LOC_RIGHT_STR
    FROM
      DUAL;

Line: 610

      SELECT
        PROJECT_NUMBER
      INTO L_PROJECT_NUMBER
      FROM
        MTL_PROJECT_V
      WHERE PROJECT_ID = L_PROJECT_ID;

Line: 646

    SELECT
      DECODE(INSTR(L_LOC_TEMP
                  ,L_DELIMITER)
            ,0
            ,L_LOC_TEMP
            ,SUBSTR(L_LOC_TEMP
                  ,1
                  ,INSTR(L_LOC_TEMP
                       ,L_DELIMITER) - 1)),
      DECODE(INSTR(L_LOC_TEMP
                  ,L_DELIMITER)
            ,0
            ,NULL
            ,SUBSTR(L_LOC_TEMP
                  ,INSTR(L_LOC_TEMP
                       ,L_DELIMITER)))
    INTO L_TASK_ID,L_LOC_RIGHT_STR
    FROM
      DUAL;

Line: 666

      SELECT
        TASK_NUMBER
      INTO L_TASK_NUMBER
      FROM
        MTL_TASK_V
      WHERE PROJECT_ID = L_PROJECT_ID
        AND TASK_ID = L_TASK_ID;