APPS.INV_INVARORE_XMLP_PKG SQL Statements

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

Line: 98

          SELECT
            LICENSE_PLATE_NUMBER
          INTO X_PARENT_LPN
          FROM
            WMS_LICENSE_PLATE_NUMBERS
          WHERE LPN_ID = PARENT_LPN_ID;

Line: 121

          SELECT
            LICENSE_PLATE_NUMBER
          INTO X_OUTERMOST_LPN
          FROM
            WMS_LICENSE_PLATE_NUMBERS
          WHERE LPN_ID = OUTERMOST_LPN_ID;

Line: 141

        SELECT
          COST_GROUP
        INTO M_COST_GROUP
        FROM
          CST_COST_GROUPS
        WHERE COST_GROUP_ID = COST_GROUP_ID;