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: TableOKC.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_K_LINES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
OKC_K_LINES_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHR_ID
OKC_K_LINES_B_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_TO_SITE_USE_ID
OKC_K_LINES_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDNZ_CHR_ID
ColumnCLE_ID
OKC_K_LINES_B_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLE_ID
OKC_K_LINES_B_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEND_DATE
OKC_K_LINES_B_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE
OKC_K_LINES_B_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_TO_SITE_USE_ID
OKC_K_LINES_B_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCT_ID
OKC_K_LINES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDATE_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:

SchemaAPPS
SynonymOKC_K_LINES_B