[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_K_HEADERS_UV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_K_HEADERS_UV
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row Identifier in the database | |
| ID | NUMBER | Yes | Primary key column | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
| SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
| CHR_ID_RESPONSE | NUMBER | |||
| CHR_ID_AWARD | NUMBER | |||
| CHR_ID_RENEWED | NUMBER | |||
| INV_ORGANIZATION_ID | NUMBER | Yes | ||
| STS_CODE | VARCHAR2 | (30) | Yes | |
| QCL_ID | NUMBER | |||
| SCS_CODE | VARCHAR2 | (30) | Yes | |
| CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | ||
| ARCHIVED_YN | VARCHAR2 | (3) | Yes | |
| DELETED_YN | VARCHAR2 | (3) | Yes | |
| CUST_PO_NUMBER_REQ_YN | VARCHAR2 | (3) | ||
| PRE_PAY_REQ_YN | VARCHAR2 | (3) | ||
| CUST_PO_NUMBER | VARCHAR2 | (150) | ||
| SHORT_DESCRIPTION | VARCHAR2 | (600) | ||
| COMMENTS | VARCHAR2 | (1995) | User entered comments | |
| DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
| DPAS_RATING | VARCHAR2 | (24) | ||
| COGNOMEN | VARCHAR2 | (300) | ||
| TEMPLATE_YN | VARCHAR2 | (3) | Yes | |
| TEMPLATE_USED | VARCHAR2 | (120) | ||
| DATE_APPROVED | DATE | |||
| DATETIME_CANCELLED | DATE | |||
| AUTO_RENEW_DAYS | NUMBER | (4) | ||
| DATE_ISSUED | DATE | |||
| DATETIME_RESPONDED | DATE | |||
| NON_RESPONSE_REASON | VARCHAR2 | (3) | ||
| NON_RESPONSE_EXPLAIN | VARCHAR2 | (1995) | ||
| RFP_TYPE | VARCHAR2 | (30) | ||
| CHR_TYPE | VARCHAR2 | (30) | Yes | |
| KEEP_ON_MAIL_LIST | VARCHAR2 | (3) | ||
| SET_ASIDE_REASON | VARCHAR2 | (3) | ||
| SET_ASIDE_PERCENT | NUMBER | (5) | ||
| RESPONSE_COPIES_REQ | NUMBER | (2) | ||
| DATE_CLOSE_PROJECTED | DATE | |||
| DATETIME_PROPOSED | DATE | |||
| DATE_SIGNED | DATE | |||
| DATE_TERMINATED | DATE | |||
| DATE_RENEWED | DATE | |||
| TRN_CODE | VARCHAR2 | (30) | ||
| START_DATE | DATE | Start Date | ||
| END_DATE | DATE | End Date | ||
| AUTHORING_ORG_ID | NUMBER | Yes | ||
| BUY_OR_SELL | VARCHAR2 | (3) | ||
| ISSUE_OR_RECEIVE | VARCHAR2 | (3) | ||
| ESTIMATED_AMOUNT | NUMBER | |||
| CHR_ID_RENEWED_TO | NUMBER | |||
| ESTIMATED_AMOUNT_RENEWED | NUMBER | |||
| CURRENCY_CODE_RENEWED | VARCHAR2 | (15) | ||
| USER_ACCESS_LEVEL | VARCHAR2 | (4000) | ||
| UPG_ORIG_SYSTEM_REF | VARCHAR2 | (60) | ||
| UPG_ORIG_SYSTEM_REF_ID | NUMBER | |||
| APPLICATION_ID | NUMBER | |||
| RESOLVED_UNTIL | DATE | |||
| 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 | |
| ORIG_SYSTEM_SOURCE_CODE | VARCHAR2 | (30) | ||
| ORIG_SYSTEM_ID1 | NUMBER | |||
| ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | ||
| PROGRAM_APPLICATION_ID | VARCHAR2 | (0) | Concurrent Manager column | |
| PROGRAM_ID | VARCHAR2 | (0) | Concurrent Manager column | |
| PROGRAM_UPDATE_DATE | VARCHAR2 | (0) | Concurrent Manager column | |
| REQUEST_ID | VARCHAR2 | (0) | Concurrent Manager column | |
| PRICE_LIST_ID | VARCHAR2 | (0) | ||
| PRICING_DATE | VARCHAR2 | (0) | ||
| TOTAL_LINE_LIST_PRICE | VARCHAR2 | (0) | ||
| SIGN_BY_DATE | VARCHAR2 | (0) | ||
| KHR_ROW_ID | ROWID | (10) | ||
| KHR_OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
| ISG_ID | NUMBER | |||
| KHR_ID | NUMBER | Foreign key to view OKL_K_HEADERS_V | ||
| PDT_ID | NUMBER | Foreign key to view OKL_PRODUCTS_V | ||
| AMD_CODE | VARCHAR2 | (30) | ||
| DATE_FIRST_ACTIVITY | DATE | |||
| GENERATE_ACCRUAL_YN | VARCHAR2 | (3) | ||
| GENERATE_ACCRUAL_OVERRIDE_YN | VARCHAR2 | (3) | ||
| DATE_REFINANCED | DATE | |||
| CREDIT_ACT_YN | VARCHAR2 | (3) | ||
| TERM_DURATION | NUMBER | (10) | ||
| CONVERTED_ACCOUNT_YN | VARCHAR2 | (3) | ||
| DATE_CONVERSION_EFFECTIVE | DATE | |||
| SYNDICATABLE_YN | VARCHAR2 | (3) | ||
| SALESTYPE_YN | VARCHAR2 | (3) | ||
| DATE_DEAL_TRANSFERRED | DATE | |||
| DATETIME_PROPOSAL_EFFECTIVE | DATE | |||
| DATETIME_PROPOSAL_INEFFECTIVE | DATE | |||
| DATE_PROPOSAL_ACCEPTED | DATE | |||
| KHR_ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
| KHR_ATTRIBUTE1 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE2 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE3 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE4 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE5 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUT6 | VARCHAR2 | (450) | ||
| KHR_ATTRBUTE7 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE8 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE9 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE10 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE11 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE12 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE13 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE14 | VARCHAR2 | (450) | ||
| KHR_ATTRIBUTE15 | VARCHAR2 | (450) | ||
| KHR_CREATED_BY | NUMBER | (15) | Yes | |
| KHR_CREATON_DATE | DATE | Yes | ||
| KHR_LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| KHR_LAST_UPDATE_DATE | DATE | Yes | ||
| KHR_LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| PRE_TAX_YIELD | NUMBER | |||
| AFTER_TAX_YIELD | NUMBER | |||
| IMPLICIT_INTEREST_RATE | NUMBER | |||
| IMPLICIT_NON_IDC_INTEREST_RATE | NUMBER | |||
| TARGET_PRE_TAX_YIELD | NUMBER | |||
| TARGET_AFTER_TAX_YIELD | NUMBER | |||
| TARGET_IMPLICIT_INTEREST_RATE | NUMBER | |||
| TARGET_IMPLICIT_NONIDC_INTRATE | NUMBER | |||
| DATE_LAST_INTERIM_INTEREST_CAL | DATE | |||
| DEAL_TYPE | VARCHAR2 | (30) | ||
| PRE_TAX_IRR | NUMBER | |||
| AFTER_TAX_IRR | NUMBER | |||
| CUSTOMER_NAME | VARCHAR2 | (360) | ||
| CONTRACT_STATUS | VARCHAR2 | (90) | Yes | |
| PRODUCT_NAME | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, CHR_ID_RESPONSE
, CHR_ID_AWARD
, CHR_ID_RENEWED
, INV_ORGANIZATION_ID
, STS_CODE
, QCL_ID
, SCS_CODE
, CONTRACT_NUMBER
, CURRENCY_CODE
, CONTRACT_NUMBER_MODIFIER
, ARCHIVED_YN
, DELETED_YN
, CUST_PO_NUMBER_REQ_YN
, PRE_PAY_REQ_YN
, CUST_PO_NUMBER
, SHORT_DESCRIPTION
, COMMENTS
, DESCRIPTION
, DPAS_RATING
, COGNOMEN
, TEMPLATE_YN
, TEMPLATE_USED
, DATE_APPROVED
, DATETIME_CANCELLED
, AUTO_RENEW_DAYS
, DATE_ISSUED
, DATETIME_RESPONDED
, NON_RESPONSE_REASON
, NON_RESPONSE_EXPLAIN
, RFP_TYPE
, CHR_TYPE
, KEEP_ON_MAIL_LIST
, SET_ASIDE_REASON
, SET_ASIDE_PERCENT
, RESPONSE_COPIES_REQ
, DATE_CLOSE_PROJECTED
, DATETIME_PROPOSED
, DATE_SIGNED
, DATE_TERMINATED
, DATE_RENEWED
, TRN_CODE
, START_DATE
, END_DATE
, AUTHORING_ORG_ID
, BUY_OR_SELL
, ISSUE_OR_RECEIVE
, ESTIMATED_AMOUNT
, CHR_ID_RENEWED_TO
, ESTIMATED_AMOUNT_RENEWED
, CURRENCY_CODE_RENEWED
, USER_ACCESS_LEVEL
, UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID
, APPLICATION_ID
, RESOLVED_UNTIL
, 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
, ORIG_SYSTEM_SOURCE_CODE
, ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PRICE_LIST_ID
, PRICING_DATE
, TOTAL_LINE_LIST_PRICE
, SIGN_BY_DATE
, KHR_ROW_ID
, KHR_OBJECT_VERSION_NUMBER
, ISG_ID
, KHR_ID
, PDT_ID
, AMD_CODE
, DATE_FIRST_ACTIVITY
, GENERATE_ACCRUAL_YN
, GENERATE_ACCRUAL_OVERRIDE_YN
, DATE_REFINANCED
, CREDIT_ACT_YN
, TERM_DURATION
, CONVERTED_ACCOUNT_YN
, DATE_CONVERSION_EFFECTIVE
, SYNDICATABLE_YN
, SALESTYPE_YN
, DATE_DEAL_TRANSFERRED
, DATETIME_PROPOSAL_EFFECTIVE
, DATETIME_PROPOSAL_INEFFECTIVE
, DATE_PROPOSAL_ACCEPTED
, KHR_ATTRIBUTE_CATEGORY
, KHR_ATTRIBUTE1
, KHR_ATTRIBUTE2
, KHR_ATTRIBUTE3
, KHR_ATTRIBUTE4
, KHR_ATTRIBUTE5
, KHR_ATTRIBUT6
, KHR_ATTRBUTE7
, KHR_ATTRIBUTE8
, KHR_ATTRIBUTE9
, KHR_ATTRIBUTE10
, KHR_ATTRIBUTE11
, KHR_ATTRIBUTE12
, KHR_ATTRIBUTE13
, KHR_ATTRIBUTE14
, KHR_ATTRIBUTE15
, KHR_CREATED_BY
, KHR_CREATON_DATE
, KHR_LAST_UPDATED_BY
, KHR_LAST_UPDATE_DATE
, KHR_LAST_UPDATE_LOGIN
, PRE_TAX_YIELD
, AFTER_TAX_YIELD
, IMPLICIT_INTEREST_RATE
, IMPLICIT_NON_IDC_INTEREST_RATE
, TARGET_PRE_TAX_YIELD
, TARGET_AFTER_TAX_YIELD
, TARGET_IMPLICIT_INTEREST_RATE
, TARGET_IMPLICIT_NONIDC_INTRATE
, DATE_LAST_INTERIM_INTEREST_CAL
, DEAL_TYPE
, PRE_TAX_IRR
, AFTER_TAX_IRR
, CUSTOMER_NAME
, CONTRACT_STATUS
, PRODUCT_NAME
FROM APPS.OKL_K_HEADERS_UV;
APPS
HZ_CUST_ACCOUNTS
HZ_PARTIES
OKC_K_HEADERS_B
OKC_K_HEADERS_TL
OKC_STATUSES_TL
OKC_UTIL
- show dependent code
OKL_K_HEADERS
OKL_PRODUCTS
APPS.OKL_K_HEADERS_UV is not referenced by any database object
|
|
|
|