[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;
|
|
|