View: FV_TRANSACTION_HEADERS_V

View Text

SELECT DISTINCT PSAH.ROWID
, PSAH.TRANSACTION_HEADER_ID
, PSAH.APPLICATION_ID
, A.APPLICATION_NAME
, PSAH.ACTIVITY_NAME
, PSAH.CUST_TRX_TYPE_ID
, T.NAME
, PSAH.USER_ID
, U.USER_NAME
, PSAH.RESPONSIBILITY_ID
, R.RESPONSIBILITY_NAME
, PSAH.SET_OF_BOOKS_ID
, PSAH.LAST_UPDATE_DATE
, PSAH.LAST_UPDATED_BY
, PSAH.CREATION_DATE
, PSAH.CREATED_BY
, PSAH.LAST_UPDATE_LOGIN
FROM FV_TRANSACTION_HEADERS PSAH
, FND_USER U
, FND_RESPONSIBILITY_VL R
, FND_APPLICATION_VL A
, RA_CUST_TRX_TYPES_ALL T
, FV_ETC_ACTIVITIES L
WHERE PSAH.USER_ID = U.USER_ID(+)
AND PSAH.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID(+)
AND PSAH.APPLICATION_ID = A.APPLICATION_ID
AND PSAH.CUST_TRX_TYPE_ID = T.CUST_TRX_TYPE_ID(+)
AND PSAH.ACTIVITY_NAME = L.MEANING
AND L.LOOKUP_TYPE = 'ACTIVITY_NAME'

Columns