[Home] [Help] [Dependency Information]

TABLE: OKS.OKS_K_HEADERS_BH

Object Details

Object Name:	OKS_K_HEADERS_BH
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_K_HEADERS_BH
Subobject Name:
Status:	VALID

Every time a Service Contract is versioned, header level details of the Contract which were previously maintained in OKS_K_HEADERS_B, is moved to OKS_K_HEADERS_BH. It basically solves the purpose of storing Contract Header History information. A new row is created in this table every time a contract gets versioned & each row in the table is uniquely identified by ID + MAJOR_VERSION. This table gets populated under the following circumstances1) A contract is versioned, through Actions -> Created New Version option in Service Contracts Authoring Form.When versioning occurs, contract header information of current version gets pushed to OKS_K_HEADERS_BH from OKS_K_HEADERS_B & column MAJOR_VERSION gets populated with a version number.Like OKS_K_HEADERS_B, OKS_K_HEADERS_BH is also a child table of OKC_K_HEADERS_BH. There is a 1-1 relationship between the two tables & Columns CHR_ID + MAJOR_VERSION of OKS_K_HEADERS_BH, map to columns ID + MAJOR_VERSION of OKC_K_HEADERS_BH.
Please refer to the base table OKS_K_HEADERS_B for detailed column level information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_K_HEADERS_BH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID MAJOR_VERSION
OKS_K_HEADERS_BH_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHR_ID MAJOR_VERSION

Columns

Query Text

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

SELECT 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
,      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
,      PERIOD_START
,      PERIOD_TYPE
,      PRICE_UOM
,      PERSON_PARTY_ID
,      TAX_CLASSIFICATION_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      APPROVAL_TYPE_USED
,      RENEWAL_COMMENT
,      CC_EMAIL_ADDRESS
FROM OKS.OKS_K_HEADERS_BH;

Dependencies

[top of page]

OKS.OKS_K_HEADERS_BH does not reference any database object

OKS.OKS_K_HEADERS_BH is referenced by following:

OKS

OKS_K_HEADERS_BH#