APPS.INV_INVARPTS_XMLP_PKG SQL Statements

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

Line: 43

      SELECT
        PHYSICAL_INVENTORY_NAME
      INTO NAME
      FROM
        MTL_PHYSICAL_INVENTORIES
      WHERE ORGANIZATION_ID = ORG
        AND PHYSICAL_INVENTORY_ID = PI_ID;

Line: 132

      SELECT
        count(*)
      INTO MY_NUM_TAGS
      FROM
        MTL_PHYSICAL_INVENTORY_TAGS
      WHERE ORGANIZATION_ID = MY_ORG_ID
        AND PHYSICAL_INVENTORY_ID = MY_PHYSICAL_INV
        AND SUBINVENTORY = SUBINV
        AND VOID_FLAG = 2;