VIEW: APPS.FND_IREP_CLASSES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID,
  B.CLASS_ID,
  B.CLASS_NAME,
  B.IREP_NAME,
  B.CREATED_BY,
  B.CREATION_DATE,
  B.LAST_UPDATED_BY,
  B.LAST_UPDATE_DATE,
  B.LAST_UPDATE_LOGIN,
  B.SECURITY_GROUP_ID,
  B.CLASS_TYPE,
  B.PRODUCT_CODE,
  B.IMPLEMENTATION_NAME,
  B.DEPLOYED_FLAG,
  B.GENERATED_FLAG,
  B.ACTIVE_FLAG,
  B.COMPATIBILITY_FLAG,
  B.ASSOC_CLASS_ID,
  B.SCOPE_TYPE,
  B.LIFECYCLE_MODE,
  B.SOURCE_FILE_PRODUCT,
  B.SOURCE_FILE_PATH,
  B.SOURCE_FILE_NAME,
  B.SOURCE_FILE_VERSION,
  B.DESCRIPTION,
  B.XML_DESCRIPTION,
  B.STANDARD_TYPE,
  B.STANDARD_VERSION,
  B.STANDARD_SPEC,
  B.LOAD_ERR,
  B.LOAD_ERR_MSGS,
  B.OPEN_INTERFACE_FLAG,
  B.MAP_CODE,
  T.DISPLAY_NAME,
  T.SHORT_DESCRIPTION,
  B.IREP_LDR_PP_FLAG,
  B.IREP_HIDE_SCHEMA,
  B.INTERFACE_CLASS
FROM FND_IREP_CLASSES_TL T,
  FND_IREP_CLASSES B
WHERE B.CLASS_ID = T.CLASS_ID
AND T.LANGUAGE   = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.CLASS_ID
, B.CLASS_NAME
, B.IREP_NAME
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.SECURITY_GROUP_ID
, B.CLASS_TYPE
, B.PRODUCT_CODE
, B.IMPLEMENTATION_NAME
, B.DEPLOYED_FLAG
, B.GENERATED_FLAG
, B.ACTIVE_FLAG
, B.COMPATIBILITY_FLAG
, B.ASSOC_CLASS_ID
, B.SCOPE_TYPE
, B.LIFECYCLE_MODE
, B.SOURCE_FILE_PRODUCT
, B.SOURCE_FILE_PATH
, B.SOURCE_FILE_NAME
, B.SOURCE_FILE_VERSION
, B.DESCRIPTION
, B.XML_DESCRIPTION
, B.STANDARD_TYPE
, B.STANDARD_VERSION
, B.STANDARD_SPEC
, B.LOAD_ERR
, B.LOAD_ERR_MSGS
, B.OPEN_INTERFACE_FLAG
, B.MAP_CODE
, T.DISPLAY_NAME
, T.SHORT_DESCRIPTION
, B.IREP_LDR_PP_FLAG
, B.IREP_HIDE_SCHEMA
, B.INTERFACE_CLASS FROM FND_IREP_CLASSES_TL T
, FND_IREP_CLASSES B WHERE B.CLASS_ID = T.CLASS_ID AND T.LANGUAGE = USERENV('LANG')