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

VIEW: HXC.HXC_TIME_BUILDING_BLOCKS#

Object Details
Object Name: HXC_TIME_BUILDING_BLOCKS#
Object Type: VIEW
Owner: HXC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIME_BUILDING_BLOCK_ID NUMBER (15) Yes
TYPE VARCHAR2 (30) Yes
MEASURE NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
START_TIME DATE

STOP_TIME DATE

PARENT_BUILDING_BLOCK_ID NUMBER (15)
PARENT_BUILDING_BLOCK_OVN NUMBER (9)
SCOPE VARCHAR2 (30) Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
APPROVAL_STATUS VARCHAR2 (30) Yes
RESOURCE_ID NUMBER (15)
RESOURCE_TYPE VARCHAR2 (30)
APPROVAL_STYLE_ID NUMBER (15)
DATE_FROM DATE
Yes
DATE_TO DATE
Yes
COMMENT_TEXT VARCHAR2 (2000)
APPLICATION_SET_ID NUMBER (15)
DATA_SET_ID NUMBER (15)
TRANSLATION_DISPLAY_KEY VARCHAR2 (240)
Query Text

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


SELECT TIME_BUILDING_BLOCK_ID
,      TYPE
,      MEASURE
,      UNIT_OF_MEASURE
,      START_TIME
,      STOP_TIME
,      PARENT_BUILDING_BLOCK_ID
,      PARENT_BUILDING_BLOCK_OVN
,      SCOPE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      APPROVAL_STATUS
,      RESOURCE_ID
,      RESOURCE_TYPE
,      APPROVAL_STYLE_ID
,      DATE_FROM
,      DATE_TO
,      COMMENT_TEXT
,      APPLICATION_SET_ID
,      DATA_SET_ID
,      TRANSLATION_DISPLAY_KEY
FROM HXC.HXC_TIME_BUILDING_BLOCKS#;

Dependencies

[top of page]

HXC.HXC_TIME_BUILDING_BLOCKS# references the following:

SchemaHXC
TableHXC_TIME_BUILDING_BLOCKS
HXC.HXC_TIME_BUILDING_BLOCKS# is referenced by following:

SchemaAPPS
SynonymHXC_TIME_BUILDING_BLOCKS
TriggerHXC_TIME_BUILDING_BLOCKS_WHO