eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OKS_K_HEADERS_HV

Object Details

Object Name:	OKS_K_HEADERS_HV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKS.OKS_K_HEADERS_HV
Subobject Name:
Status:	VALID

Service Contracts Header Attributes History View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
ID	NUMBER		Yes
MAJOR_VERSION	NUMBER		Yes	Tracks the primary version number of a contract.
CHR_ID	NUMBER		Yes	Unique Identifier for Contract Header
ACCT_RULE_ID	NUMBER
PAYMENT_TYPE	VARCHAR2	(30)
CC_NO	VARCHAR2	(80)
CC_EXPIRY_DATE	DATE
CC_BANK_ACCT_ID	NUMBER
CC_AUTH_CODE	VARCHAR2	(150)
COMMITMENT_ID	NUMBER
GRACE_DURATION	NUMBER
GRACE_PERIOD	VARCHAR2	(30)
EST_REV_PERCENT	NUMBER
EST_REV_DATE	DATE
TAX_AMOUNT	NUMBER
TAX_STATUS	VARCHAR2	(30)
TAX_CODE	NUMBER
TAX_EXEMPTION_ID	NUMBER
BILLING_PROFILE_ID	NUMBER
RENEWAL_STATUS	VARCHAR2	(30)
ELECTRONIC_RENEWAL_FLAG	VARCHAR2	(1)
QUOTE_TO_CONTACT_ID	NUMBER
QUOTE_TO_SITE_ID	NUMBER
QUOTE_TO_EMAIL_ID	NUMBER
QUOTE_TO_PHONE_ID	NUMBER
QUOTE_TO_FAX_ID	NUMBER
RENEWAL_PO_REQUIRED	VARCHAR2	(1)
RENEWAL_PO_NUMBER	VARCHAR2	(240)
RENEWAL_PRICE_LIST	NUMBER
RENEWAL_PRICING_TYPE	VARCHAR2	(30)
RENEWAL_MARKUP_PERCENT	NUMBER
RENEWAL_GRACE_DURATION	NUMBER
RENEWAL_GRACE_PERIOD	VARCHAR2	(30)
RENEWAL_EST_REV_PERCENT	NUMBER
RENEWAL_EST_REV_DURATION	NUMBER
RENEWAL_EST_REV_PERIOD	VARCHAR2	(30)
RENEWAL_PRICE_LIST_USED	NUMBER
RENEWAL_TYPE_USED	VARCHAR2	(30)
RENEWAL_NOTIFICATION_TO	NUMBER
RENEWAL_PO_USED	VARCHAR2	(1)
RENEWAL_PRICING_TYPE_USED	VARCHAR2	(30)
RENEWAL_MARKUP_PERCENT_USED	NUMBER
REV_EST_PERCENT_USED	NUMBER
REV_EST_DURATION_USED	NUMBER
REV_EST_PERIOD_USED	VARCHAR2	(30)
BILLING_PROFILE_USED	NUMBER
ERN_FLAG_USED_YN	VARCHAR2	(1)
EVN_THRESHOLD_AMT	NUMBER
EVN_THRESHOLD_CUR	VARCHAR2	(30)
ERN_THRESHOLD_AMT	NUMBER
ERN_THRESHOLD_CUR	VARCHAR2	(30)
RENEWAL_GRACE_DURATION_USED	NUMBER
RENEWAL_GRACE_PERIOD_USED	VARCHAR2	(30)
INV_PRINT_PROFILE	VARCHAR2	(1)
INV_TRX_TYPE	VARCHAR2	(30)
AR_INTERFACE_YN	VARCHAR2	(1)
HOLD_BILLING	VARCHAR2	(1)
SUMMARY_TRX_YN	VARCHAR2	(1)
SERVICE_PO_NUMBER	VARCHAR2	(240)
SERVICE_PO_REQUIRED	VARCHAR2	(1)
BILLING_SCHEDULE_TYPE	VARCHAR2	(10)
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
REQUEST_ID	NUMBER			Unique Identifier of a concurrent request.
CREATED_BY	NUMBER	(15)	Yes	ID of the user whom created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	ID of the last user who updated the record.
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated.
LAST_UPDATE_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record.
PERIOD_TYPE	VARCHAR2	(10)
PERIOD_START	VARCHAR2	(30)
PRICE_UOM	VARCHAR2	(10)
FOLLOW_UP_ACTION	VARCHAR2	(30)
FOLLOW_UP_DATE	DATE
TRXN_EXTENSION_ID	NUMBER
DATE_ACCEPTED	DATE
ACCEPTED_BY	NUMBER
RMNDR_SUPPRESS_FLAG	VARCHAR2	(1)
RMNDR_SENT_FLAG	VARCHAR2	(1)
QUOTE_SENT_FLAG	VARCHAR2	(1)
PROCESS_REQUEST_ID	NUMBER
WF_ITEM_KEY	VARCHAR2	(240)
PERSON_PARTY_ID	NUMBER
TAX_CLASSIFICATION_CODE	VARCHAR2	(50)
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	(80)
EXEMPT_REASON_CODE	VARCHAR2	(30)
APPROVAL_TYPE_USED	VARCHAR2	(30)
RENEWAL_COMMENT	VARCHAR2	(600)
CC_EMAIL_ADDRESS	VARCHAR2	(2000)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ID
,      MAJOR_VERSION
,      CHR_ID
,      ACCT_RULE_ID
,      PAYMENT_TYPE
,      CC_NO
,      CC_EXPIRY_DATE
,      CC_BANK_ACCT_ID
,      CC_AUTH_CODE
,      COMMITMENT_ID
,      GRACE_DURATION
,      GRACE_PERIOD
,      EST_REV_PERCENT
,      EST_REV_DATE
,      TAX_AMOUNT
,      TAX_STATUS
,      TAX_CODE
,      TAX_EXEMPTION_ID
,      BILLING_PROFILE_ID
,      RENEWAL_STATUS
,      ELECTRONIC_RENEWAL_FLAG
,      QUOTE_TO_CONTACT_ID
,      QUOTE_TO_SITE_ID
,      QUOTE_TO_EMAIL_ID
,      QUOTE_TO_PHONE_ID
,      QUOTE_TO_FAX_ID
,      RENEWAL_PO_REQUIRED
,      RENEWAL_PO_NUMBER
,      RENEWAL_PRICE_LIST
,      RENEWAL_PRICING_TYPE
,      RENEWAL_MARKUP_PERCENT
,      RENEWAL_GRACE_DURATION
,      RENEWAL_GRACE_PERIOD
,      RENEWAL_EST_REV_PERCENT
,      RENEWAL_EST_REV_DURATION
,      RENEWAL_EST_REV_PERIOD
,      RENEWAL_PRICE_LIST_USED
,      RENEWAL_TYPE_USED
,      RENEWAL_NOTIFICATION_TO
,      RENEWAL_PO_USED
,      RENEWAL_PRICING_TYPE_USED
,      RENEWAL_MARKUP_PERCENT_USED
,      REV_EST_PERCENT_USED
,      REV_EST_DURATION_USED
,      REV_EST_PERIOD_USED
,      BILLING_PROFILE_USED
,      ERN_FLAG_USED_YN
,      EVN_THRESHOLD_AMT
,      EVN_THRESHOLD_CUR
,      ERN_THRESHOLD_AMT
,      ERN_THRESHOLD_CUR
,      RENEWAL_GRACE_DURATION_USED
,      RENEWAL_GRACE_PERIOD_USED
,      INV_PRINT_PROFILE
,      INV_TRX_TYPE
,      AR_INTERFACE_YN
,      HOLD_BILLING
,      SUMMARY_TRX_YN
,      SERVICE_PO_NUMBER
,      SERVICE_PO_REQUIRED
,      BILLING_SCHEDULE_TYPE
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERIOD_TYPE
,      PERIOD_START
,      PRICE_UOM
,      FOLLOW_UP_ACTION
,      FOLLOW_UP_DATE
,      TRXN_EXTENSION_ID
,      DATE_ACCEPTED
,      ACCEPTED_BY
,      RMNDR_SUPPRESS_FLAG
,      RMNDR_SENT_FLAG
,      QUOTE_SENT_FLAG
,      PROCESS_REQUEST_ID
,      WF_ITEM_KEY
,      PERSON_PARTY_ID
,      TAX_CLASSIFICATION_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      APPROVAL_TYPE_USED
,      RENEWAL_COMMENT
,      CC_EMAIL_ADDRESS
FROM APPS.OKS_K_HEADERS_HV;

Dependencies

[top of page]

APPS.OKS_K_HEADERS_HV references the following:

APPS: OKS_K_HEADERS_BH

APPS.OKS_K_HEADERS_HV is not referenced by any database object