APPS.INV_INVIRITS_XMLP_PKG SQL Statements

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

Line: 56

                       ,'Failed Flexsql MCAT Select in before rpt trig')*/NULL;

Line: 68

                       ,'Failed Flexsql MICG Select in before rpt trig')*/NULL;

Line: 80

                   ,'Failed Flexsql Item Select in before rpt trig')*/NULL;

Line: 105

        SELECT
          CURRENCY_CODE
        INTO P_CURRENCY_CODE1
        FROM
          GL_SETS_OF_BOOKS GSOB,
          ORG_ORGANIZATION_DEFINITIONS OOD
        WHERE GSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
          AND OOD.ORGANIZATION_ID = P_ORG;

Line: 194

        SELECT
          CATEGORY_SET_NAME
        INTO NAME
        FROM
          MTL_CATEGORY_SETS
        WHERE CATEGORY_SET_ID = SET_ID;