View: OKS_SUBSCR_PATTERNS_V

Product:	OKS - Service Contracts
Description:	View for the table subscription patterns
Implementation/DBA Data:	APPS.OKS_SUBSCR_PATTERNS_V

View Text

SELECT SCPS.ROWID ROW_ID
, SCPS.ID ID
, SCPS.OSH_ID OSH_ID
, SCPS.DNZ_CHR_ID DNZ_CHR_ID
, SCPS.DNZ_CLE_ID DNZ_CLE_ID
, SCPS.SEQ_NO SEQ_NO
, SCPS.YEAR YEAR
, SCPS.MONTH MONTH
, SCPS.WEEK WEEK
, SCPS.WEEK_DAY WEEK_DAY
, SCPS.DAY DAY
, SCPS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SCPS.CREATED_BY CREATED_BY
, SCPS.CREATION_DATE CREATION_DATE
, SCPS.LAST_UPDATED_BY LAST_UPDATED_BY
, SCPS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SCPS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKS_SUBSCR_PATTERNS SCPS

Columns