VIEW: APPS.OKS_SUBSCR_HEADER_V

Source

View Text - Preformatted

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.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF ,SCHB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID ,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')

View Text - HTML Formatted

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.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, SCHB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, 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')