[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKS_AUTH_LINES_HV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKS.OKS_AUTH_LINES_HV
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| MAJOR_VERSION | NUMBER | (4) | Yes | Tracks the primary version number of a contract. |
| ID | NUMBER | Yes | ||
| LINE_NUMBER | VARCHAR2 | (150) | Yes | |
| CHR_ID | NUMBER | Unique Identifier for Contract Header | ||
| CLE_ID | NUMBER | Unique Identifier for Contract Line. | ||
| CLE_ID_RENEWED | NUMBER | |||
| DNZ_CHR_ID | NUMBER | Yes | Unique Identifier for Contract Header, denomalized for efficiency. | |
| DISPLAY_SEQUENCE | NUMBER | (7) | Yes | |
| STS_CODE | VARCHAR2 | (30) | ||
| TRN_CODE | VARCHAR2 | (30) | ||
| LSE_ID | NUMBER | Yes | ||
| EXCEPTION_YN | VARCHAR2 | (3) | Yes | |
| 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 | 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. | |
| HIDDEN_IND | VARCHAR2 | (3) | ||
| PRICE_NEGOTIATED | NUMBER | |||
| PRICE_LEVEL_IND | VARCHAR2 | (3) | ||
| PRICE_UNIT | NUMBER | |||
| PRICE_UNIT_PERCENT | NUMBER | (6) | ||
| INVOICE_LINE_LEVEL_IND | VARCHAR2 | (3) | ||
| DPAS_RATING | VARCHAR2 | (24) | ||
| TEMPLATE_USED | VARCHAR2 | (150) | ||
| PRICE_TYPE | VARCHAR2 | (30) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | OS ID of the user who last updated the record. | |
| DATE_TERMINATED | DATE | |||
| START_DATE | DATE | |||
| END_DATE | DATE | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended). | |
| ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield | |
| ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield | |
| SECURITY_GROUP_ID | NUMBER | Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete. | ||
| CLE_ID_RENEWED_TO | NUMBER | |||
| PRICE_NEGOTIATED_RENEWED | NUMBER | |||
| CURRENCY_CODE_RENEWED | VARCHAR2 | (15) | ||
| UPG_ORIG_SYSTEM_REF | VARCHAR2 | (60) | ||
| UPG_ORIG_SYSTEM_REF_ID | NUMBER | |||
| DATE_RENEWED | DATE | |||
| ORIG_SYSTEM_SOURCE_CODE | VARCHAR2 | (30) | ||
| ORIG_SYSTEM_ID1 | NUMBER | |||
| ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | ||
| PROGRAM_APPLICATION_ID | NUMBER | With PROGRAM_ID, keeps track of which concurrent program created or updated each row. | ||
| PROGRAM_ID | NUMBER | With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row. | ||
| PROGRAM_UPDATE_DATE | DATE | Date the concurrent program updated the record. | ||
| REQUEST_ID | NUMBER | Unique Identifier of a concurrent request. | ||
| PRICE_LIST_ID | NUMBER | |||
| PRICE_LIST_LINE_ID | NUMBER | |||
| LINE_LIST_PRICE | NUMBER | |||
| ITEM_TO_PRICE_YN | VARCHAR2 | (3) | ||
| PRICING_DATE | DATE | |||
| PRICE_BASIS_YN | VARCHAR2 | (3) | ||
| CONFIG_HEADER_ID | NUMBER | |||
| CONFIG_REVISION_NUMBER | NUMBER | |||
| CONFIG_COMPLETE_YN | VARCHAR2 | (3) | ||
| CONFIG_VALID_YN | VARCHAR2 | (3) | ||
| CONFIG_TOP_MODEL_LINE_ID | NUMBER | |||
| CONFIG_ITEM_TYPE | VARCHAR2 | (30) | ||
| CONFIG_ITEM_ID | NUMBER | |||
| SERVICE_ITEM_YN | VARCHAR2 | (3) | ||
| PH_PRICING_TYPE | VARCHAR2 | (30) | ||
| PH_PRICE_BREAK_BASIS | VARCHAR2 | (30) | ||
| PH_MIN_QTY | NUMBER | |||
| PH_MIN_AMT | NUMBER | |||
| PH_QP_REFERENCE_ID | NUMBER | |||
| PH_VALUE | NUMBER | |||
| PH_ENFORCE_PRICE_LIST_YN | VARCHAR2 | (1) | ||
| PH_ADJUSTMENT | NUMBER | |||
| PH_INTEGRATED_WITH_QP | VARCHAR2 | (1) | ||
| CUST_ACCT_ID | NUMBER | (15) | ||
| BILL_TO_SITE_USE_ID | NUMBER | (15) | ||
| INV_RULE_ID | NUMBER | (15) | ||
| LINE_RENEWAL_TYPE_CODE | VARCHAR2 | (30) | ||
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | ||
| PAYMENT_TERM_ID | NUMBER | (15) | ||
| LANGUAGE | VARCHAR2 | (12) | Yes | Language Primary Key. Standard MLS column. |
| SOURCE_LANG | VARCHAR2 | (12) | Yes | |
| SFWT_FLAG | VARCHAR2 | (3) | Yes | |
| NAME | VARCHAR2 | (150) | ||
| COMMENTS | VARCHAR2 | (1995) | ||
| ITEM_DESCRIPTION | VARCHAR2 | (1995) | ||
| BLOCK23TEXT | VARCHAR2 | (1995) | ||
| OKE_BOE_DESCRIPTION | VARCHAR2 | (1995) | ||
| COGNOMEN | VARCHAR2 | (300) | ||
| KLN_ID | NUMBER | Yes | ||
| 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) | ||
| 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) | ||
| KLN_OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| LOCKED_PRICE_LIST_LINE_ID | NUMBER | |||
| BREAK_UOM | VARCHAR2 | (3) | ||
| PRORATE | VARCHAR2 | (5) | ||
| INVOICE_TEXT | VARCHAR2 | (2000) | Text of the Invoice. | |
| IB_TRX_DETAILS | VARCHAR2 | (2000) | ||
| STATUS_TEXT | VARCHAR2 | (450) | ||
| REACT_TIME_NAME | VARCHAR2 | (450) | ||
| TRXN_EXTENSION_ID | NUMBER | |||
| PAYMENT_INSTRUCTION_TYPE | VARCHAR2 | (3) | ||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | ||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | (80) | ||
| EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
| COVERAGE_ID | NUMBER | |||
| STANDARD_COV_YN | VARCHAR2 | (1) | ||
| DATE_CANCELLED | DATE | |||
| TERM_CANCEL_SOURCE | VARCHAR2 | (30) | ||
| ANNUALIZED_FACTOR | NUMBER | |||
| CANCELLED_AMOUNT | NUMBER | |||
| COUNTER_VALUE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, MAJOR_VERSION
, 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
, LANGUAGE
, SOURCE_LANG
, SFWT_FLAG
, NAME
, COMMENTS
, ITEM_DESCRIPTION
, BLOCK23TEXT
, OKE_BOE_DESCRIPTION
, COGNOMEN
, KLN_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
, 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
, KLN_OBJECT_VERSION_NUMBER
, LOCKED_PRICE_LIST_LINE_ID
, BREAK_UOM
, PRORATE
, INVOICE_TEXT
, IB_TRX_DETAILS
, STATUS_TEXT
, REACT_TIME_NAME
, TRXN_EXTENSION_ID
, PAYMENT_INSTRUCTION_TYPE
, TAX_CLASSIFICATION_CODE
, EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON_CODE
, COVERAGE_ID
, STANDARD_COV_YN
, DATE_CANCELLED
, TERM_CANCEL_SOURCE
, ANNUALIZED_FACTOR
, CANCELLED_AMOUNT
, COUNTER_VALUE_ID
FROM APPS.OKS_AUTH_LINES_HV;
APPS
OKC_K_LINES_BH
OKC_K_LINES_TLH
OKS_K_LINES_BH
OKS_K_LINES_TLH
APPS.OKS_AUTH_LINES_HV is not referenced by any database object
|
|
|
|