DBA Data[Home] [Help]

APPS.INV_INVIRDIS_XMLP_PKG SQL Statements

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

Line: 43

                   ,'Failed Flexsql MCAT select in before rpt trig')*/NULL;
Line: 63

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

      RETURN ('/* Do not select mic or mc */');
Line: 141

        SELECT
          CATEGORY_SET_NAME
        INTO NAME
        FROM
          MTL_CATEGORY_SETS
        WHERE CATEGORY_SET_ID = SET_ID;
Line: 174

      SELECT
        CONTROL_LEVEL
      INTO T_STATUS
      FROM
        MTL_ITEM_ATTRIBUTES
      WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
Line: 182

          SELECT
            MASTER_ORGANIZATION_ID
          INTO T_MORG_ID
          FROM
            MTL_PARAMETERS P
          WHERE P.ORGANIZATION_ID = P_ORG_ID;