[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_K_LINES_FULL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_K_LINES_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 | 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) | Yes | 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. | ||
| UPG_ORIG_SYSTEM_REF | VARCHAR2 | (60) | Identifies original source of data | |
| UPG_ORIG_SYSTEM_REF_ID | NUMBER | Unique Id from original system | ||
| 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 | |
| PRICE_TYPE | VARCHAR2 | (30) | Contract price type. | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code as defined in FND_CURRENCIES. | |
| CURRENCY_CODE_RENEWED | VARCHAR2 | (15) | Currency code as defined in FND_CURRENCIES. This represents the currency in which the renewed-from line is priced. Only present in renewed lines. | |
| DATE_RENEWED | DATE | Date on which the line was renewed or renew consolidated | ||
| 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 | ||
| PRICE_LIST_LINE_ID | NUMBER | Price list line identifier | ||
| LINE_LIST_PRICE | NUMBER | Line list price | ||
| ITEM_TO_PRICE_YN | VARCHAR2 | (3) | Item to price flag | |
| PRICING_DATE | DATE | Pricing date | ||
| PRICE_BASIS_YN | VARCHAR2 | (3) | Price basis flag | |
| CONFIG_HEADER_ID | NUMBER | Configuration header identifier | ||
| CONFIG_REVISION_NUMBER | NUMBER | Configuration revision number | ||
| CONFIG_COMPLETE_YN | VARCHAR2 | (3) | Configuration complete flag | |
| CONFIG_VALID_YN | VARCHAR2 | (3) | Configuration valid flag | |
| CONFIG_TOP_MODEL_LINE_ID | NUMBER | Configuration top model line identifier | ||
| CONFIG_ITEM_TYPE | VARCHAR2 | (30) | Configuration item type | |
| CONFIG_ITEM_ID | NUMBER | Configuration item identifier | ||
| SERVICE_ITEM_YN | VARCHAR2 | (3) | Service item flag | |
| PH_PRICING_TYPE | VARCHAR2 | (30) | PH pricing type | |
| PH_PRICE_BREAK_BASIS | VARCHAR2 | (30) | PH Price break basis | |
| PH_MIN_QTY | NUMBER | PH Minimum quantity | ||
| PH_MIN_AMT | NUMBER | PH Minimum amount | ||
| PH_QP_REFERENCE_ID | NUMBER | PH QP reference identifier | ||
| PH_VALUE | NUMBER | PH value | ||
| PH_ENFORCE_PRICE_LIST_YN | VARCHAR2 | (1) | PH enforce price list flag | |
| PH_ADJUSTMENT | NUMBER | PH Adjustment | ||
| PH_INTEGRATED_WITH_QP | VARCHAR2 | (1) | PH integrated with QP | |
| CUST_ACCT_ID | NUMBER | (15) | customer account identifier | |
| BILL_TO_SITE_USE_ID | NUMBER | (15) | Bill to site use identifier | |
| INV_RULE_ID | NUMBER | (15) | Invoice rule identifier | |
| LINE_RENEWAL_TYPE_CODE | VARCHAR2 | (30) | Line renewal type code | |
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | Ship to site use identifier | |
| PAYMENT_TERM_ID | NUMBER | (15) | Payment term identifier | |
| OKL_ROW_ID | ROWID | (10) | Row identifier in the database | |
| OKL_OBJECT_VERSION_NUM | NUMBER | (9) | Yes | Column used for locking records during updates |
| KLE_ID | NUMBER | Foreign key to table OKL_K_LINES | ||
| STY_ID | NUMBER | Foreign key to table OKL_STRM_TYPE_B | ||
| PRC_CODE | VARCHAR2 | (30) | Property class code. Foreign key to FND_LOOKUPS | |
| FCG_CODE | VARCHAR2 | (30) | Funding category code. Foreign key to FND_LOOKUPS | |
| NTY_CODE | VARCHAR2 | (30) | Concept type code. Foreign key to FND_LOOKUPS | |
| ESTIMATED_OEC | NUMBER | (14) | Estimated original equipment cost | |
| LAO_AMOUNT | NUMBER | (14) | Amount of add ons to asset | |
| TITLE_DATE | DATE | Date the title was received by the title holder for the asset | ||
| FEE_CHARGE | NUMBER | (14) | Fee Charge | |
| LRS_PERCENT | NUMBER | (5) | Not used | |
| INITIAL_DIRECT_COST | NUMBER | (14) | Direct costs such as documentation fee associated with leasing a piece of land, built-area. | |
| PERCENT_STAKE | NUMBER | (5) | Not used | |
| PERCENT | NUMBER | (5) | Rate for insurance premium calculation | |
| EVERGREEN_PERCENT | NUMBER | (5) | Evergreen Percentage | |
| AMOUNT_STAKE | NUMBER | (14) | Not used | |
| OCCUPANCY | NUMBER | (20) | The percentage of occupancy of the built facility | |
| COVERAGE | NUMBER | (14) | The amount of coverage for insurance premium calculation | |
| RESIDUAL_PERCENTAGE | NUMBER | (5) | The percentage of original equipment cost to be used for residual value | |
| DATE_LAST_INSPECTION | DATE | Date when the built area was last inspected | ||
| DATE_SOLD | DATE | Date syndication was sold to the investor | ||
| LRV_AMOUNT | NUMBER | (14) | Residual value insurance amount | |
| CAPITAL_REDUCTION | NUMBER | (14) | Currency amount applied to principle | |
| DATE_NEXT_INSPECTION_DUE | DATE | Next time the building will be inspected | ||
| DATE_RESIDUAL_LAST_REVIEW | DATE | Date on which residual was reviewed last time | ||
| DATE_LAST_REAMORTIZATION | DATE | Date on which the amortisation was restarted | ||
| VENDOR_ADVANCE_PAID | NUMBER | (14) | Advance rent paid to the vendor | |
| WEIGHTED_AVERAGE_LIFE | NUMBER | (30) | Average life the building can stand on the ground | |
| TRADEIN_AMOUNT | NUMBER | (14) | Trade-in amount for the item/asset | |
| BOND_EQUIVALENT_YIELD | NUMBER | (5) | The yield on the building lease as a percentage of return from Bonds for the same investment | |
| TERMINATION_PURCHASE_AMOUNT | NUMBER | (14) | The amount paid for buyout | |
| REFINANCE_AMOUNT | NUMBER | (14) | The amount used to refinance the lease of the building | |
| YEAR_BUILT | NUMBER | (4) | Year the building was built. | |
| DELIVERED_DATE | DATE | Date in which the item is delivered | ||
| CREDIT_TENANT_YN | VARCHAR2 | (3) | Indicates whether tenant has to be credited or not. Used in real estate contracts only | |
| DATE_LAST_CLEANUP | DATE | Catchup when change of interest for fixed payment impacts interest payments | ||
| YEAR_OF_MANUFACTURE | VARCHAR2 | (240) | Year in which the item/asset is manufactured | |
| COVERAGE_RATIO | NUMBER | (5) | Identifies the debt service coverage of the transaction | |
| REMARKRTED_AMOUNT | NUMBER | (14) | the currency amount received for sale of item | |
| GROSS_SQUARE_FOOTAGE | NUMBER | (30) | Gross square footage of the building located on the property | |
| PRESCRIBED_ASSET_YN | VARCHAR2 | (3) | Indicates wheter asset is a prescribed asset or not | |
| DATE_REMARKETED | DATE | Date when asset remarketed | ||
| NET_RENTABLE | NUMBER | (14) | Net square footage of the building which tenants will pay rent on | |
| REMARKET_MARGIN | NUMBER | The margin on the remarketing amount | ||
| DATE_LETTER_ACCEPTANCE | DATE | Date the customer signed the acceptance letter. | ||
| REPURCHASED_AMOUNT | NUMBER | (14) | The currency amount received for sale of item to partner | |
| DATE_COMMITMENT_EXPIRATION | DATE | Date the commitment expires | ||
| DATE_REPURCHASED | DATE | Date when asset was repurchased | ||
| DATE_APPRAISAL | DATE | Appraisal date | ||
| RESIDUAL_VALUE | NUMBER | (20) | Residual value | |
| APPRAISAL_VALUE | NUMBER | (14) | Appraisal value | |
| SECURED_DEAL_YN | VARCHAR2 | (3) | Indicates whether this is a secured deal or not | |
| GAIN_LOSS | NUMBER | (4) | Flag to indicate loss or gain on the leased asset | |
| FLOOR_AMOUNT | NUMBER | (14) | The absolute minimum one should expect from a repurchase or remarket sale | |
| RE_LEASE_YN | VARCHAR2 | (3) | Indicates whether asset is a re-leased asset or not | |
| PREVIOUS_CONTRACT | VARCHAR2 | (40) | Previous Lessors Contract Number | |
| TRACKED_RESIDUAL | NUMBER | (14) | Field for tracking residual other than what is in the contract | |
| DATE_TITLE_RECEIVED | DATE | Date on which a title was received for this asset | ||
| AMOUNT | NUMBER | (14) | Amount | |
| OKL_ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category | |
| OKL_ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
| OKL_ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
| STY_ID_FOR | NUMBER | (10) | Not used | |
| CLG_ID | NUMBER | Foreign key to table OKL_CNTR_LVLNG_GRPS_B | ||
| OKL_CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| OKL_CREATION_DATE | DATE | Yes | Standard who column | |
| OKL_LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| OKL_LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| OKL_LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| DATE_FUNDING | DATE | Date on which funding is done | ||
| DATE_FUNDING_REQUIRED | DATE | Date on which funding is required | ||
| DATE_ACCEPTED | DATE | Acceptance date | ||
| DATE_DELIVERY_EXPECTED | DATE | Date on which delivery of asset is expected | ||
| OEC | NUMBER | (14) | Original equipment cost of the asset | |
| CAPITAL_AMOUNT | NUMBER | (14) | Capital amount | |
| RESIDUAL_GRNTY_AMOUNT | NUMBER | (14) | Residual guaranty amount | |
| RESIDUAL_CODE | VARCHAR2 | (30) | Residual code | |
| RVI_PREMIUM | NUMBER | (14) | RVI Premium | |
| CREDIT_NATURE | VARCHAR2 | (30) | For revolving line of credit indicates wherer the line is 'New', 'Add' or 'Reduce' | |
| CAPITALIZED_INTEREST | NUMBER | (14) | Amount of capitalized interest | |
| CAPITAL_REDUCTION_PERCENT | NUMBER | (5) | Capital reduction percentage | |
| DATE_PAY_INVESTOR_START | DATE | Investor agreement - date on which payment to investor starts | ||
| PAY_INVESTOR_FREQUENCY | VARCHAR2 | (30) | Investor agreement - frequency of payments to investor | |
| PAY_INVESTOR_EVENT | VARCHAR2 | (30) | Investor agreement - Event which starts investor payments | |
| PAY_INVESTOR_REMITTANCE_DAYS | NUMBER | Investor agreement - investor payment remittance day | ||
| FEE_TYPE | VARCHAR2 | (30) | Fee type for financed fees | |
| SUBSIDY_ID | NUMBER | Unique identifier for subsidy. Foreign key to OKL_SUBSIDIES_B.ID | ||
| SUBSIDY_OVERRIDE_AMOUNT | NUMBER | Subsidy override amount | ||
| PRE_TAX_YIELD | NUMBER | Pre tax yield | ||
| AFTER_TAX_YIELD | NUMBER | After tax yield | ||
| IMPLICIT_INTEREST_RATE | NUMBER | Implicit interest rate | ||
| IMPLICIT_NON_IDC_INTEREST_RATE | NUMBER | Implicit non-IDC interest rate | ||
| PRE_TAX_IRR | NUMBER | Pre-tax IRR | ||
| AFTER_TAX_IRR | NUMBER | After tax IRR | ||
| 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 Pe-tax IRR | ||
| SUB_AFTER_TAX_IRR | NUMBER | Subsidized after tax IRR | ||
| ITEM_INSURANCE_CATEGORY | NUMBER | Denormalized column to capture the item insurance asset category at the time of asset entry | ||
| QTE_ID | NUMBER | Rollover Quote Identifier | ||
| FUNDING_DATE | DATE | Funding Date | ||
| STREAM_TYPE_SUBCLASS | VARCHAR2 | (30) | The subclass of the stream type | |
| DATE_FUNDING_EXPECTED | DATE | Date funding expected | ||
| MANUFACTURER_NAME | VARCHAR2 | (30) | Manufacturer name | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model number | |
| DOWN_PAYMENT_RECEIVER_CODE | VARCHAR2 | (30) | Down payment receiver code | |
| CAPITALIZE_DOWN_PAYMENT_YN | VARCHAR2 | (3) | Flag to indicate whether down payment is capitalized or not | |
| FEE_PURPOSE_CODE | VARCHAR2 | (30) | Fee Purpose Code | |
| TERMINATION_VALUE | NUMBER | Termination value | ||
| EXPECTED_ASSET_COST | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, 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
, UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID
, 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
, PRICE_TYPE
, CURRENCY_CODE
, CURRENCY_CODE_RENEWED
, 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
, OKL_ROW_ID
, OKL_OBJECT_VERSION_NUM
, KLE_ID
, STY_ID
, PRC_CODE
, FCG_CODE
, NTY_CODE
, ESTIMATED_OEC
, LAO_AMOUNT
, TITLE_DATE
, FEE_CHARGE
, LRS_PERCENT
, INITIAL_DIRECT_COST
, PERCENT_STAKE
, PERCENT
, EVERGREEN_PERCENT
, AMOUNT_STAKE
, OCCUPANCY
, COVERAGE
, RESIDUAL_PERCENTAGE
, DATE_LAST_INSPECTION
, DATE_SOLD
, LRV_AMOUNT
, CAPITAL_REDUCTION
, DATE_NEXT_INSPECTION_DUE
, DATE_RESIDUAL_LAST_REVIEW
, DATE_LAST_REAMORTIZATION
, VENDOR_ADVANCE_PAID
, WEIGHTED_AVERAGE_LIFE
, TRADEIN_AMOUNT
, BOND_EQUIVALENT_YIELD
, TERMINATION_PURCHASE_AMOUNT
, REFINANCE_AMOUNT
, YEAR_BUILT
, DELIVERED_DATE
, CREDIT_TENANT_YN
, DATE_LAST_CLEANUP
, YEAR_OF_MANUFACTURE
, COVERAGE_RATIO
, REMARKRTED_AMOUNT
, GROSS_SQUARE_FOOTAGE
, PRESCRIBED_ASSET_YN
, DATE_REMARKETED
, NET_RENTABLE
, REMARKET_MARGIN
, DATE_LETTER_ACCEPTANCE
, REPURCHASED_AMOUNT
, DATE_COMMITMENT_EXPIRATION
, DATE_REPURCHASED
, DATE_APPRAISAL
, RESIDUAL_VALUE
, APPRAISAL_VALUE
, SECURED_DEAL_YN
, GAIN_LOSS
, FLOOR_AMOUNT
, RE_LEASE_YN
, PREVIOUS_CONTRACT
, TRACKED_RESIDUAL
, DATE_TITLE_RECEIVED
, AMOUNT
, OKL_ATTRIBUTE_CATEGORY
, OKL_ATTRIBUTE1
, OKL_ATTRIBUTE2
, OKL_ATTRIBUTE3
, OKL_ATTRIBUTE4
, OKL_ATTRIBUTE5
, OKL_ATTRIBUTE6
, OKL_ATTRIBUTE7
, OKL_ATTRIBUTE8
, OKL_ATTRIBUTE9
, OKL_ATTRIBUTE10
, OKL_ATTRIBUTE11
, OKL_ATTRIBUTE12
, OKL_ATTRIBUTE13
, OKL_ATTRIBUTE14
, OKL_ATTRIBUTE15
, STY_ID_FOR
, CLG_ID
, OKL_CREATED_BY
, OKL_CREATION_DATE
, OKL_LAST_UPDATED_BY
, OKL_LAST_UPDATE_DATE
, OKL_LAST_UPDATE_LOGIN
, DATE_FUNDING
, DATE_FUNDING_REQUIRED
, DATE_ACCEPTED
, DATE_DELIVERY_EXPECTED
, OEC
, CAPITAL_AMOUNT
, RESIDUAL_GRNTY_AMOUNT
, RESIDUAL_CODE
, RVI_PREMIUM
, CREDIT_NATURE
, CAPITALIZED_INTEREST
, CAPITAL_REDUCTION_PERCENT
, DATE_PAY_INVESTOR_START
, PAY_INVESTOR_FREQUENCY
, PAY_INVESTOR_EVENT
, PAY_INVESTOR_REMITTANCE_DAYS
, FEE_TYPE
, SUBSIDY_ID
, SUBSIDY_OVERRIDE_AMOUNT
, PRE_TAX_YIELD
, AFTER_TAX_YIELD
, IMPLICIT_INTEREST_RATE
, IMPLICIT_NON_IDC_INTEREST_RATE
, PRE_TAX_IRR
, AFTER_TAX_IRR
, 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
, ITEM_INSURANCE_CATEGORY
, QTE_ID
, FUNDING_DATE
, STREAM_TYPE_SUBCLASS
, DATE_FUNDING_EXPECTED
, MANUFACTURER_NAME
, MODEL_NUMBER
, DOWN_PAYMENT_RECEIVER_CODE
, CAPITALIZE_DOWN_PAYMENT_YN
, FEE_PURPOSE_CODE
, TERMINATION_VALUE
, EXPECTED_ASSET_COST
FROM APPS.OKL_K_LINES_FULL_V;
APPS
OKC_K_LINES_B
OKC_K_LINES_TL
OKL_K_LINES
APPS
OKL_ACCRUAL_SEC_PVT
- show dependent code
OKL_AM_AMORTIZE_PVT
- show dependent code
OKL_AM_ASSET_DETAILS_CHR_UV
OKL_AM_ASSET_DETAILS_UV
OKL_AM_ASSET_DISPOSE_PVT
- show dependent code
OKL_AM_ASSET_RETURNS_UV
OKL_AM_ASSET_RETURN_PVT
- show dependent code
OKL_AM_ASSET_RETURN_WF
- show dependent code
OKL_AM_ASSET_SALE_UV
OKL_AM_CNTRCT_LN_TRMNT_PVT
- show dependent code
OKL_AM_CREATE_QUOTE_PVT
- show dependent code
OKL_AM_FIXED_ASSET_LOCATION_UV
OKL_AM_QUOTES_WF
- show dependent code
OKL_AM_REPURCHASE_ASSET_PVT
- show dependent code
OKL_AM_RESIDUAL_VALUE_WD_UV
OKL_AM_RMK_BILLING_UV
OKL_AM_RV_WRITEDOWN_PVT
- show dependent code
OKL_AM_SHIPPING_INSTR_PVT
- show dependent code
OKL_AM_TERMNT_INTERFACE_PVT
- show dependent code
OKL_CONTRACT_LINE_ITEM_PVT
- show dependent code
OKL_CONTRACT_LINE_ITEM_PVT
- show dependent code
OKL_CONTRACT_REBOOK_PVT
- show dependent code
OKL_CONTRACT_TOP_LINE_PVT
- show dependent code
OKL_COPY_ASSET_PVT
- show dependent code
OKL_CREDIT_PUB
- show dependent code
OKL_CS_LEASE_RENEWAL_PVT
- show dependent code
OKL_CS_PRINCIPAL_PAYDOWN_PVT
- show dependent code
OKL_EXPENSE_STREAMS_PVT
- show dependent code
OKL_EXT_BILLING_CHARGES_PVT
- show dependent code
OKL_FUNDING_PVT
- show dependent code
OKL_GENERATE_ACCRUALS_PVT
- show dependent code
OKL_ISG_UTILS_PVT
- show dependent code
OKL_LA_PAYMENTS_PVT
- show dependent code
OKL_LA_STREAM_PVT
- show dependent code
OKL_LA_STREAM_PVT
- show dependent code
OKL_MASS_REBOOK_PVT
- show dependent code
OKL_OPEN_INTERFACE_PVT
- show dependent code
OKL_PAYMENT_APPLICATION_PVT
- show dependent code
OKL_PAYMENT_SPLIT_PVT
- show dependent code
OKL_PRICING_PVT
- show dependent code
OKL_PROPERTY_TAX_STATEMENT_PVT
- show dependent code
OKL_PROP_TAX_ADJ_PVT
- show dependent code
OKL_QA_DATA_INTEGRITY
- show dependent code
OKL_QA_DATA_INTEGRITY
- show dependent code
OKL_QA_SECURITIZATION
- show dependent code
OKL_SEEDED_FUNCTIONS_PVT
- show dependent code
OKL_SPLIT_ASSET_COMP_PVT
- show dependent code
OKL_SPLIT_ASSET_PVT
- show dependent code
OKL_SPLIT_CONTRACT_PVT
- show dependent code
OKL_STREAM_GENERATOR_PVT
- show dependent code
OKL_STREAM_GENERATOR_PVT
- show dependent code
OKL_UBB_INTEGRATION_PVT
- show dependent code
OKL_VARIABLE_INTEREST_PVT
- show dependent code
|
|
|
|