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_AUTH_LINES_HV

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
MAJOR_VERSION	NUMBER	(4)	Yes	Tracks the primary version number of a contract.
ID	NUMBER		Yes
LINE_NUMBER	VARCHAR2	(150)	Yes
CHR_ID	NUMBER			Unique Identifier for Contract Header
CLE_ID	NUMBER			Unique Identifier for Contract Line.
CLE_ID_RENEWED	NUMBER
DNZ_CHR_ID	NUMBER		Yes	Unique Identifier for Contract Header, denomalized for efficiency.
DISPLAY_SEQUENCE	NUMBER	(7)	Yes
STS_CODE	VARCHAR2	(30)
TRN_CODE	VARCHAR2	(30)
LSE_ID	NUMBER		Yes
EXCEPTION_YN	VARCHAR2	(3)	Yes
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
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.
HIDDEN_IND	VARCHAR2	(3)
PRICE_NEGOTIATED	NUMBER
PRICE_LEVEL_IND	VARCHAR2	(3)
PRICE_UNIT	NUMBER
PRICE_UNIT_PERCENT	NUMBER	(6)
INVOICE_LINE_LEVEL_IND	VARCHAR2	(3)
DPAS_RATING	VARCHAR2	(24)
TEMPLATE_USED	VARCHAR2	(150)
PRICE_TYPE	VARCHAR2	(30)
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
LAST_UPDATE_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record.
DATE_TERMINATED	DATE
START_DATE	DATE
END_DATE	DATE
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended).
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
CLE_ID_RENEWED_TO	NUMBER
PRICE_NEGOTIATED_RENEWED	NUMBER
CURRENCY_CODE_RENEWED	VARCHAR2	(15)
UPG_ORIG_SYSTEM_REF	VARCHAR2	(60)
UPG_ORIG_SYSTEM_REF_ID	NUMBER
DATE_RENEWED	DATE
ORIG_SYSTEM_SOURCE_CODE	VARCHAR2	(30)
ORIG_SYSTEM_ID1	NUMBER
ORIG_SYSTEM_REFERENCE1	VARCHAR2	(30)
PROGRAM_APPLICATION_ID	NUMBER			With PROGRAM_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_ID	NUMBER			With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_UPDATE_DATE	DATE			Date the concurrent program updated the record.
REQUEST_ID	NUMBER			Unique Identifier of a concurrent request.
PRICE_LIST_ID	NUMBER
PRICE_LIST_LINE_ID	NUMBER
LINE_LIST_PRICE	NUMBER
ITEM_TO_PRICE_YN	VARCHAR2	(3)
PRICING_DATE	DATE
PRICE_BASIS_YN	VARCHAR2	(3)
CONFIG_HEADER_ID	NUMBER
CONFIG_REVISION_NUMBER	NUMBER
CONFIG_COMPLETE_YN	VARCHAR2	(3)
CONFIG_VALID_YN	VARCHAR2	(3)
CONFIG_TOP_MODEL_LINE_ID	NUMBER
CONFIG_ITEM_TYPE	VARCHAR2	(30)
CONFIG_ITEM_ID	NUMBER
SERVICE_ITEM_YN	VARCHAR2	(3)
PH_PRICING_TYPE	VARCHAR2	(30)
PH_PRICE_BREAK_BASIS	VARCHAR2	(30)
PH_MIN_QTY	NUMBER
PH_MIN_AMT	NUMBER
PH_QP_REFERENCE_ID	NUMBER
PH_VALUE	NUMBER
PH_ENFORCE_PRICE_LIST_YN	VARCHAR2	(1)
PH_ADJUSTMENT	NUMBER
PH_INTEGRATED_WITH_QP	VARCHAR2	(1)
CUST_ACCT_ID	NUMBER	(15)
BILL_TO_SITE_USE_ID	NUMBER	(15)
INV_RULE_ID	NUMBER	(15)
LINE_RENEWAL_TYPE_CODE	VARCHAR2	(30)
SHIP_TO_SITE_USE_ID	NUMBER	(15)
PAYMENT_TERM_ID	NUMBER	(15)
LANGUAGE	VARCHAR2	(12)	Yes	Language Primary Key. Standard MLS column.
SOURCE_LANG	VARCHAR2	(12)	Yes
SFWT_FLAG	VARCHAR2	(3)	Yes
NAME	VARCHAR2	(150)
COMMENTS	VARCHAR2	(1995)
ITEM_DESCRIPTION	VARCHAR2	(1995)
BLOCK23TEXT	VARCHAR2	(1995)
OKE_BOE_DESCRIPTION	VARCHAR2	(1995)
COGNOMEN	VARCHAR2	(300)
KLN_ID	NUMBER		Yes
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)
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)
KLN_OBJECT_VERSION_NUMBER	NUMBER		Yes
LOCKED_PRICE_LIST_LINE_ID	NUMBER
BREAK_UOM	VARCHAR2	(3)
PRORATE	VARCHAR2	(5)
INVOICE_TEXT	VARCHAR2	(2000)		Text of the Invoice.
IB_TRX_DETAILS	VARCHAR2	(2000)
STATUS_TEXT	VARCHAR2	(450)
REACT_TIME_NAME	VARCHAR2	(450)
TRXN_EXTENSION_ID	NUMBER
PAYMENT_INSTRUCTION_TYPE	VARCHAR2	(3)
TAX_CLASSIFICATION_CODE	VARCHAR2	(50)
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	(80)
EXEMPT_REASON_CODE	VARCHAR2	(30)
COVERAGE_ID	NUMBER
STANDARD_COV_YN	VARCHAR2	(1)
DATE_CANCELLED	DATE
TERM_CANCEL_SOURCE	VARCHAR2	(30)
ANNUALIZED_FACTOR	NUMBER
CANCELLED_AMOUNT	NUMBER

Query Text

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


SELECT ROW_ID
,      MAJOR_VERSION
,      ID
,      LINE_NUMBER
,      CHR_ID
,      CLE_ID
,      CLE_ID_RENEWED
,      DNZ_CHR_ID
,      DISPLAY_SEQUENCE
,      STS_CODE
,      TRN_CODE
,      LSE_ID
,      EXCEPTION_YN
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      HIDDEN_IND
,      PRICE_NEGOTIATED
,      PRICE_LEVEL_IND
,      PRICE_UNIT
,      PRICE_UNIT_PERCENT
,      INVOICE_LINE_LEVEL_IND
,      DPAS_RATING
,      TEMPLATE_USED
,      PRICE_TYPE
,      CURRENCY_CODE
,      LAST_UPDATE_LOGIN
,      DATE_TERMINATED
,      START_DATE
,      END_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CLE_ID_RENEWED_TO
,      PRICE_NEGOTIATED_RENEWED
,      CURRENCY_CODE_RENEWED
,      UPG_ORIG_SYSTEM_REF
,      UPG_ORIG_SYSTEM_REF_ID
,      DATE_RENEWED
,      ORIG_SYSTEM_SOURCE_CODE
,      ORIG_SYSTEM_ID1
,      ORIG_SYSTEM_REFERENCE1
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PRICE_LIST_ID
,      PRICE_LIST_LINE_ID
,      LINE_LIST_PRICE
,      ITEM_TO_PRICE_YN
,      PRICING_DATE
,      PRICE_BASIS_YN
,      CONFIG_HEADER_ID
,      CONFIG_REVISION_NUMBER
,      CONFIG_COMPLETE_YN
,      CONFIG_VALID_YN
,      CONFIG_TOP_MODEL_LINE_ID
,      CONFIG_ITEM_TYPE
,      CONFIG_ITEM_ID
,      SERVICE_ITEM_YN
,      PH_PRICING_TYPE
,      PH_PRICE_BREAK_BASIS
,      PH_MIN_QTY
,      PH_MIN_AMT
,      PH_QP_REFERENCE_ID
,      PH_VALUE
,      PH_ENFORCE_PRICE_LIST_YN
,      PH_ADJUSTMENT
,      PH_INTEGRATED_WITH_QP
,      CUST_ACCT_ID
,      BILL_TO_SITE_USE_ID
,      INV_RULE_ID
,      LINE_RENEWAL_TYPE_CODE
,      SHIP_TO_SITE_USE_ID
,      PAYMENT_TERM_ID
,      LANGUAGE
,      SOURCE_LANG
,      SFWT_FLAG
,      NAME
,      COMMENTS
,      ITEM_DESCRIPTION
,      BLOCK23TEXT
,      OKE_BOE_DESCRIPTION
,      COGNOMEN
,      KLN_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
,      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
,      KLN_OBJECT_VERSION_NUMBER
,      LOCKED_PRICE_LIST_LINE_ID
,      BREAK_UOM
,      PRORATE
,      INVOICE_TEXT
,      IB_TRX_DETAILS
,      STATUS_TEXT
,      REACT_TIME_NAME
,      TRXN_EXTENSION_ID
,      PAYMENT_INSTRUCTION_TYPE
,      TAX_CLASSIFICATION_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      COVERAGE_ID
,      STANDARD_COV_YN
,      DATE_CANCELLED
,      TERM_CANCEL_SOURCE
,      ANNUALIZED_FACTOR
,      CANCELLED_AMOUNT
FROM APPS.OKS_AUTH_LINES_HV;

Dependencies

[top of page]

APPS.OKS_AUTH_LINES_HV references the following:

APPS: OKC_K_LINES_BH; OKC_K_LINES_TLH; OKS_K_LINES_BH; OKS_K_LINES_TLH

APPS.OKS_AUTH_LINES_HV is not referenced by any database object