APPS.INV_INVARPMT_XMLP_PKG SQL Statements

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

Line: 94

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

Line: 115

        SELECT
          LICENSE_PLATE_NUMBER
        INTO M_OUTERMOST_LPN
        FROM
          WMS_LICENSE_PLATE_NUMBERS
        WHERE LPN_ID = P_OUTERMOST_LPN_ID;

Line: 135

        SELECT
          LICENSE_PLATE_NUMBER
        INTO M_PARENT_LPN
        FROM
          WMS_LICENSE_PLATE_NUMBERS
        WHERE LPN_ID = P_PARENT_LPN_ID;

Line: 155

        SELECT
          COST_GROUP
        INTO M_COST_GROUP
        FROM
          CST_COST_GROUPS
        WHERE COST_GROUP_ID = P_COST_GROUP_ID;