[Home] [Help]
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
Name |
ROW_ID |
ID |
OSH_ID |
DNZ_CHR_ID |
DNZ_CLE_ID |
SEQ_NO |
YEAR |
MONTH |
WEEK |
WEEK_DAY |
DAY |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |