FND Design Data [Home] [Help]

View: OKS_LEVEL_ELEMENTS_V

Product: OKS - Service Contracts
Description: This View Is used to Store Billing Schedule Infomation for Lines
Implementation/DBA Data: ViewAPPS.OKS_LEVEL_ELEMENTS_V
View Text

SELECT LET.ROWID ROW_ID
, LET.ID ID
, LET.CLE_ID CLE_ID
, LET.DNZ_CHR_ID DNZ_CHR_ID
, LET.PARENT_CLE_ID PARENT_CLE_ID
, LET.SEQUENCE_NUMBER SEQUENCE_NUMBER
, LET.DATE_START DATE_START
, LET.DATE_END DATE_END
, LET.AMOUNT AMOUNT
, LET.DATE_REVENUE_RULE_START DATE_REVENUE_RULE_START
, LET.DATE_RECEIVABLE_GL DATE_RECEIVABLE_GL
, LET.DATE_TRANSACTION DATE_TRANSACTION
, LET.DATE_DUE DATE_DUE
, LET.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LET.DATE_PRINT DATE_PRINT
, LET.DATE_TO_INTERFACE DATE_TO_INTERFACE
, LET.DATE_COMPLETED DATE_COMPLETED
, LET.RUL_ID RUL_ID
, LET.CREATED_BY CREATED_BY
, LET.CREATION_DATE CREATION_DATE
, LET.LAST_UPDATED_BY LAST_UPDATED_BY
, LET.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM OKS_LEVEL_ELEMENTS LET

Columns

Name
ROW_ID
ID
CLE_ID
DNZ_CHR_ID
PARENT_CLE_ID
SEQUENCE_NUMBER
DATE_START
DATE_END
AMOUNT
DATE_REVENUE_RULE_START
DATE_RECEIVABLE_GL
DATE_TRANSACTION
DATE_DUE
OBJECT_VERSION_NUMBER
DATE_PRINT
DATE_TO_INTERFACE
DATE_COMPLETED
RUL_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE