[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKC_K_LINES_HV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKC.OKC_K_LINES_HV
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
History view for OKC_K_LINES.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | The address of the row in the database | |
| ID | NUMBER | Yes | Primary key column. | |
| MAJOR_VERSION | NUMBER | (4) | Yes | The version of the contract for this history record. |
| 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 | Foreign key to OKC_K_HEADERS_B. | ||
| CLE_ID | NUMBER | Surrogate key used for primary unique identifiers. | ||
| CLE_ID_RENEWED | NUMBER | Surrogate key used for primary unique identifiers. | ||
| CLE_ID_RENEWED_TO | NUMBER | ID of the renewed contract line | ||
| LSE_ID | NUMBER | Yes | Foreign key to OKC_LINE_STYLES_B. | |
| LINE_NUMBER | VARCHAR2 | (150) | Yes | Sequencial line number. |
| STS_CODE | VARCHAR2 | (30) | Line status code defined in FND_LOOKUPS. | |
| DISPLAY_SEQUENCE | NUMBER | (7) | Yes | Order of line within parent. |
| TRN_CODE | VARCHAR2 | (30) | Line termination code as defined in FND_LOOKUPS. | |
| 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) | Yes/No field to Indicate whether the line is visible on the contract or hidden and only visible in the contract management system. | |
| 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) | Yes / No field Indicating whether extended value is to be calculated and displayed at this level. | |
| INVOICE_LINE_LEVEL_IND | VARCHAR2 | (3) | Yes/No field to Indicate if a single invoice line is to be generated at this level for all sublines. | |
| DPAS_RATING | VARCHAR2 | (24) | DPAS rating. | |
| BLOCK23TEXT | VARCHAR2 | (1995) | Government DD250 block 23 text. | |
| EXCEPTION_YN | VARCHAR2 | (3) | Yes | Yes/No flag denoting contract line exception. |
| 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. | ||
| DATE_RENEWED | DATE | Date in which the line is renewed | ||
| 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. | |
| PRICE_TYPE | VARCHAR2 | (30) | Contract price type. | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code as defined in FND_CURRENCIES. | |
| CURRENCY_CODE_RENEWED | VARCHAR2 | (15) | Value of CURRENCY_CODE column from renewed contract line | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
| ORIG_SYSTEM_SOURCE_CODE | VARCHAR2 | (30) | Identifier of the source system | |
| ORIG_SYSTEM_ID1 | NUMBER | Unique identifier of the source system | ||
| ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | Unique identifier of the source system | |
| UPG_ORIG_SYSTEM_REF | VARCHAR2 | (60) | Identifies original source of data | |
| UPG_ORIG_SYSTEM_REF_ID | NUMBER | Unique Id from original 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. | ||
| 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 | |
| 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 the congifured 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 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) | Foreign key to FND Lookup Types where lookup type is OKC_PH_PRICE_BREAK_BASIS - Not Used | |
| PH_MIN_QTY | NUMBER | Purchase minimum qty 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_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 indicator to know wheter it is integrated with QP - Not Used | |
| CUST_ACCT_ID | NUMBER | (15) | Customer account | |
| BILL_TO_SITE_USE_ID | NUMBER | (15) | Contract bill to site | |
| INV_RULE_ID | NUMBER | (15) | Invoice rule | |
| LINE_RENEWAL_TYPE_CODE | VARCHAR2 | (30) | Contract line renewal type | |
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | Contract ship to site | |
| PAYMENT_TERM_ID | NUMBER | (15) | Payment term | |
| 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
, MAJOR_VERSION
, 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
, DATE_RENEWED
, 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
, PRICE_TYPE
, CURRENCY_CODE
, CURRENCY_CODE_RENEWED
, LAST_UPDATE_LOGIN
, ORIG_SYSTEM_SOURCE_CODE
, ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1
, UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID
, 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_HV;
APPS
OKC_K_LINES_BH
OKC_K_LINES_TLH
APPS
OKL_CS_LINE_VERSION_UV
|
|
|
|