[Home] [Help]
[Dependency Information]
| Object Name: | OKL_K_HEADERS_FULL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | OKL.OKL_K_HEADERS_FULL_V
|
| 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 | Indicates a value was changed in another language. Not fully implemented in 11i |
| CHR_ID_RESPONSE | NUMBER | Surrogate key used for primary unique identifiers. | ||
| CHR_ID_AWARD | NUMBER | Surrogate key used for primary unique identifiers. | ||
| CHR_ID_RENEWED | NUMBER | Surrogate key used for primary unique identifiers. | ||
| INV_ORGANIZATION_ID | NUMBER | Yes | Foreign key to MTL_SYSTEM_ITEMS. | |
| STS_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
| QCL_ID | NUMBER | Foreign key to OKC_QA_CHECK_LISTS_B. | ||
| SCS_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
| CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract (RFP,Proposal etc.) Legal Identifier. |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code. | |
| CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | A unique internal name for the contract number. | |
| ARCHIVED_YN | VARCHAR2 | (3) | Yes | Lookup type for Yes/No columns |
| DELETED_YN | VARCHAR2 | (3) | Yes | Lookup type for Yes/No columns |
| CUST_PO_NUMBER_REQ_YN | VARCHAR2 | (3) | Purchase Order required flag. | |
| PRE_PAY_REQ_YN | VARCHAR2 | (3) | Contract pre-payment required flag. | |
| CUST_PO_NUMBER | VARCHAR2 | (150) | Customer's Purchase Order Number. | |
| SHORT_DESCRIPTION | VARCHAR2 | (600) | User entered free format abbreviated text description. | |
| COMMENTS | VARCHAR2 | (1995) | User entered comment. | |
| DESCRIPTION | VARCHAR2 | (1995) | User entered free format text description. | |
| DPAS_RATING | VARCHAR2 | (24) | DPAS rating. | |
| COGNOMEN | VARCHAR2 | (300) | Cognomen field. | |
| TEMPLATE_YN | VARCHAR2 | (3) | Yes | Yes or No Flag. |
| TEMPLATE_USED | VARCHAR2 | (120) | Denotes if a template was used to create contract. | |
| DATE_APPROVED | DATE | Date contract was approved. | ||
| DATETIME_CANCELLED | DATE | Date / Time Contract was cancelled. | ||
| AUTO_RENEW_DAYS | NUMBER | (4) | Number of days before automatic renewal of contract. | |
| DATE_ISSUED | DATE | Date contract Issued. | ||
| DATETIME_RESPONDED | DATE | Date / time response sent. | ||
| NON_RESPONSE_REASON | VARCHAR2 | (3) | Used with contract RFP. | |
| NON_RESPONSE_EXPLAIN | VARCHAR2 | (1995) | Used with contract RFP. | |
| RFP_TYPE | VARCHAR2 | (30) | RFP Type. | |
| CHR_TYPE | VARCHAR2 | (30) | Yes | Character type. |
| KEEP_ON_MAIL_LIST | VARCHAR2 | (3) | Keep us on the mailing list? | |
| SET_ASIDE_REASON | VARCHAR2 | (3) | Used with contract RFP. | |
| SET_ASIDE_PERCENT | NUMBER | (5) | Percent set aside for reason specified. | |
| RESPONSE_COPIES_REQ | NUMBER | (2) | Number of proposal copies required. | |
| DATE_CLOSE_PROJECTED | DATE | Date that contract is expected to be signed. | ||
| DATETIME_PROPOSED | DATE | Date / time proposal sent. | ||
| DATE_SIGNED | DATE | Date contract was signed. | ||
| DATE_TERMINATED | DATE | Date contract terminated. | ||
| DATE_RENEWED | DATE | Date contract was renewed. | ||
| TRN_CODE | VARCHAR2 | (30) | Termination code. | |
| 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. | ||
| AUTHORING_ORG_ID | NUMBER | Yes | Authoring Organization ID. | |
| BUY_OR_SELL | VARCHAR2 | (3) | Buy or Sell. | |
| ISSUE_OR_RECEIVE | VARCHAR2 | (3) | Issue or Receive. | |
| ESTIMATED_AMOUNT | NUMBER | Estimated amount of contract. | ||
| CHR_ID_RENEWED_TO | NUMBER | Indicates the contract header that is the renewal of this contract header. Only present in renewed contracts. | ||
| ESTIMATED_AMOUNT_RENEWED | NUMBER | The estimated amount of the contract of which this contract is a renewal. Only present in renewal contracts. | ||
| CURRENCY_CODE_RENEWED | VARCHAR2 | (15) | Currency code from FND_CURRENCIES. The currency for the contract of which this contract is a renewal. Only present in renewal contracts. | |
| USER_ACCESS_LEVEL | VARCHAR2 | (4000) | Access level for the user. | |
| UPG_ORIG_SYSTEM_REF | VARCHAR2 | (60) | Identifies original source of data | |
| UPG_ORIG_SYSTEM_REF_ID | NUMBER | Unique Id from original system | ||
| APPLICATION_ID | NUMBER | Application Identifier | ||
| RESOLVED_UNTIL | DATE | Date till which time-values have been resolved for long contracts. | ||
| 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) | Identifier of the source system | |
| ORIG_SYSTEM_ID1 | NUMBER | Unique identifier in the source system | ||
| ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | Unique identifier in the source system | |
| 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_ID | NUMBER | Price list identifier | ||
| PRICING_DATE | DATE | Pricing date | ||
| TOTAL_LINE_LIST_PRICE | NUMBER | Total line list price | ||
| SIGN_BY_DATE | DATE | Sign by date | ||
| USER_ESTIMATED_AMOUNT | NUMBER | User estimated amount | ||
| GOVERNING_CONTRACT_YN | VARCHAR2 | (3) | Governing contract flag | |
| CUST_ACCT_ID | NUMBER | (15) | Customer account identifier | |
| CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
| CONVERSION_RATE | NUMBER | Currency conversion rate | ||
| CONVERSION_RATE_DATE | DATE | Currenct conversion date | ||
| CONVERSION_EURO_RATE | NUMBER | Conversion euro rate | ||
| BILL_TO_SITE_USE_ID | NUMBER | (15) | Bill to site use identifier | |
| INV_RULE_ID | NUMBER | (15) | Invoice rule identifier | |
| RENEWAL_TYPE_CODE | VARCHAR2 | (30) | Renewal type code | |
| RENEWAL_NOTIFY_TO | NUMBER | Renewal notify to | ||
| RENEWAL_END_DATE | DATE | Renewal end date | ||
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | Ship to site use identifier | |
| PAYMENT_TERM_ID | NUMBER | (15) | Payment term identifier | |
| KHR_ROW_ID | ROWID | (10) | Row identifier in the database | |
| KHR_OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used to lock records during updates |
| ISG_ID | NUMBER | Unique identifier for sales region | ||
| KHR_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
| PDT_ID | NUMBER | Foreign key to table OKL_PRODUCTS | ||
| AMD_CODE | VARCHAR2 | (30) | Acceptance method code. This is a foreign key to FND_LOOKUP code 'OKL_ACCEPTANCE_METHOD'. | |
| DATE_FIRST_ACTIVITY | DATE | Date of first activity on the contract | ||
| GENERATE_ACCRUAL_YN | VARCHAR2 | (3) | Indicates whether to generate accrual or not | |
| GENERATE_ACCRUAL_OVERRIDE_YN | VARCHAR2 | (3) | Indicates whether to override generation of accrual or not | |
| DATE_REFINANCED | DATE | The date finance closed if this was a rollover, restructure, renew, refinance contract | ||
| CREDIT_ACT_YN | VARCHAR2 | (3) | Indicates whether contract is consumer credit act deal or not | |
| TERM_DURATION | NUMBER | (10) | The duration of the contract in months | |
| CONVERTED_ACCOUNT_YN | VARCHAR2 | (3) | Indicates whether the contract account is a converted account or not | |
| DATE_CONVERSION_EFFECTIVE | DATE | Date on which the deal conversion becomes active | ||
| SYNDICATABLE_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for syndication or not | |
| SALESTYPE_YN | VARCHAR2 | (3) | Indicates whether it is a sales type contract or not | |
| DATE_DEAL_TRANSFERRED | DATE | Date on which the deal was transferred from one lessee to another | ||
| DATETIME_PROPOSAL_EFFECTIVE | DATE | Date on which the proposal becomes effective | ||
| DATETIME_PROPOSAL_INEFFECTIVE | DATE | Date on which the proposal becomes ineffective | ||
| DATE_PROPOSAL_ACCEPTED | DATE | Date on which notification of acceptance of the proposal was received | ||
| KHR_ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
| KHR_ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
| KHR_CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| KHR_CREATON_DATE | DATE | Yes | Standard who column | |
| KHR_LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| KHR_LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| KHR_LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| PRE_TAX_YIELD | NUMBER | Yield before tax | ||
| AFTER_TAX_YIELD | NUMBER | Yield after tax | ||
| IMPLICIT_INTEREST_RATE | NUMBER | Implicit interest rate | ||
| IMPLICIT_NON_IDC_INTEREST_RATE | NUMBER | Implicit non-IDC interest rate | ||
| TARGET_PRE_TAX_YIELD | NUMBER | Target pre tax yield | ||
| TARGET_AFTER_TAX_YIELD | NUMBER | Target after tax yield | ||
| TARGET_IMPLICIT_INTEREST_RATE | NUMBER | Target implicit interest rate | ||
| TARGET_IMPLICIT_NONIDC_INTRATE | NUMBER | Target implicit non-IDC interest rate | ||
| DATE_LAST_INTERIM_INTEREST_CAL | DATE | Last Interim interest calculation date | ||
| DEAL_TYPE | VARCHAR2 | (30) | Book Classification of the contract | |
| PRE_TAX_IRR | NUMBER | Pre tax IRR for the contract | ||
| AFTER_TAX_IRR | NUMBER | After tax IRR for the contract | ||
| EXPECTED_DELIVERY_DATE | DATE | Earliest date by which a line (financial asset) under this contract will be delivered to the lessee | ||
| ACCEPTED_DATE | DATE | Earliest date by which all the lines on the contract will be accepted | ||
| PREFUNDING_ELIGIBLE_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for pre-funding or not | |
| REVOLVING_CREDIT_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for a revolving line of credit or not | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
| MULTI_GAAP_YN | VARCHAR2 | (3) | Indicates whether the lease contract is eligible for muti GAAP accounting | |
| RECOURSE_CODE | VARCHAR2 | (30) | Recourse code | |
| LESSOR_SERV_ORG_CODE | VARCHAR2 | (30) | Lessor service organization code | |
| ASSIGNABLE_YN | VARCHAR2 | (3) | Indicates whether lease contract can be assigned to investor agreement | |
| SECURITIZED_CODE | VARCHAR2 | (30) | Securitized code | |
| SECURITIZATION_TYPE | VARCHAR2 | (30) | Securitization type | |
| SUB_PRE_TAX_YIELD | NUMBER | Subsidized pre-tax yield | ||
| SUB_AFTER_TAX_YIELD | NUMBER | Subsidized after tax yield | ||
| SUB_IMPL_INTEREST_RATE | NUMBER | Subsidized implicit interest rate | ||
| SUB_IMPL_NON_IDC_INT_RATE | NUMBER | Subsidized implicit non-IDC interest rate | ||
| SUB_PRE_TAX_IRR | NUMBER | Subsidized pre-tax IRR | ||
| SUB_AFTER_TAX_IRR | NUMBER | Subsidized after tax IRR | ||
| TOT_CL_TRANSFER_AMT | NUMBER | Total creditline transfer amount | ||
| TOT_CL_NET_TRANSFER_AMT | NUMBER | Total creditline net transfer amount | ||
| TOT_CL_LIMIT | NUMBER | Total creditline limit | ||
| TOT_CL_FUNDING_AMT | NUMBER | Total creditline funding amount | ||
| CRS_ID | NUMBER | Change request identifier | ||
| TEMPLATE_TYPE_CODE | VARCHAR2 | (30) | Template type code | |
| TRADEIN_DESCRIPTION | VARCHAR2 | (1995) | Trade in description | |
| TRADEIN_AMOUNT | NUMBER | Trade in amount | ||
| DATE_TRADEIN | DATE | Trade in date | ||
| DATE_FUNDING_EXPECTED | DATE | Date on which funding is expected | ||
| LEGAL_ENTITY_ID | NUMBER | Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES |
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
, USER_ESTIMATED_AMOUNT
, GOVERNING_CONTRACT_YN
, CUST_ACCT_ID
, CONVERSION_TYPE
, CONVERSION_RATE
, CONVERSION_RATE_DATE
, CONVERSION_EURO_RATE
, BILL_TO_SITE_USE_ID
, INV_RULE_ID
, RENEWAL_TYPE_CODE
, RENEWAL_NOTIFY_TO
, RENEWAL_END_DATE
, SHIP_TO_SITE_USE_ID
, PAYMENT_TERM_ID
, 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_ATTRIBUTE6
, KHR_ATTRIBUTE7
, 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
, EXPECTED_DELIVERY_DATE
, ACCEPTED_DATE
, PREFUNDING_ELIGIBLE_YN
, REVOLVING_CREDIT_YN
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, MULTI_GAAP_YN
, RECOURSE_CODE
, LESSOR_SERV_ORG_CODE
, ASSIGNABLE_YN
, SECURITIZED_CODE
, SECURITIZATION_TYPE
, SUB_PRE_TAX_YIELD
, SUB_AFTER_TAX_YIELD
, SUB_IMPL_INTEREST_RATE
, SUB_IMPL_NON_IDC_INT_RATE
, SUB_PRE_TAX_IRR
, SUB_AFTER_TAX_IRR
, TOT_CL_TRANSFER_AMT
, TOT_CL_NET_TRANSFER_AMT
, TOT_CL_LIMIT
, TOT_CL_FUNDING_AMT
, CRS_ID
, TEMPLATE_TYPE_CODE
, TRADEIN_DESCRIPTION
, TRADEIN_AMOUNT
, DATE_TRADEIN
, DATE_FUNDING_EXPECTED
, LEGAL_ENTITY_ID
FROM APPS.OKL_K_HEADERS_FULL_V;
APPS
OKC_K_HEADERS_B
OKC_K_HEADERS_TL
OKC_UTIL
- show dependent code
OKL_K_HEADERS
APPS
IEX_CASE_CONTRACTS_OPEN_V
IEX_CASE_CONTRACT_WRITEOFFS_V
IEX_CASE_INVOICES_OPEN_V
IEX_CASE_INVOICE_WRITEOFFS_V
OKL_ACCOUNTING_PROCESS_PVT
- show dependent code
OKL_ACCOUNTING_UTIL
- show dependent code
OKL_ACCRUAL_DEPRN_ADJ_PVT
- show dependent code
OKL_ACC_CALL_PVT
- show dependent code
OKL_ACTIVATE_ASSET_PVT
- show dependent code
OKL_ACTIVATE_ASSET_PVT
- show dependent code
OKL_ACTIVATE_CONTRACT_PUB
- show dependent code
OKL_AM_AMORTIZE_PVT
- show dependent code
OKL_AM_ASSET_DISPOSE_PVT
- show dependent code
OKL_AM_ASSET_RETURN_PVT
- show dependent code
OKL_AM_ASSET_TRACK_UV
OKL_AM_CALCULATE_QUOTE_PVT
- show dependent code
OKL_AM_CONSOLIDATED_QTE_PVT
- show dependent code
OKL_AM_CONTRACT_PARTIES_UV
OKL_AM_CONTRACT_PRTFL_PVT
- show dependent code
OKL_AM_OFF_LSE_TRX_UPD_UV
OKL_AM_QUOTES_UV
OKL_AM_QUOTES_WF
- show dependent code
OKL_AM_RECYCLE_TRMNT_PVT
- show dependent code
OKL_AM_REPURCHASE_ASSET_PVT
- show dependent code
OKL_AM_RESIDUAL_VALUE_WD_UV
OKL_AM_RESTRUCTURE_QUOTE_PVT
- show dependent code
OKL_AM_RV_WRITEDOWN_PVT
- show dependent code
OKL_AM_SALVAGE_VALUE_WD_UV
OKL_AM_SHIPPING_INSTR_PVT
- show dependent code
OKL_AM_TERMNT_QUOTE_PVT
- show dependent code
OKL_AM_TRMNT_TRANSACTIONS_UV
OKL_AM_UTIL_PVT
- show dependent code
OKL_ARINTF_PVT
- show dependent code
OKL_BILLING_CONTROLLER_PVT
- show dependent code
OKL_BILLING_RECON_RPT_PVT
- show dependent code
OKL_BILL_UPFRONT_TAX_PVT
- show dependent code
OKL_BLK_AST_UPD_PVT
- show dependent code
OKL_BPD_CAP_ADV_MON_PVT
- show dependent code
OKL_BPD_TERMINATION_ADJ_PVT
- show dependent code
OKL_BTCH_CASH_APPLIC
- show dependent code
OKL_BTC_PVT
- show dependent code
OKL_CASH_APPL_RULES
- show dependent code
OKL_CONTRACT_APPROVAL_PVT
- show dependent code
OKL_CONTRACT_LINE_ITEM_PVT
- show dependent code
OKL_CONTRACT_PVT
- show dependent code
OKL_CONTRACT_REBOOK_PVT
- show dependent code
OKL_COPY_ASSET_PVT
- show dependent code
OKL_CREATE_KLE_PVT
- show dependent code
OKL_CS_LEASE_RENEWAL_PVT
- show dependent code
OKL_CS_LEASE_RENEWAL_PVT
- show dependent code
OKL_CS_OKS_CONTRACTS_UV
OKL_CS_PRINCIPAL_PAYDOWN_PVT
- show dependent code
OKL_CS_PRINCIPAL_PAYDOWN_PVT
- show dependent code
OKL_DAILY_INTEREST_CALC_PVT
- show dependent code
OKL_DEAL_ASSET_PVT
- show dependent code
OKL_DEAL_CREATE_PUB
- show dependent code
OKL_DEAL_CREATE_PUB
- show dependent code
OKL_DEAL_CREAT_PVT
- show dependent code
OKL_DEAL_CREAT_PVT
- show dependent code
OKL_EVERGREEN_BILLING_PVT
- show dependent code
OKL_FA_AMOUNTS_PVT
- show dependent code
OKL_FUNDING_PVT
- show dependent code
OKL_GENERATE_ACCRUALS_PVT
- show dependent code
OKL_GENERATE_ACCRUALS_PVT
- show dependent code
OKL_INSURANCE_POLICIES_PVT
- show dependent code
OKL_INS_QUOTE_PVT
- show dependent code
OKL_INTEREST_CALC_PVT
- show dependent code
OKL_INTERNAL_BILLING_PVT
- show dependent code
OKL_INTERNAL_TO_EXTERNAL
- show dependent code
OKL_INVESTOR_BILLING_PVT
- show dependent code
OKL_INVESTOR_INVOICE_DISB_PVT
- show dependent code
OKL_ISG_UTILS_PVT
- show dependent code
OKL_KBK_APPROVALS_WF
- show dependent code
OKL_LA_ASSET_PVT
- show dependent code
OKL_LA_ASSET_PVT
- show dependent code
OKL_LA_JE_PVT
- show dependent code
OKL_LA_SALES_TAX_PVT
- show dependent code
OKL_LA_STREAM_PVT
- show dependent code
OKL_LA_VALIDATION_UTIL_PVT
- show dependent code
OKL_LOSS_PROV_PVT
- show dependent code
OKL_LTE_CHRG_PVT
- show dependent code
OKL_LTE_INT_PVT
- show dependent code
OKL_MAINTAIN_FEE_PVT
- show dependent code
OKL_MLA_CREATE_UPDATE_PUB
- show dependent code
OKL_MLA_CREATE_UPDATE_PUB
- show dependent code
OKL_MULTIGAAP_ENGINE_PVT
- show dependent code
OKL_MULTI_GAAP_PVT
- show dependent code
OKL_MULTI_GAAP_PVT
- show dependent code
OKL_OPEN_INTERFACE_PVT
- show dependent code
OKL_PAY_INVOICES_CONS_PVT
- show dependent code
OKL_PAY_INVOICES_DISB_PVT
- show dependent code
OKL_PAY_INVOICES_MAN_PVT
- show dependent code
OKL_PFC_PVT
- show dependent code
OKL_POOL_PVT
- show dependent code
OKL_PRINT_CONS_BILL
- show dependent code
OKL_PROP_TAX_ADJ_PVT
- show dependent code
OKL_QA_DATA_INTEGRITY
- show dependent code
OKL_REBOOK_CM_PVT
- show dependent code
OKL_RECEIPTS_PVT
- show dependent code
OKL_RELEASE_PVT
- show dependent code
OKL_REVISIONS_UV
OKL_REV_LOSS_PROV_PVT
- show dependent code
OKL_REV_LOSS_PROV_PVT
- show dependent code
OKL_SEC_AGREEMENT_PVT
- show dependent code
OKL_SEEDED_FUNCTIONS_PVT
- show dependent code
OKL_SETUPPRODUCTS_PVT
- show dependent code
OKL_SPLIT_ASSET_PVT
- show dependent code
OKL_STREAMS_UTIL
- show dependent code
OKL_STREAMS_UTIL
- show dependent code
OKL_STREAM_BILLING_PVT
- show dependent code
OKL_STREAM_GENERATOR_PVT
- show dependent code
OKL_TRANSACTION_PVT
- show dependent code
OKL_TXD_ASSETS_PVT
- show dependent code
OKL_TXL_ASSETS_PVT
- show dependent code
OKL_UBB_INTEGRATION_PVT
- show dependent code
OKL_VARIABLE_INTEREST_PVT
- show dependent code
OKL_VARIABLE_INTEREST_PVT
- show dependent code
OKL_VARIABLE_INT_UTIL_PVT
- show dependent code
OKL_VENDOR_PROGRAM_PVT
- show dependent code
OKL_VENDOR_PROGRAM_PVT
- show dependent code
|
|
|
|