[Home] [Help]
| Product: | FV - Federal Financials |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PSAE.ROWID
, PSAE.TRANSACTION_HEADER_ID
, PSAE.TRANSACTION_EVENT_ID
, PSAH.APPLICATION_ID
, PSAH.ACTIVITY_NAME
, PSAH.SET_OF_BOOKS_ID
, PSAE.TRANSACTION_EVENT
, PSAE.TRANSACTION_EVENT_DESC
, PSAE.CHART_OF_ACCOUNTS_ID
, PSAE.CHARGE_ACCOUNT_CCID
, PSAE.RECEIVABLE_ACCOUNT_CCID
, PSAE.REVENUE_ACCOUNT_CCID
, PSAE.DEFAULT_TRANSACTION_CODE
, PSAE.TXN_CODE_REQUIRED
, PSAE.TXN_CODE_UPDATE_ALLOWED
, PSAE.TXN_CODE_LIST_ALLOWED
, PSAE.ASSOC_COLLECTION_TXN_CODE
, PSAE.ASSOC_EXPENDITURE_TXN_CODE
, PSAE.LAST_UPDATE_DATE
, PSAE.LAST_UPDATED_BY
, PSAE.CREATION_DATE
, PSAE.CREATED_BY
, PSAE.LAST_UPDATE_LOGIN
, PSAE.ATTRIBUTE_CATEGORY
, PSAE.ATTRIBUTE1
, PSAE.ATTRIBUTE2
, PSAE.ATTRIBUTE3
, PSAE.ATTRIBUTE4
, PSAE.ATTRIBUTE5
, PSAE.ATTRIBUTE7
, PSAE.ATTRIBUTE8
, PSAE.ATTRIBUTE9
, PSAE.ATTRIBUTE10
, PSAE.ATTRIBUTE6
FROM FV_TRANSACTION_EVENTS PSAE
, FV_TRANSACTION_HEADERS PSAH
WHERE PSAE.TRANSACTION_HEADER_ID = PSAH.TRANSACTION_HEADER_ID