[Home] [Help]
View: PAY_DATETRACKED_EVENTS_V
View Text
SELECT PDE.DATETRACKED_EVENT_ID
, PDE.EVENT_GROUP_ID
, PDE.DATED_TABLE_ID
, HR_GENERAL.DECODE_LOOKUP('UPDATE_TYPE'
, PDE.UPDATE_TYPE) UPDATE_TYPE_MEANING
, PDE.UPDATE_TYPE
, PAY_DYN_TRIGGERS.RETURN_DATED_TABLE_NAME(PDE.DATED_TABLE_ID) TABLE_NAME
, PDE.COLUMN_NAME
, PDE.BUSINESS_GROUP_ID
, PDE.LEGISLATION_CODE
, PDE.OBJECT_VERSION_NUMBER
FROM PAY_DATETRACKED_EVENTS PDE
Columns
Name |
DATETRACKED_EVENT_ID |
EVENT_GROUP_ID |
DATED_TABLE_ID |
UPDATE_TYPE_MEANING |
UPDATE_TYPE |
TABLE_NAME |
COLUMN_NAME |
BUSINESS_GROUP_ID |
LEGISLATION_CODE |
OBJECT_VERSION_NUMBER |