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]

TABLE: OKC.OKC_K_LINES_B

Object Details

Object Name:	OKC_K_LINES_B
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_K_LINES_B
Subobject Name:
Status:	VALID

A CONTRACT LINE is a supertype of CLIN (contract line item number), SUBCLIN and LINE DETAIL which group a set of deliverable ITEMS into a logical set usually defined by unitary price, delivery or some other classification. It also provides an association point for any specific RULES governing the performance of that particular delivery.
LINES are hierarchical. A LINE may have children and may belong to one parent line. The topmost line (called the top line) has no LINE as its parent, but belongs to the CONTRACT HEADER.
A RULE or PARTY association for a LINE flows down to all child lines until overridden.
Each CONTRACT LINE must be of a specified LINE STYLE. This controls from where the LINE may source its data and what types of lines it may have as its children. Different SUBCLASSES of contracts may have different LINE STYLE hierarchies.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_K_LINES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKC_K_LINES_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHR_ID
OKC_K_LINES_B_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_TO_SITE_USE_ID
OKC_K_LINES_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_CHR_ID CLE_ID
OKC_K_LINES_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLE_ID
OKC_K_LINES_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE
OKC_K_LINES_B_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE
OKC_K_LINES_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_TO_SITE_USE_ID
OKC_K_LINES_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCT_ID
OKC_K_LINES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATE_TERMINATED

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	System generated unique identifier. Primary key column of the table.
LINE_NUMBER	VARCHAR2	(150)	Yes	Sequencial line number.
CHR_ID	NUMBER			ID of the contract to which this line belongs. The field will have a value only for parent lines. Refers to ID in OKC_K_HEADERS_B.
CLE_ID	NUMBER			ID of the parent Line. A line can have sub-lines. Refers to ID in OKC_K_LINES_B.
CLE_ID_RENEWED	NUMBER			ID of the parent line from which this line was renewed. This field is kept for backward compatibility and will be removed in future releases. Refers to ID in OKC_K_LINES_B.
DNZ_CHR_ID	NUMBER		Yes	Contract ID. Denormalized for performance.
DISPLAY_SEQUENCE	NUMBER	(7)	Yes	Order of line within parent.
STS_CODE	VARCHAR2	(30)	Yes	Unique identifier of status code. Refers to status OKC_STATUSES_B.
TRN_CODE	VARCHAR2	(30)		Line Termination Code. Refers to LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE IS OKC_TERMINATION_REASON
LSE_ID	NUMBER		Yes	Unique identifier of line style. Refers to ID in OKC_LINE_STYLES_B.
EXCEPTION_YN	VARCHAR2	(3)	Yes	It indicates the lines that are de-selected from a set of lines comming under the same parent.
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	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
HIDDEN_IND	VARCHAR2	(3)		Indicates whether the line is visible on the contract or hidden and only visible in the contract management system.
PRICE_NEGOTIATED	NUMBER			The calculated or manually adjusted rollup extended price all sublines.
PRICE_LEVEL_IND	VARCHAR2	(3)		Field Indicating whether extended value is to be calculated and displayed at this level. Valid values Y and N.
PRICE_UNIT	NUMBER			Price per unit.
PRICE_UNIT_PERCENT	NUMBER	(6)		Price unit percent.
INVOICE_LINE_LEVEL_IND	VARCHAR2	(3)		Indicates if a single invoice line is to be generated at this level for all sublines. Valid values Y and N.
DPAS_RATING	VARCHAR2	(24)		DPAS ( Defense Priorities and Allocations System) rating. Indicates standard followed for government contracts.
TEMPLATE_USED	VARCHAR2	(150)		Name of template used.
PRICE_TYPE	VARCHAR2	(30)		Contract price type.
CURRENCY_CODE	VARCHAR2	(15)		Currency code as defined in FND_CURRENCIES.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
DATE_TERMINATED	DATE			Date contract was terminated.
START_DATE	DATE			The beginning of the active period, one second after midnight on the date indicated.
END_DATE	DATE			The end of the active period, one second before midnight on the date indicated.
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Descriptive flexfield category column.
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield column.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
CLE_ID_RENEWED_TO	NUMBER			The line to which this line was renewed. Only present in renewed lines. This attribuite is kept for backward compatibility and will be removed from the future releases. Refers to ID in OKC_K_LINES_B
PRICE_NEGOTIATED_RENEWED	NUMBER			The negotiated amount of the line for which this line is the renewal. Only present in renewal lines.
CURRENCY_CODE_RENEWED	VARCHAR2	(15)		Currency code as defined in FND_CURRENCIES. This represents the currency in which the renewed-from line is priced. Only present in renewal lines.
UPG_ORIG_SYSTEM_REF	VARCHAR2	(60)		Identifies original source of data
UPG_ORIG_SYSTEM_REF_ID	NUMBER			Unique Id from original system
DATE_RENEWED	DATE			Date on which the line was Renewed or Renew Consolidated.
ORIG_SYSTEM_SOURCE_CODE	VARCHAR2	(30)		Identifier of the source system
ORIG_SYSTEM_ID1	NUMBER			Unique identifier in the source system
ORIG_SYSTEM_REFERENCE1	VARCHAR2	(30)		Unique identifier in the source system
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
REQUEST_ID	NUMBER			Standard Who Column
PRICE_LIST_ID	NUMBER			Identifier of the Price List used for pricing this Contract. Quickcodes : LIST_HEADER_ID from QP_LIST_HEADERS_B
PRICE_LIST_LINE_ID	NUMBER			Identifier of the Price List used for pricing this Contract Line.
LINE_LIST_PRICE	NUMBER			List price of the items on this Contract line
ITEM_TO_PRICE_YN	VARCHAR2	(3)		Indicates whether the line contains the item being priced. This is derived from the linestyle. Valid values Y and N.
PRICING_DATE	DATE			Effective date used for pricing this Contract
PRICE_BASIS_YN	VARCHAR2	(3)		Indicates whether this line is the basis for the price of another line in this Contract. This is derived from the linestyle
CONFIG_HEADER_ID	NUMBER			Identifier of the configuration for a model item. Used when an item and its components are configured using Oracle Configurator. For example, a PC can be built using different configurations of memory and disk space
CONFIG_REVISION_NUMBER	NUMBER			Revision number of the configuration used in this Contract line
CONFIG_COMPLETE_YN	VARCHAR2	(3)		Indicates whether the configuration is complete for this model item. This is validated by Oracle Configurator. This is populated only on the model item line
CONFIG_VALID_YN	VARCHAR2	(3)		Indicates whether the configuration is valid for this model item. This is validated by Oracle Configurator. This is populated only on the model item line
CONFIG_TOP_MODEL_LINE_ID	NUMBER			Identifier of the Contract line that contains the base model configured item. This is populated for all child components of the model item and is used as a parameter to price the component
CONFIG_ITEM_TYPE	VARCHAR2	(30)		Indicates that this Contract line contains the configured top model item or top base item or a config option item. Quickcodes : 'TOP MODEL LINE', 'TOP BASE LINE', 'CONFIG'
CONFIG_ITEM_ID	NUMBER			Foreign Key to Configured Item in the Configurator (CZ) table. In case of Configured Lines creation, this column will not have a value for the top model line.
SERVICE_ITEM_YN	VARCHAR2	(3)		Indicates whether the item is serviceable or not.
PH_PRICING_TYPE	VARCHAR2	(30)		Foreign key to FND_LOOKUP_TYPES.LOOKUP_TYPE where lookup_type = 'OKC_PH_LINE_PRICE_TYPE'. Possible values will be DISCOUNT_PERCENT, NEW_PRICE, DISCOUNT_AMOUNT, PRICE_BREAK. - Not Used
PH_PRICE_BREAK_BASIS	VARCHAR2	(30)		Foreign key to FND_LOOKUP_TYPES.LOOKUP_TYPE where lookup_type = 'OKC_PH_PRICE_BREAK_BASIS'. Basis of price break. Price break can be based on quantity or the amount of order. Possible values could be ITEM_QUANTITY and ITEM_AMOUNT. - Not Used
PH_MIN_QTY	NUMBER			Purchase minimum quantity to be applied on the price hold - Not Used
PH_MIN_AMT	NUMBER			Purchase minimum amount to be applied on the price hold - Not Used
PH_QP_REFERENCE_ID	NUMBER			Foreign key to QP_LIST_LINES.LIST_LINE_ID or QP_LIST_HEADERS_B.LIST_HEADER_ID. This is a reference to the modifier header/line id created in QP. - Not Used
PH_VALUE	NUMBER			Price Hold value. - Not Used
PH_ENFORCE_PRICE_LIST_YN	VARCHAR2	(1)		Yes-No column to indicate that customers will only get the negotiated amount if they make a purchase against a particular price list - Not Used
PH_ADJUSTMENT	NUMBER			Estimated Percentage Adjustment.
PH_INTEGRATED_WITH_QP	VARCHAR2	(1)		Yes-No field to indicate whether it is integrated with QP - Not Used
CUST_ACCT_ID	NUMBER	(15)		Customer account . Not used.
BILL_TO_SITE_USE_ID	NUMBER	(15)		Stores account site use identifier. This column is used to identify the billing address of the customer account. References HZ_CUST_ACCT_SITES_ALL.SITE_USE_ID where SITE_USE_CODE='BILL_TO'.
INV_RULE_ID	NUMBER	(15)		Stores invoicing rule identifier. This column is used to bill invoices in Advance or Arrears. References RA_RULES.RULE_ID where TYPE='I'
LINE_RENEWAL_TYPE_CODE	VARCHAR2	(30)		Unique identifier of Contract line renewal type. Refers to lookup_code from fnd_lookups where lookup_type = OKC_LINE_RENEWAL_TYPE.
SHIP_TO_SITE_USE_ID	NUMBER	(15)		Stores account site use identifier. This column is used to identify the shipping address of the customer account. References HZ_CUST_ACCT_SITES_ALL.SITE_USE_ID where SITE_USE_CODE='SHIP_TO'.
PAYMENT_TERM_ID	NUMBER	(15)		Stores Payment terms identifier. This column is used to identify the payment terms for the invoice. References AP_TERMS_TL.TERM_ID.
DATE_CANCELLED	DATE			Date contract line was canceled
TERM_CANCEL_SOURCE	VARCHAR2	(30)		Indicates the termination / cancelation source (Ex: MANUAL / IBTRANSFER / IBREPLACE...)
PAYMENT_INSTRUCTION_TYPE	VARCHAR2	(3)		Bank account- this column will store payment instruction type like PON,CHK,WIR
ANNUALIZED_FACTOR	NUMBER			Factor when multiplied by contract line amount gives annualized line amount. Alternately the amount of the contract line if it were authored for one year
CANCELLED_AMOUNT	NUMBER			Canceled amount of contract line, if there exists any canceled subline

Query Text

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


SELECT 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
,      DATE_CANCELLED
,      TERM_CANCEL_SOURCE
,      PAYMENT_INSTRUCTION_TYPE
,      ANNUALIZED_FACTOR
,      CANCELLED_AMOUNT
FROM OKC.OKC_K_LINES_B;

Dependencies

[top of page]

OKC.OKC_K_LINES_B does not reference any database object

OKC.OKC_K_LINES_B is referenced by following:

APPS: OKC_K_LINES_B