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

VIEW: CZ.CZ_IMP_PROPERTY#

Object Details
Object Name: CZ_IMP_PROPERTY#
Object Type: VIEW
Owner: CZ
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROPERTY_ID NUMBER (9)
PROPERTY_UNIT VARCHAR2 (8)
DESC_TEXT VARCHAR2 (2000)
NAME VARCHAR2 (4000)
DATA_TYPE NUMBER (9)
DEF_VALUE VARCHAR2 (4000)
REC_NBR NUMBER

RUN_ID NUMBER

REC_STATUS VARCHAR2 (4)
DISPOSITION VARCHAR2 (1)
DELETED_FLAG VARCHAR2 (1) Yes
ORIG_SYS_REF VARCHAR2 (255)
EFF_FROM DATE

EFF_TO DATE

EFF_MASK VARCHAR2 (40)
USER_STR01 VARCHAR2 (255)
USER_STR02 VARCHAR2 (255)
USER_STR03 VARCHAR2 (255)
USER_STR04 VARCHAR2 (255)
USER_NUM01 NUMBER (16)
USER_NUM02 NUMBER (16)
USER_NUM03 NUMBER (16)
USER_NUM04 NUMBER (16)
CHECKOUT_USER VARCHAR2 (40)
CREATION_DATE DATE

LAST_UPDATE_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
SECURITY_MASK VARCHAR2 (40)
LAST_UPDATE_LOGIN NUMBER

DEF_NUM_VALUE NUMBER

SRC_APPLICATION_ID NUMBER

Query Text

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


SELECT PROPERTY_ID
,      PROPERTY_UNIT
,      DESC_TEXT
,      NAME
,      DATA_TYPE
,      DEF_VALUE
,      REC_NBR
,      RUN_ID
,      REC_STATUS
,      DISPOSITION
,      DELETED_FLAG
,      ORIG_SYS_REF
,      EFF_FROM
,      EFF_TO
,      EFF_MASK
,      USER_STR01
,      USER_STR02
,      USER_STR03
,      USER_STR04
,      USER_NUM01
,      USER_NUM02
,      USER_NUM03
,      USER_NUM04
,      CHECKOUT_USER
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      LAST_UPDATE_LOGIN
,      DEF_NUM_VALUE
,      SRC_APPLICATION_ID
FROM CZ.CZ_IMP_PROPERTY#;

Dependencies

[top of page]

CZ.CZ_IMP_PROPERTY# references the following:

SchemaCZ
TableCZ_IMP_PROPERTY
CZ.CZ_IMP_PROPERTY# is referenced by following:

SchemaAPPS
SynonymCZ_IMP_PROPERTY