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

VIEW: HR.PQH_RT_MATRIX_NODE_VALUES#

Object Details
Object Name: PQH_RT_MATRIX_NODE_VALUES#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
NODE_VALUE_ID NUMBER (15) Yes
RATE_MATRIX_NODE_ID NUMBER (15) Yes
SHORT_CODE VARCHAR2 (30) Yes
CHAR_VALUE1 VARCHAR2 (240)
CHAR_VALUE2 VARCHAR2 (240)
CHAR_VALUE3 VARCHAR2 (240)
CHAR_VALUE4 VARCHAR2 (240)
NUMBER_VALUE1 NUMBER (15)
NUMBER_VALUE2 NUMBER (15)
NUMBER_VALUE3 NUMBER (15)
NUMBER_VALUE4 NUMBER (15)
DATE_VALUE1 DATE

DATE_VALUE2 DATE

DATE_VALUE3 DATE

DATE_VALUE4 DATE

BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT NODE_VALUE_ID
,      RATE_MATRIX_NODE_ID
,      SHORT_CODE
,      CHAR_VALUE1
,      CHAR_VALUE2
,      CHAR_VALUE3
,      CHAR_VALUE4
,      NUMBER_VALUE1
,      NUMBER_VALUE2
,      NUMBER_VALUE3
,      NUMBER_VALUE4
,      DATE_VALUE1
,      DATE_VALUE2
,      DATE_VALUE3
,      DATE_VALUE4
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ZD_EDITION_NAME
FROM HR.PQH_RT_MATRIX_NODE_VALUES#;

Dependencies

[top of page]

HR.PQH_RT_MATRIX_NODE_VALUES# references the following:

SchemaHR
TablePQH_RT_MATRIX_NODE_VALUES
HR.PQH_RT_MATRIX_NODE_VALUES# is referenced by following:

SchemaAPPS
SynonymPQH_RT_MATRIX_NODE_VALUES
TriggerPQH_RT_MATRIX_NODE_VALUES+
TriggerPQH_RT_MATRIX_NODE_VALUES_WHO