DBA Data[Home] [Help] [Dependency Information]

VIEW: QA.QA_CHARS#

Object Details
Object Name: QA_CHARS#
Object Type: VIEW
Owner: QA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CHAR_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

NAME VARCHAR2 (30) Yes
CHAR_TYPE_CODE VARCHAR2 (30) Yes
CHAR_CONTEXT_FLAG NUMBER
Yes
PROMPT VARCHAR2 (30)
DATA_ENTRY_HINT VARCHAR2 (240)
DATATYPE NUMBER
Yes
DISPLAY_LENGTH NUMBER

DECIMAL_PRECISION NUMBER

DEFAULT_VALUE VARCHAR2 (2000)
DEFAULT_VALUE_ID NUMBER

MANDATORY_FLAG NUMBER
Yes
UOM_CODE VARCHAR2 (3)
TARGET_VALUE VARCHAR2 (150)
UPPER_SPEC_LIMIT VARCHAR2 (150)
LOWER_SPEC_LIMIT VARCHAR2 (150)
UPPER_REASONABLE_LIMIT VARCHAR2 (150)
LOWER_REASONABLE_LIMIT VARCHAR2 (150)
UPPER_USER_DEFINED_LIMIT VARCHAR2 (150)
LOWER_USER_DEFINED_LIMIT VARCHAR2 (150)
HARDCODED_COLUMN VARCHAR2 (30)
DEVELOPER_NAME VARCHAR2 (30)
SQL_VALIDATION_STRING VARCHAR2 (1500)
ENABLED_FLAG NUMBER
Yes
VALUES_EXIST_FLAG NUMBER
Yes
DEPENDENT_CHAR_ID NUMBER

FK_LOOKUP_TYPE NUMBER

FK_TABLE_NAME VARCHAR2 (30)
FK_TABLE_SHORT_NAME VARCHAR2 (5)
PK_ID VARCHAR2 (30)
FK_ID VARCHAR2 (30)
PK_ID2 VARCHAR2 (30)
FK_ID2 VARCHAR2 (30)
PK_ID3 VARCHAR2 (30)
FK_ID3 VARCHAR2 (30)
FK_MEANING VARCHAR2 (30)
FK_DESCRIPTION VARCHAR2 (30)
FK_ADD_WHERE VARCHAR2 (255)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SEQUENCE_NUMBER NUMBER

SEQUENCE_PREFIX VARCHAR2 (10)
SEQUENCE_SUFFIX VARCHAR2 (10)
SEQUENCE_SEPARATOR VARCHAR2 (1)
SEQUENCE_START NUMBER

SEQUENCE_LENGTH NUMBER

SEQUENCE_INCREMENT NUMBER

SEQUENCE_NEXTVAL NUMBER

SEQUENCE_ZERO_PAD NUMBER

DEPENDENT_ELEMENT VARCHAR2 (1)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CHAR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      CHAR_TYPE_CODE
,      CHAR_CONTEXT_FLAG
,      PROMPT
,      DATA_ENTRY_HINT
,      DATATYPE
,      DISPLAY_LENGTH
,      DECIMAL_PRECISION
,      DEFAULT_VALUE
,      DEFAULT_VALUE_ID
,      MANDATORY_FLAG
,      UOM_CODE
,      TARGET_VALUE
,      UPPER_SPEC_LIMIT
,      LOWER_SPEC_LIMIT
,      UPPER_REASONABLE_LIMIT
,      LOWER_REASONABLE_LIMIT
,      UPPER_USER_DEFINED_LIMIT
,      LOWER_USER_DEFINED_LIMIT
,      HARDCODED_COLUMN
,      DEVELOPER_NAME
,      SQL_VALIDATION_STRING
,      ENABLED_FLAG
,      VALUES_EXIST_FLAG
,      DEPENDENT_CHAR_ID
,      FK_LOOKUP_TYPE
,      FK_TABLE_NAME
,      FK_TABLE_SHORT_NAME
,      PK_ID
,      FK_ID
,      PK_ID2
,      FK_ID2
,      PK_ID3
,      FK_ID3
,      FK_MEANING
,      FK_DESCRIPTION
,      FK_ADD_WHERE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SEQUENCE_NUMBER
,      SEQUENCE_PREFIX
,      SEQUENCE_SUFFIX
,      SEQUENCE_SEPARATOR
,      SEQUENCE_START
,      SEQUENCE_LENGTH
,      SEQUENCE_INCREMENT
,      SEQUENCE_NEXTVAL
,      SEQUENCE_ZERO_PAD
,      DEPENDENT_ELEMENT
,      ZD_EDITION_NAME
FROM QA.QA_CHARS#;

Dependencies

[top of page]

QA.QA_CHARS# references the following:

SchemaQA
TableQA_CHARS
QA.QA_CHARS# is referenced by following:

SchemaAPPS
SynonymQA_CHARS
TriggerQA_CHARS+