[Home] [Help] [Dependency Information]

TABLE: OKS.OKS_K_LINES_BH

Object Details

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

Every time a Service Contract is versioned, line level details of the Contract which were previously maintained in OKS_K_LINES_B, is moved to OKS_K_LINES_BH. It basically solves the purpose of storing Contract Lines History information.
New rows are 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 circumstance
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_LINES_B, OKS_K_LINES_BH is also a child table of OKC_K_LINES_BH. There is a 1-1 relationship between the two tables & Columns CLE_ID + MAJOR_VERSION of OKS_K_LINES_BH, map to columns ID + MAJOR_VERSION of OKC_K_LINES_BH

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_K_LINES_BH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID MAJOR_VERSION
OKS_K_LINES_BH_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLE_ID MAJOR_VERSION
OKS_K_LINES_BH_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_CHR_ID MAJOR_VERSION

Columns

Query Text

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

SELECT ID
,      MAJOR_VERSION
,      CLE_ID
,      DNZ_CHR_ID
,      DISCOUNT_LIST
,      ACCT_RULE_ID
,      PAYMENT_TYPE
,      CC_NO
,      CC_EXPIRY_DATE
,      CC_BANK_ACCT_ID
,      CC_AUTH_CODE
,      COMMITMENT_ID
,      LOCKED_PRICE_LIST_ID
,      USAGE_EST_YN
,      USAGE_EST_METHOD
,      USAGE_EST_START_DATE
,      TERMN_METHOD
,      UBT_AMOUNT
,      CREDIT_AMOUNT
,      SUPPRESSED_CREDIT
,      OVERRIDE_AMOUNT
,      CUST_PO_NUMBER_REQ_YN
,      CUST_PO_NUMBER
,      GRACE_DURATION
,      GRACE_PERIOD
,      INV_PRINT_FLAG
,      PRICE_UOM
,      TAX_AMOUNT
,      TAX_INCLUSIVE_YN
,      TAX_STATUS
,      TAX_CODE
,      TAX_EXEMPTION_ID
,      IB_TRANS_TYPE
,      IB_TRANS_DATE
,      PROD_PRICE
,      SERVICE_PRICE
,      CLVL_LIST_PRICE
,      CLVL_QUANTITY
,      CLVL_EXTENDED_AMT
,      CLVL_UOM_CODE
,      TOPLVL_OPERAND_CODE
,      TOPLVL_OPERAND_VAL
,      TOPLVL_QUANTITY
,      TOPLVL_UOM_CODE
,      TOPLVL_ADJ_PRICE
,      TOPLVL_PRICE_QTY
,      AVERAGING_INTERVAL
,      SETTLEMENT_INTERVAL
,      MINIMUM_QUANTITY
,      DEFAULT_QUANTITY
,      AMCV_FLAG
,      FIXED_QUANTITY
,      USAGE_DURATION
,      USAGE_PERIOD
,      LEVEL_YN
,      USAGE_TYPE
,      UOM_QUANTIFIED
,      BASE_READING
,      BILLING_SCHEDULE_TYPE
,      FULL_CREDIT
,      LOCKED_PRICE_LIST_LINE_ID
,      BREAK_UOM
,      PRORATE
,      COVERAGE_TYPE
,      EXCEPTION_COV_ID
,      LIMIT_UOM_QUANTIFIED
,      DISCOUNT_AMOUNT
,      DISCOUNT_PERCENT
,      OFFSET_DURATION
,      OFFSET_PERIOD
,      INCIDENT_SEVERITY_ID
,      PDF_ID
,      WORK_THRU_YN
,      REACT_ACTIVE_YN
,      TRANSFER_OPTION
,      PROD_UPGRADE_YN
,      INHERITANCE_TYPE
,      PM_PROGRAM_ID
,      PM_CONF_REQ_YN
,      PM_SCH_EXISTS_YN
,      ALLOW_BT_DISCOUNT
,      APPLY_DEFAULT_TIMEZONE
,      SYNC_DATE_INSTALL
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRXN_EXTENSION_ID
,      TAX_CLASSIFICATION_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      COVERAGE_ID
,      STANDARD_COV_YN
,      REVENUE_IMPACT_DATE
,      COUNTER_VALUE_ID
FROM OKS.OKS_K_LINES_BH;

Dependencies

[top of page]

OKS.OKS_K_LINES_BH does not reference any database object

OKS.OKS_K_LINES_BH is referenced by following:

OKS

OKS_K_LINES_BH#