[Home] [Help]
View: FV_EVENTS_TXN_CODE_V
Product: | FV - Federal Financials |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PSAT.ROWID
, PSAT.TRANSACTION_EVENT_ID
, PSAT.USSGL_TRANSACTION_CODE
, T.CHART_OF_ACCOUNTS_ID
, T.DESCRIPTION
, PSAT.LAST_UPDATE_DATE
, PSAT.LAST_UPDATED_BY
, PSAT.CREATION_DATE
, PSAT.CREATED_BY
, PSAT.LAST_UPDATE_LOGIN
FROM FV_EVENTS_TRANSACTION_CODE PSAT
, GL_USSGL_TRANSACTION_CODES T
, FV_TRANSACTION_EVENTS PSAE
WHERE PSAT.USSGL_TRANSACTION_CODE = T.USSGL_TRANSACTION_CODE
AND PSAT.TRANSACTION_EVENT_ID = PSAE.TRANSACTION_EVENT_ID
AND T.CHART_OF_ACCOUNTS_ID = PSAE.CHART_OF_ACCOUNTS_ID
Columns
Name |
ROW_ID |
TRANSACTION_EVENT_ID |
USSGL_TRANSACTION_CODE |
CHART_OF_ACCOUNTS_ID |
DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |