VIEW: APPS.OKS_LEVEL_ELEMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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