APPS.INV_INVARPIA_XMLP_PKG SQL Statements

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

Line: 15

      SELECT
        MEANING
      INTO P_REJ_OPT_TITLE
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'SYS_YES_NO'
        AND LOOKUP_CODE = NVL(P_INCLUDE_REJ_ITEMS
         ,1);

Line: 38

                   ,'Failed in before report trigger:MSTK/select')*/NULL;

Line: 54

                   ,'Failed in before report trigger:MCAT/select')*/NULL;

Line: 90

      SELECT
        PHYSICAL_INVENTORY_NAME
      INTO NAME
      FROM
        MTL_PHYSICAL_INVENTORIES
      WHERE ORGANIZATION_ID = P_ORG_ID
        AND PHYSICAL_INVENTORY_ID = P_PHYS_INV_ID;

Line: 110

      SELECT
        CATEGORY_SET_NAME
      INTO NAME
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = P_CATEGORY_SET_ID;