[Home] [Help] [Dependency Information]
Object Name: | OKS_K_LINES_HV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_K_LINES_HV |
Subobject Name: | |
Status: | VALID |
Service Contracts Line Attributes History View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ID | NUMBER | Yes | ||
MAJOR_VERSION | NUMBER | Yes | Tracks the primary version number of a contract. | |
CLE_ID | NUMBER | Yes | Unique Identifier for Contract Line. | |
DNZ_CHR_ID | NUMBER | Yes | Unique Identifier for Contract Header, denomalized for efficiency. | |
DISCOUNT_LIST | NUMBER | |||
ACCT_RULE_ID | NUMBER | |||
PAYMENT_TYPE | VARCHAR2 | (30) | ||
CC_NO | VARCHAR2 | (80) | ||
CC_EXPIRY_DATE | DATE | |||
CC_BANK_ACCT_ID | NUMBER | |||
CC_AUTH_CODE | VARCHAR2 | (150) | ||
COMMITMENT_ID | NUMBER | |||
LOCKED_PRICE_LIST_ID | NUMBER | |||
USAGE_EST_YN | VARCHAR2 | (1) | ||
USAGE_EST_METHOD | VARCHAR2 | (30) | ||
USAGE_EST_START_DATE | DATE | |||
TERMN_METHOD | VARCHAR2 | (30) | ||
UBT_AMOUNT | NUMBER | |||
CREDIT_AMOUNT | NUMBER | |||
SUPPRESSED_CREDIT | NUMBER | |||
OVERRIDE_AMOUNT | NUMBER | |||
CUST_PO_NUMBER_REQ_YN | VARCHAR2 | (1) | ||
CUST_PO_NUMBER | VARCHAR2 | (150) | ||
GRACE_DURATION | NUMBER | |||
GRACE_PERIOD | VARCHAR2 | (30) | ||
INV_PRINT_FLAG | VARCHAR2 | (1) | ||
PRICE_UOM | VARCHAR2 | (30) | ||
TAX_AMOUNT | NUMBER | |||
TAX_INCLUSIVE_YN | VARCHAR2 | (1) | ||
TAX_STATUS | VARCHAR2 | (30) | ||
TAX_CODE | NUMBER | |||
TAX_EXEMPTION_ID | NUMBER | |||
IB_TRANS_TYPE | VARCHAR2 | (10) | ||
IB_TRANS_DATE | DATE | |||
PROD_PRICE | NUMBER | |||
SERVICE_PRICE | NUMBER | |||
CLVL_LIST_PRICE | NUMBER | |||
CLVL_QUANTITY | NUMBER | |||
CLVL_EXTENDED_AMT | NUMBER | |||
CLVL_UOM_CODE | VARCHAR2 | (3) | ||
TOPLVL_OPERAND_CODE | VARCHAR2 | (30) | ||
TOPLVL_OPERAND_VAL | NUMBER | |||
TOPLVL_QUANTITY | NUMBER | |||
TOPLVL_UOM_CODE | VARCHAR2 | (3) | ||
TOPLVL_ADJ_PRICE | NUMBER | |||
TOPLVL_PRICE_QTY | NUMBER | |||
AVERAGING_INTERVAL | NUMBER | |||
SETTLEMENT_INTERVAL | VARCHAR2 | (30) | ||
MINIMUM_QUANTITY | NUMBER | |||
DEFAULT_QUANTITY | NUMBER | |||
AMCV_FLAG | VARCHAR2 | (1) | ||
FIXED_QUANTITY | NUMBER | |||
USAGE_DURATION | NUMBER | |||
USAGE_PERIOD | VARCHAR2 | (3) | ||
LEVEL_YN | VARCHAR2 | (1) | ||
USAGE_TYPE | VARCHAR2 | (10) | ||
UOM_QUANTIFIED | VARCHAR2 | (3) | ||
BASE_READING | NUMBER | |||
BILLING_SCHEDULE_TYPE | VARCHAR2 | (10) | ||
FULL_CREDIT | VARCHAR2 | (1) | ||
LOCKED_PRICE_LIST_LINE_ID | NUMBER | |||
BREAK_UOM | VARCHAR2 | (3) | ||
PRORATE | VARCHAR2 | (5) | ||
COVERAGE_TYPE | VARCHAR2 | (30) | ||
EXCEPTION_COV_ID | NUMBER | |||
LIMIT_UOM_QUANTIFIED | VARCHAR2 | (3) | ||
DISCOUNT_AMOUNT | NUMBER | |||
DISCOUNT_PERCENT | NUMBER | |||
OFFSET_DURATION | NUMBER | |||
OFFSET_PERIOD | VARCHAR2 | (3) | ||
INCIDENT_SEVERITY_ID | NUMBER | |||
PDF_ID | NUMBER | |||
WORK_THRU_YN | VARCHAR2 | (1) | ||
REACT_ACTIVE_YN | VARCHAR2 | (1) | ||
TRANSFER_OPTION | VARCHAR2 | (30) | ||
PROD_UPGRADE_YN | VARCHAR2 | (1) | ||
INHERITANCE_TYPE | VARCHAR2 | (30) | ||
PM_PROGRAM_ID | NUMBER | |||
PM_CONF_REQ_YN | VARCHAR2 | (1) | ||
PM_SCH_EXISTS_YN | VARCHAR2 | (1) | ||
ALLOW_BT_DISCOUNT | VARCHAR2 | (1) | ||
APPLY_DEFAULT_TIMEZONE | VARCHAR2 | (1) | ||
SYNC_DATE_INSTALL | VARCHAR2 | (1) | ||
SFWT_FLAG | VARCHAR2 | (3) | Yes | |
INVOICE_TEXT | VARCHAR2 | (2000) | Text of the Invoice. | |
IB_TRX_DETAILS | VARCHAR2 | (2000) | ||
STATUS_TEXT | VARCHAR2 | (450) | ||
REACT_TIME_NAME | VARCHAR2 | (450) | ||
COVERAGE_ID | NUMBER | |||
STANDARD_COV_YN | VARCHAR2 | (1) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. | |
SECURITY_GROUP_ID | NUMBER | Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete. | ||
REQUEST_ID | NUMBER | Unique Identifier of a concurrent request. | ||
CREATED_BY | NUMBER | (15) | Yes | ID of the user whom created the record. |
CREATION_DATE | DATE | Yes | Date the record was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | ID of the last user who updated the record. |
LAST_UPDATE_DATE | DATE | Yes | Date the record was last updated. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | OS ID of the user who last updated the record. | |
TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | ||
EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | (80) | ||
EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
TRXN_EXTENSION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, MAJOR_VERSION
, CLE_ID
, DNZ_CHR_ID
, DISCOUNT_LIST
, ACCT_RULE_ID
, PAYMENT_TYPE
, CC_NO
, CC_EXPIRY_DATE
, CC_BANK_ACCT_ID
, CC_AUTH_CODE
, COMMITMENT_ID
, LOCKED_PRICE_LIST_ID
, USAGE_EST_YN
, USAGE_EST_METHOD
, USAGE_EST_START_DATE
, TERMN_METHOD
, UBT_AMOUNT
, CREDIT_AMOUNT
, SUPPRESSED_CREDIT
, OVERRIDE_AMOUNT
, CUST_PO_NUMBER_REQ_YN
, CUST_PO_NUMBER
, GRACE_DURATION
, GRACE_PERIOD
, INV_PRINT_FLAG
, PRICE_UOM
, TAX_AMOUNT
, TAX_INCLUSIVE_YN
, TAX_STATUS
, TAX_CODE
, TAX_EXEMPTION_ID
, IB_TRANS_TYPE
, IB_TRANS_DATE
, PROD_PRICE
, SERVICE_PRICE
, CLVL_LIST_PRICE
, CLVL_QUANTITY
, CLVL_EXTENDED_AMT
, CLVL_UOM_CODE
, TOPLVL_OPERAND_CODE
, TOPLVL_OPERAND_VAL
, TOPLVL_QUANTITY
, TOPLVL_UOM_CODE
, TOPLVL_ADJ_PRICE
, TOPLVL_PRICE_QTY
, AVERAGING_INTERVAL
, SETTLEMENT_INTERVAL
, MINIMUM_QUANTITY
, DEFAULT_QUANTITY
, AMCV_FLAG
, FIXED_QUANTITY
, USAGE_DURATION
, USAGE_PERIOD
, LEVEL_YN
, USAGE_TYPE
, UOM_QUANTIFIED
, BASE_READING
, BILLING_SCHEDULE_TYPE
, FULL_CREDIT
, LOCKED_PRICE_LIST_LINE_ID
, BREAK_UOM
, PRORATE
, COVERAGE_TYPE
, EXCEPTION_COV_ID
, LIMIT_UOM_QUANTIFIED
, DISCOUNT_AMOUNT
, DISCOUNT_PERCENT
, OFFSET_DURATION
, OFFSET_PERIOD
, INCIDENT_SEVERITY_ID
, PDF_ID
, WORK_THRU_YN
, REACT_ACTIVE_YN
, TRANSFER_OPTION
, PROD_UPGRADE_YN
, INHERITANCE_TYPE
, PM_PROGRAM_ID
, PM_CONF_REQ_YN
, PM_SCH_EXISTS_YN
, ALLOW_BT_DISCOUNT
, APPLY_DEFAULT_TIMEZONE
, SYNC_DATE_INSTALL
, SFWT_FLAG
, INVOICE_TEXT
, IB_TRX_DETAILS
, STATUS_TEXT
, REACT_TIME_NAME
, COVERAGE_ID
, STANDARD_COV_YN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TAX_CLASSIFICATION_CODE
, EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON_CODE
, TRXN_EXTENSION_ID
FROM APPS.OKS_K_LINES_HV;
|
|
|