FND Design Data [Home] [Help]

View: OKS_BILL_TRANSACTIONS_V

Product: OKS - Service Contracts
Description: View for table OKC_CONTRACT_BILLINGS
Implementation/DBA Data: ViewAPPS.OKS_BILL_TRANSACTIONS_V
View Text

SELECT BTNB.ROWID ROW_ID
, BTNB.ID ID
, BTNB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BTNB.TRX_DATE TRX_DATE
, BTNB.TRX_NUMBER TRX_NUMBER
, BTNB.TRX_AMOUNT TRX_AMOUNT
, BTNB.TRX_CLASS TRX_CLASS
, BTNB.CURRENCY_CODE CURRENCY_CODE
, BTNB.CREATED_BY CREATED_BY
, BTNB.CREATION_DATE CREATION_DATE
, BTNB.LAST_UPDATED_BY LAST_UPDATED_BY
, BTNB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BTNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKS_BILL_TRANSACTIONS BTNB

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
TRX_DATE
TRX_NUMBER
TRX_AMOUNT
TRX_CLASS
CURRENCY_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN