[Home] [Help]
View: PAY_FUNCTIONAL_TRIGGERS_V
View Text
SELECT PFT.ROWID ROW_ID
, PFT.TRIGGER_ID
, PFT.AREA_ID
, PFT.EVENT_ID
, PTE.SHORT_NAME
, PTE.DESCRIPTION
, PTE.TABLE_NAME
, PTE.TRIGGERING_ACTION
, PFT.LAST_UPDATE_DATE
, PFT.LAST_UPDATED_BY
, PFT.LAST_UPDATE_LOGIN
, PFT.CREATED_BY
, PFT.CREATION_DATE
FROM PAY_TRIGGER_EVENTS PTE
, PAY_FUNCTIONAL_TRIGGERS PFT
WHERE PTE.EVENT_ID = PFT.EVENT_ID
Columns
| Name |
| ROW_ID |
| TRIGGER_ID |
| AREA_ID |
| EVENT_ID |
| SHORT_NAME |
| DESCRIPTION |
| TABLE_NAME |
| TRIGGERING_ACTION |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| CREATED_BY |
| CREATION_DATE |