1. Tables and Views for Common Features
  2. FND_DIAG_TEST_PARAM_VL

FND_DIAG_TEST_PARAM_VL

Details

  • Schema: DIAGNOSTICS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

ROW_ID

TEST_ID

PARAM_NAME

IO_FLAG

ACTIVE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

DISPLAY_NAME

DESCRIPTION

Query

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.TEST_ID,

B.PARAM_NAME,

B.IO_FLAG,

B.ACTIVE,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_LOGIN,

T.DISPLAY_NAME,

T.DESCRIPTION

FROM

FND_DIAG_TEST_PARAM_TL T,

FND_DIAG_TEST_PARAM B

WHERE

B.TEST_ID = T.TEST_ID AND B.PARAM_NAME = T.PARAM_NAME AND B.IO_FLAG = T.IO_FLAG AND T.LANGUAGE = USERENV('LANG')