DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_LEASE_QUOTES_V

Object Details
Object Name: OKL_LEASE_QUOTES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LEASE_QUOTES_V
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


View for okl_lease_quotes_b and okl_lease_quotes_tl


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier.
ID NUMBER
Yes Primary Key Column.
OBJECT_VERSION_NUMBER NUMBER
Yes Column used for locking records during updates
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
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
REFERENCE_NUMBER VARCHAR2 (150) Yes Lease Quote Reference Number.
STATUS VARCHAR2 (30) Yes Lease Quote Status.
PARENT_OBJECT_CODE VARCHAR2 (30) Yes Parent Object Code for Lease Quote.Either Lease Opp or Lease App Reference.
PARENT_OBJECT_ID NUMBER
Yes Parent Object Identifier.
VALID_FROM DATE

Valid From date for Lease Quote.
VALID_TO DATE

Valid To date for Lease Quote.
CUSTOMER_BOOKCLASS VARCHAR2 (30)
Customer Book Class for Lease Quote.
CUSTOMER_TAXOWNER VARCHAR2 (30)
Customer Tax Owner flag
EXPECTED_START_DATE DATE
Yes Expected Start Date for Lease Quote.
EXPECTED_FUNDING_DATE DATE

Expected Funding Date for Lease Quote.
EXPECTED_DELIVERY_DATE DATE

Expected Delivery Date for Lease Quote.
PRICING_METHOD VARCHAR2 (30) Yes Pricing Method Selected for Lease Quote.Sourced from Lookup Type "OKL_PRICING_METHOD".
TERM NUMBER
Yes Term Value for Lease Quote.
PRODUCT_ID NUMBER
Yes Product Identifier selected for Lease Quote.
END_OF_TERM_OPTION_ID NUMBER
Yes End Of Term Option Identifier selected for Lease Quote.
STRUCTURED_PRICING VARCHAR2 (30)
Structured Pricing flag for Lease Quote.Sourced from Lookup Type "OKL_YES_NO".
LINE_LEVEL_PRICING VARCHAR2 (30)
Line Level Pricing flag for Pricing.
RATE_TEMPLATE_ID NUMBER

Standard Rate Template Versiomn Identifier selected for Lease Quote Pricing.
RATE_CARD_ID NUMBER

Lease Rate Set Version Identifier selected for Lease Quote Pricing.
LEASE_RATE_FACTOR NUMBER

Lease Rate Factor Value for Lease Quote Pricing
TARGET_RATE_TYPE VARCHAR2 (30)
Target Rate Type value.
TARGET_RATE NUMBER

Target Rate Value.
TARGET_AMOUNT NUMBER

Target Amount.
TARGET_FREQUENCY VARCHAR2 (30)
Target Frequency value.Sourced from Lookup Type "OKL_FREQUENCY".
TARGET_ARREARS_YN VARCHAR2 (3)
Flag Indicating Target Arrears for Lease Quote.
TARGET_PERIODS NUMBER

Target Periods Value for Lease Quote.
IIR NUMBER

Implicit Interest Rate value.
BOOKING_YIELD NUMBER

Booking Yield.
PIRR NUMBER

Pre-Tax Internal Rate of Return
AIRR NUMBER

After-Tax Internal Rate of Return
SUB_IIR NUMBER

Subsidized Implicit Interest Rate.
SUB_BOOKING_YIELD NUMBER

Subsidized Booking Yield value.
SUB_PIRR NUMBER

Subsidized Pre-Tax Internal Rate of Return.
SUB_AIRR NUMBER

Subsidized After-Tax Internal Rate of Return.
USAGE_CATEGORY VARCHAR2 (30)
Usage Category.
USAGE_INDUSTRY_CLASS VARCHAR2 (30)
Usage Industry Class.
USAGE_INDUSTRY_CODE VARCHAR2 (30)
Usage Industry Code.
USAGE_AMOUNT NUMBER

Usage Amount.
USAGE_LOCATION_ID NUMBER

Usage Location Identifier.
PROPERTY_TAX_APPLICABLE VARCHAR2 (30)
Property Tax Applicable flag.
PROPERTY_TAX_BILLING_TYPE VARCHAR2 (30)
Property Tax Billing Type value.
UPFRONT_TAX_TREATMENT VARCHAR2 (30)
Upfront Tax Treatment.
UPFRONT_TAX_STREAM_TYPE NUMBER

Upfront Tax Stream Type Identifier.
TRANSFER_OF_TITLE VARCHAR2 (30)
Transfer of Title.
AGE_OF_EQUIPMENT NUMBER

Age of Equipment.
PURCHASE_OF_LEASE VARCHAR2 (30)
Flag indicating the Purchase of Lease.
SALE_AND_LEASE_BACK VARCHAR2 (30)
Flag indicating Sale and lease back.
INTEREST_DISCLOSED VARCHAR2 (30)
Flag indicating wheather Interest should be disclosed or not.
PRIMARY_QUOTE VARCHAR2 (30)
Flag indicating the Lease Quote is Primary Quote for Parent
SHORT_DESCRIPTION VARCHAR2 (240)
User entered, single-line description
DESCRIPTION VARCHAR2 (1995)
User entered, multi-line comments (free form notes)
COMMENTS VARCHAR2 (1995)
User entered, multi-line comments (free form notes)
LEGAL_ENTITY_ID NUMBER

Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES
LINE_INTENDED_USE VARCHAR2 (240)
Intended use for tax
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      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
,      REFERENCE_NUMBER
,      STATUS
,      PARENT_OBJECT_CODE
,      PARENT_OBJECT_ID
,      VALID_FROM
,      VALID_TO
,      CUSTOMER_BOOKCLASS
,      CUSTOMER_TAXOWNER
,      EXPECTED_START_DATE
,      EXPECTED_FUNDING_DATE
,      EXPECTED_DELIVERY_DATE
,      PRICING_METHOD
,      TERM
,      PRODUCT_ID
,      END_OF_TERM_OPTION_ID
,      STRUCTURED_PRICING
,      LINE_LEVEL_PRICING
,      RATE_TEMPLATE_ID
,      RATE_CARD_ID
,      LEASE_RATE_FACTOR
,      TARGET_RATE_TYPE
,      TARGET_RATE
,      TARGET_AMOUNT
,      TARGET_FREQUENCY
,      TARGET_ARREARS_YN
,      TARGET_PERIODS
,      IIR
,      BOOKING_YIELD
,      PIRR
,      AIRR
,      SUB_IIR
,      SUB_BOOKING_YIELD
,      SUB_PIRR
,      SUB_AIRR
,      USAGE_CATEGORY
,      USAGE_INDUSTRY_CLASS
,      USAGE_INDUSTRY_CODE
,      USAGE_AMOUNT
,      USAGE_LOCATION_ID
,      PROPERTY_TAX_APPLICABLE
,      PROPERTY_TAX_BILLING_TYPE
,      UPFRONT_TAX_TREATMENT
,      UPFRONT_TAX_STREAM_TYPE
,      TRANSFER_OF_TITLE
,      AGE_OF_EQUIPMENT
,      PURCHASE_OF_LEASE
,      SALE_AND_LEASE_BACK
,      INTEREST_DISCLOSED
,      PRIMARY_QUOTE
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      COMMENTS
,      LEGAL_ENTITY_ID
,      LINE_INTENDED_USE
FROM APPS.OKL_LEASE_QUOTES_V;

Dependencies

[top of page]

APPS.OKL_LEASE_QUOTES_V references the following:

SchemaAPPS
SynonymOKL_LEASE_QUOTES_B
SynonymOKL_LEASE_QUOTES_TL
APPS.OKL_LEASE_QUOTES_V is referenced by following:

SchemaAPPS
Package BodyOKL_EC_UPTAKE_PVT - show dependent code
Package BodyOKL_LEASE_APP_PVT - show dependent code
Package BodyOKL_LEASE_QUOTE_CASHFLOW_PVT - show dependent code
Package BodyOKL_LEASE_QUOTE_PRICING_PVT - show dependent code
Package BodyOKL_LEASE_QUOTE_PVT - show dependent code
Package BodyOKL_LEASE_QUOTE_SUBPOOL_PVT - show dependent code
Package BodyOKL_LEASE_QUOTE_WORKFLOW_PVT - show dependent code
Package BodyOKL_LSQ_PVT - show dependent code
Package BodyOKL_QUOTE_TO_CONTRACT_PVT - show dependent code