[Home] [Help]
[Dependency Information]
Object Name: | OKC_K_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
DEFINITION
A CONTRACT LINE is a supertype of CLIN, SUBCLIN and LINE DETAIL which group a set of deliverable ITEMS and/or ACTIVITYS into a logical set usually defined by unitary price, delivery or some other classification and also provides an association point for any specific RULES governing the performance of that particular delivery
LINE may be defined as a "visible" and / or "deliverable" or as a an aid to management
eg. a parent LINE may be defined in order to provide a grouping mechanism for a number of LINE which allows RULE to be associated once but for all. The LINE is not to be printed or delivered but is a hidden grouping mechanism, a context
or sub-LINE may defined which further details the components of a deliverable for management purposes
There is a restriction inherent in this choice of hierarchical structure. This structure avoids the necessity of another grouping entity, but therefore a LINE cannot be in 2 "context" groups simultaneously (no multi inheritance). This has to be achieved by repetitive sub LINE for all of the parent LINE requireing second context.
Another use of a sub LINE is where a RULE applies to some component aspect of the parent LINE. eg. for a LINE regarding a project task, it may be necessary to override the rate for, say, a particular non-labour resource. This is achieved by a sub LINE of the task LINE, associated with the resource and with the attached override RULE.
EXAMPLE
MISCELLANEOUS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | The address of the row in the database | |
ID | NUMBER | Yes | Unique identifier of the contract line. Primary key column. | |
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. |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Indicates a value was changed in another language. Not fully implemented in 11i |
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 | ||
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. | ||
LSE_ID | NUMBER | Yes | Unique identifier of line style. Refers to ID in OKC_LINE_STYLES_B. | |
LINE_NUMBER | VARCHAR2 | (150) | Yes | Sequencial line number. |
STS_CODE | VARCHAR2 | (30) | Yes | Unique identifier of status code. Refers to status OKC_STATUSES_B. |
DISPLAY_SEQUENCE | NUMBER | (7) | Yes | Order of line within parent. |
TRN_CODE | VARCHAR2 | (30) | Line termination code. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE=OKC_TERMINATION_REASON. | |
DNZ_CHR_ID | NUMBER | Yes | Contract ID. Denormalized for performance. | |
COMMENTS | VARCHAR2 | (1995) | User entered comment. | |
ITEM_DESCRIPTION | VARCHAR2 | (1995) | Item description. | |
OKE_BOE_DESCRIPTION | VARCHAR2 | (1995) | BOE Description of for Contract Projects | |
HIDDEN_IND | VARCHAR2 | (3) | Indicates whether the line is visible on the contract or hidden and only visible in the contract management system. Valid values Y and N. | |
PRICE_UNIT | NUMBER | Price per unit. | ||
PRICE_UNIT_PERCENT | NUMBER | (6) | Price unit percent. | |
PRICE_NEGOTIATED | NUMBER | The calculated or manually adjusted rollup extended price all sublines. | ||
PRICE_NEGOTIATED_RENEWED | NUMBER | Value of PRICE_NEGOTIATED column from renewed contract line | ||
PRICE_LEVEL_IND | VARCHAR2 | (3) | Indicates whether extended value is to be calculated and displayed at this level. Valid values Y and N. | |
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. | |
BLOCK23TEXT | VARCHAR2 | (1995) | Government DD250 block 23 text. | |
EXCEPTION_YN | VARCHAR2 | (3) | Yes | It indicates the lines that are de-selected from a set of lines comming under the same parent. Valid values Y and N. |
TEMPLATE_USED | VARCHAR2 | (150) | Name of template used. | |
DATE_TERMINATED | DATE | Date contract was terminated. | ||
NAME | VARCHAR2 | (150) | Item name. | |
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. | ||
UPG_ORIG_SYSTEM_REF | VARCHAR2 | (60) | Identifies original source of data | |
UPG_ORIG_SYSTEM_REF_ID | NUMBER | Unique Id from original system | ||
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. | |
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. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
PRICE_TYPE | VARCHAR2 | (30) | Contract price type. | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency code as defined in FND_CURRENCIES. | |
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 renewed lines. | |
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 | |
COGNOMEN | VARCHAR2 | (300) | Cognomen field | |
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_LINE_ID | NUMBER | Identifier of the Price List used for pricing this Contract Line. Quickcodes : LIST_HEADER_ID from QP_LIST_HEADERS_B | ||
PRICE_LIST_ID | NUMBER | Identifier of the Price List used for pricing this Contract. Quickcodes : LIST_HEADER_ID from QP_LIST_HEADERS_B | ||
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 | |
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. Valid values Y and N. | |
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 | Refers to the config_item_id in CZ_CONFIG_ITEMS 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) | Refers to FND Lookup code where lookup type is OKC_PH_LINE_PRICE_TYPE - Not Used | |
PH_ADJUSTMENT | NUMBER | Estimated percent adjustment - Not Used | ||
PH_PRICE_BREAK_BASIS | VARCHAR2 | (30) | Refers to FND Lookup code 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 | Refers to QP_LIST_LINES.LIST_LINE_ID or QP_LIST_HEADERS_B.LIST_LINE_ID - Not Used | ||
PH_VALUE | NUMBER | Price Hold value - Not Used | ||
PH_ENFORCE_PRICE_LIST_YN | VARCHAR2 | (1) | Yes-No column to indicates that customers will only get the negotiated amount if they make a purchase against a particular price list - Not Used | |
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...) | |
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 | ||
PAYMENT_INSTRUCTION_TYPE | VARCHAR2 | (3) | ||
CANCELLED_AMOUNT | NUMBER | Canceled amount of the contract line |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, CHR_ID
, CLE_ID
, CLE_ID_RENEWED
, CLE_ID_RENEWED_TO
, LSE_ID
, LINE_NUMBER
, STS_CODE
, DISPLAY_SEQUENCE
, TRN_CODE
, DNZ_CHR_ID
, COMMENTS
, ITEM_DESCRIPTION
, OKE_BOE_DESCRIPTION
, HIDDEN_IND
, PRICE_UNIT
, PRICE_UNIT_PERCENT
, PRICE_NEGOTIATED
, PRICE_NEGOTIATED_RENEWED
, PRICE_LEVEL_IND
, INVOICE_LINE_LEVEL_IND
, DPAS_RATING
, BLOCK23TEXT
, EXCEPTION_YN
, TEMPLATE_USED
, DATE_TERMINATED
, NAME
, START_DATE
, END_DATE
, UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PRICE_TYPE
, CURRENCY_CODE
, CURRENCY_CODE_RENEWED
, DATE_RENEWED
, ORIG_SYSTEM_SOURCE_CODE
, ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1
, COGNOMEN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PRICE_LIST_LINE_ID
, PRICE_LIST_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_ADJUSTMENT
, PH_PRICE_BREAK_BASIS
, PH_MIN_QTY
, PH_MIN_AMT
, PH_QP_REFERENCE_ID
, PH_VALUE
, PH_ENFORCE_PRICE_LIST_YN
, 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
, ANNUALIZED_FACTOR
, PAYMENT_INSTRUCTION_TYPE
, CANCELLED_AMOUNT
FROM APPS.OKC_K_LINES_V;
|
|
|