APPS.INV_INVMVTEX_XMLP_PKG SQL Statements

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

Line: 162

    SELECT
      ZONE_DISPLAY_NAME
    INTO CP_ZONE_DISPLAY_NAME
    FROM
      MTL_ECONOMIC_ZONES_VL
    WHERE ZONE_CODE = P_ECONOMIC_ZONE_CODE;

Line: 192

    SELECT
      MEANING
    INTO CP_USAGE_TYPE_NAME
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'MVT_USAGE_TYPES'
      AND LOOKUP_CODE = P_USAGE_TYPE;

Line: 204

    SELECT
      MEANING
    INTO CP_STAT_TYPE_NAME
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'MVT_STAT_TYPES'
      AND LOOKUP_CODE = P_STAT_TYPE;

Line: 216

    SELECT
      MEANING
    INTO CP_DISPLAY_WARN_FLAG
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = P_DISPLAY_WARN_FLAG;

Line: 229

      SELECT
        MEANING
      INTO CP_SOURCE_DOCUMENT_TYPE
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'MVT_SOURCE_DOCUMENT_TYPES'
        AND LOOKUP_CODE = P_DOCUMENT_SOURCE_TYPE;