[Home] [Help]
View: QA_IN_LISTS_V
Product: | QA - Quality |
Description: | Shows values used in inlist operator |
Implementation/DBA Data: |
APPS.QA_IN_LISTS_V
|
View Text
SELECT QIL.ROWID ROW_ID
, QIL.LIST_ELEM_ID
, QIL.LAST_UPDATE_DATE
, QIL.LAST_UPDATED_BY
, QIL.CREATION_DATE
, QIL.CREATED_BY
, QIL.LAST_UPDATE_LOGIN
, QIL.LIST_ID
, QIL.PARENT_BLOCK_NAME
, QIL.VALUE
, QIL.VALUE_ID
, QIL.CHAR_ID
, QC.NAME CHAR_NAME
, QC.DATATYPE
, QC.DECIMAL_PRECISION
, QC.VALUES_EXIST_FLAG
, DECODE(QC.SQL_VALIDATION_STRING
, NULL
, 'N'
, 'Y') SQL_STRING_FLAG
FROM QA_IN_LISTS QIL
, QA_CHARS QC
WHERE QIL.CHAR_ID = QC.CHAR_ID
Columns
Name |
ROW_ID |
LIST_ELEM_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LIST_ID |
PARENT_BLOCK_NAME |
VALUE |
VALUE_ID |
CHAR_ID |
CHAR_NAME |
DATATYPE |
DECIMAL_PRECISION |
VALUES_EXIST_FLAG |
SQL_STRING_FLAG |