FND Design Data [Home] [Help]

View: CS_BUS_PROCESS_TXNS_V

Product: CS - Service
Description: View to show transaction groups
Implementation/DBA Data: ViewAPPS.CS_BUS_PROCESS_TXNS_V
View Text

SELECT BPT.ROWID ROW_ID
, BPT.BUSINESS_PROCESS_ID
, BPT.TRANSACTION_TYPE_ID
, BPT.LAST_UPDATE_DATE
, BPT.LAST_UPDATED_BY
, BPT.CREATION_DATE
, BPT.CREATED_BY
, BPT.LAST_UPDATE_LOGIN
, BPT.START_DATE_ACTIVE
, BPT.END_DATE_ACTIVE
, BPT.ATTRIBUTE1
, BPT.ATTRIBUTE2
, BPT.ATTRIBUTE3
, BPT.ATTRIBUTE4
, BPT.ATTRIBUTE5
, BPT.ATTRIBUTE6
, BPT.ATTRIBUTE7
, BPT.ATTRIBUTE8
, BPT.ATTRIBUTE9
, BPT.ATTRIBUTE10
, BPT.ATTRIBUTE11
, BPT.ATTRIBUTE12
, BPT.ATTRIBUTE13
, BPT.ATTRIBUTE14
, BPT.ATTRIBUTE15
, BPT.CONTEXT
, TT.NAME TRANSACTION_TYPE
FROM CS_BUS_PROCESS_TXNS BPT
, CS_TRANSACTION_TYPES TT
WHERE BPT.TRANSACTION_TYPE_ID = TT.TRANSACTION_TYPE_ID

Columns

Name
ROW_ID
BUSINESS_PROCESS_ID
TRANSACTION_TYPE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
START_DATE_ACTIVE
END_DATE_ACTIVE
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CONTEXT
TRANSACTION_TYPE