1. Tables and Views for Common Features
  2. FND_DIAG_TEST_VL

FND_DIAG_TEST_VL

Details

  • Schema: DIAGNOSTICS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

TEST_ID

TEST_NAME

TEST_TYPE

SENSITIVITY

TEST_METADATA

OBJECT_VERSION_NUMBER

PREREQ_TEST_COUNT

INPUTS_STATUS

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

DISPLAY_NAME

DESCRIPTION

USAGE

MODULE_ID

Query

SQL_Statement

SELECT

B.TEST_ID,

B.TEST_NAME,

B.TEST_TYPE,

B.SENSITIVITY,

B.TEST_METADATA,

B.OBJECT_VERSION_NUMBER,

B.PREREQ_TEST_COUNT,

B.INPUTS_STATUS,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.CREATION_DATE,

T.DISPLAY_NAME,

T.DESCRIPTION,

T.USAGE ,

B.MODULE_ID

FROM

FND_DIAG_TEST B,

FND_DIAG_TEST_TL T

WHERE

B.TEST_ID = T.TEST_ID

AND T.LANGUAGE = USERENV('LANG')