View: OKS_SUBSCR_HEADER_V

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

View Text

SELECT SCHB.ROWID ROW_ID
, SCHB.ID ID
, SCHT.NAME NAME
, SCHT.DESCRIPTION DESCRIPTION
, SCHB.CLE_ID CLE_ID
, SCHB.DNZ_CHR_ID DNZ_CHR_ID
, SCHB.INSTANCE_ID INSTANCE_ID
, SCHT.SFWT_FLAG SFWT_FLAG
, SCHB.SUBSCRIPTION_TYPE SUBSCRIPTION_TYPE
, SCHB.ITEM_TYPE ITEM_TYPE
, SCHB.MEDIA_TYPE MEDIA_TYPE
, SCHB.STATUS STATUS
, SCHB.FREQUENCY FREQUENCY
, SCHB.FULFILLMENT_CHANNEL FULFILLMENT_CHANNEL
, SCHB.OFFSET OFFSET
, SCHT.COMMENTS COMMENTS
, SCHB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SCHB.CREATED_BY CREATED_BY
, SCHB.CREATION_DATE CREATION_DATE
, SCHB.LAST_UPDATED_BY LAST_UPDATED_BY
, SCHB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SCHB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKS_SUBSCR_HEADER_B SCHB
, OKS_SUBSCR_HEADER_TL SCHT
WHERE SCHB.ID = SCHT.ID
AND SCHT.LANGUAGE = USERENV('LANG')

Columns