APPS.INV_INVARPTP_XMLP_PKG SQL Statements

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

Line: 30

    SELECT
      ID_FLEX_NUM
    INTO P_ITEM_STRUCT
    FROM
      FND_ID_FLEX_STRUCTURES
    WHERE ID_FLEX_CODE = 'MSTK';

Line: 36

    SELECT
      ID_FLEX_NUM
    INTO P_LOC_STRUCT
    FROM
      FND_ID_FLEX_STRUCTURES
    WHERE ID_FLEX_CODE = 'MTLL';

Line: 47

                   ,'Item Flex Select failed before report trigger')*/NULL;

Line: 55

                   ,'Locator Flex Select failed before report trigger')*/NULL;

Line: 242

      SELECT
        LICENSE_PLATE_NUMBER
      INTO L_LPN_NAME
      FROM
        WMS_LICENSE_PLATE_NUMBERS
      WHERE LPN_ID = P_LPN_ID;

Line: 270

        SELECT
          COST_GROUP
        INTO M_COST_GROUP
        FROM
          CST_COST_GROUPS
        WHERE COST_GROUP_ID = COST_GROUP_ID_1;