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_LINES_HV

Object Details

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

Service Contracts Line 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.
CLE_ID	NUMBER		Yes	Unique Identifier for Contract Line.
DNZ_CHR_ID	NUMBER		Yes	Unique Identifier for Contract Header, denomalized for efficiency.
DISCOUNT_LIST	NUMBER
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
LOCKED_PRICE_LIST_ID	NUMBER
USAGE_EST_YN	VARCHAR2	(1)
USAGE_EST_METHOD	VARCHAR2	(30)
USAGE_EST_START_DATE	DATE
TERMN_METHOD	VARCHAR2	(30)
UBT_AMOUNT	NUMBER
CREDIT_AMOUNT	NUMBER
SUPPRESSED_CREDIT	NUMBER
OVERRIDE_AMOUNT	NUMBER
CUST_PO_NUMBER_REQ_YN	VARCHAR2	(1)
CUST_PO_NUMBER	VARCHAR2	(150)
GRACE_DURATION	NUMBER
GRACE_PERIOD	VARCHAR2	(30)
INV_PRINT_FLAG	VARCHAR2	(1)
PRICE_UOM	VARCHAR2	(30)
TAX_AMOUNT	NUMBER
TAX_INCLUSIVE_YN	VARCHAR2	(1)
TAX_STATUS	VARCHAR2	(30)
TAX_CODE	NUMBER
TAX_EXEMPTION_ID	NUMBER
IB_TRANS_TYPE	VARCHAR2	(10)
IB_TRANS_DATE	DATE
PROD_PRICE	NUMBER
SERVICE_PRICE	NUMBER
CLVL_LIST_PRICE	NUMBER
CLVL_QUANTITY	NUMBER
CLVL_EXTENDED_AMT	NUMBER
CLVL_UOM_CODE	VARCHAR2	(3)
TOPLVL_OPERAND_CODE	VARCHAR2	(30)
TOPLVL_OPERAND_VAL	NUMBER
TOPLVL_QUANTITY	NUMBER
TOPLVL_UOM_CODE	VARCHAR2	(3)
TOPLVL_ADJ_PRICE	NUMBER
TOPLVL_PRICE_QTY	NUMBER
AVERAGING_INTERVAL	NUMBER
SETTLEMENT_INTERVAL	VARCHAR2	(30)
MINIMUM_QUANTITY	NUMBER
DEFAULT_QUANTITY	NUMBER
AMCV_FLAG	VARCHAR2	(1)
FIXED_QUANTITY	NUMBER
USAGE_DURATION	NUMBER
USAGE_PERIOD	VARCHAR2	(3)
LEVEL_YN	VARCHAR2	(1)
USAGE_TYPE	VARCHAR2	(10)
UOM_QUANTIFIED	VARCHAR2	(3)
BASE_READING	NUMBER
BILLING_SCHEDULE_TYPE	VARCHAR2	(10)
FULL_CREDIT	VARCHAR2	(1)
LOCKED_PRICE_LIST_LINE_ID	NUMBER
BREAK_UOM	VARCHAR2	(3)
PRORATE	VARCHAR2	(5)
COVERAGE_TYPE	VARCHAR2	(30)
EXCEPTION_COV_ID	NUMBER
LIMIT_UOM_QUANTIFIED	VARCHAR2	(3)
DISCOUNT_AMOUNT	NUMBER
DISCOUNT_PERCENT	NUMBER
OFFSET_DURATION	NUMBER
OFFSET_PERIOD	VARCHAR2	(3)
INCIDENT_SEVERITY_ID	NUMBER
PDF_ID	NUMBER
WORK_THRU_YN	VARCHAR2	(1)
REACT_ACTIVE_YN	VARCHAR2	(1)
TRANSFER_OPTION	VARCHAR2	(30)
PROD_UPGRADE_YN	VARCHAR2	(1)
INHERITANCE_TYPE	VARCHAR2	(30)
PM_PROGRAM_ID	NUMBER
PM_CONF_REQ_YN	VARCHAR2	(1)
PM_SCH_EXISTS_YN	VARCHAR2	(1)
ALLOW_BT_DISCOUNT	VARCHAR2	(1)
APPLY_DEFAULT_TIMEZONE	VARCHAR2	(1)
SYNC_DATE_INSTALL	VARCHAR2	(1)
SFWT_FLAG	VARCHAR2	(3)	Yes
INVOICE_TEXT	VARCHAR2	(2000)		Text of the Invoice.
IB_TRX_DETAILS	VARCHAR2	(2000)
STATUS_TEXT	VARCHAR2	(450)
REACT_TIME_NAME	VARCHAR2	(450)
COVERAGE_ID	NUMBER
STANDARD_COV_YN	VARCHAR2	(1)
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.
TAX_CLASSIFICATION_CODE	VARCHAR2	(50)
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	(80)
EXEMPT_REASON_CODE	VARCHAR2	(30)
TRXN_EXTENSION_ID	NUMBER
COUNTER_VALUE_ID	NUMBER

Query Text

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


SELECT ROW_ID
,      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
,      SFWT_FLAG
,      INVOICE_TEXT
,      IB_TRX_DETAILS
,      STATUS_TEXT
,      REACT_TIME_NAME
,      COVERAGE_ID
,      STANDARD_COV_YN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TAX_CLASSIFICATION_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      TRXN_EXTENSION_ID
,      COUNTER_VALUE_ID
FROM APPS.OKS_K_LINES_HV;

Dependencies

[top of page]

APPS.OKS_K_LINES_HV references the following:

APPS: OKS_K_LINES_BH; OKS_K_LINES_TLH

APPS.OKS_K_LINES_HV is referenced by following:

APPS: OKS_COV_ACTION_TIMES_HV