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


VIEW: GR.GR_ITEM_PROPERTIES#

Object Details
Object Name: GR_ITEM_PROPERTIES#
Object Type: VIEW
Owner: GR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_CODE VARCHAR2 (32) Yes
SEQUENCE_NUMBER NUMBER (8) Yes
PROPERTY_ID VARCHAR2 (6) Yes
LABEL_CODE VARCHAR2 (5) Yes
NUMBER_VALUE NUMBER (15)
ALPHA_VALUE VARCHAR2 (240)
DATE_VALUE DATE

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PRINT_TECH_PARM VARCHAR2 (1)
MIGRATION_IND NUMBER (5)
Query Text

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


SELECT ITEM_CODE
,      SEQUENCE_NUMBER
,      PROPERTY_ID
,      LABEL_CODE
,      NUMBER_VALUE
,      ALPHA_VALUE
,      DATE_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PRINT_TECH_PARM
,      MIGRATION_IND
FROM GR.GR_ITEM_PROPERTIES#;

Dependencies

[top of page]

GR.GR_ITEM_PROPERTIES# references the following:

SchemaGR
TableGR_ITEM_PROPERTIES
GR.GR_ITEM_PROPERTIES# is referenced by following:

SchemaAPPS
SynonymGR_ITEM_PROPERTIES