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

VIEW: APPS.OKL_ASSETS_V

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

View Type

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


View for OKL_ASSETS_B and OKL_ASSETS_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 the Row while Update Operation.
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.
PARENT_OBJECT_CODE VARCHAR2 (30) Yes Column Indicating the Parent Objec Typer.Refers" OKL_LEASE_QUOTES_ALL_B"' for Parent Object Lease Quote
PARENT_OBJECT_ID NUMBER
Yes Column Indicating the Parent Object Identifier.Refers" OKL_LEASE_QUOTES_ALL_B"' for Parent Object Lease Quote
ASSET_NUMBER VARCHAR2 (15) Yes Asset Number for this Asset.
INSTALL_SITE_ID NUMBER
Yes Installed Site Id for this Item.
STRUCTURED_PRICING VARCHAR2 (30)
Structured Pricing Yes/No.
RATE_TEMPLATE_ID NUMBER

Standard Rate Template Version Id used for pricing of Asset.
RATE_CARD_ID NUMBER

Lease Rate Set Id used for pricing of Asset.
LEASE_RATE_FACTOR NUMBER

Lease Rate Factor for this Asset.
TARGET_ARREARS VARCHAR2 (30)
TARGET_ARREARS flag.LOOKUP_TYPE 'OKL_YES_NO'
OEC NUMBER

Original Equipment Cost of Item.
OEC_PERCENTAGE NUMBER

Original Equipment Cost in terms of Percentage.
END_OF_TERM_VALUE_DEFAULT NUMBER

Default Value for End OF Term Version Picked on Quote.
END_OF_TERM_VALUE NUMBER

Overridden Value for End OF Term Version.
SHORT_DESCRIPTION VARCHAR2 (240)
User entered short description.
DESCRIPTION VARCHAR2 (1995)
User entered multiline description.
COMMENTS VARCHAR2 (1995)
User Comments.
ORIG_ASSET_ID NUMBER

Original Asset identifier
TARGET_AMOUNT NUMBER

Target Amount for Asset.
TARGET_FREQUENCY VARCHAR2 (30)
Target Frequency for payment defined for Asset.Lookup Type "OKL_FREQUENCY".
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
,      PARENT_OBJECT_CODE
,      PARENT_OBJECT_ID
,      ASSET_NUMBER
,      INSTALL_SITE_ID
,      STRUCTURED_PRICING
,      RATE_TEMPLATE_ID
,      RATE_CARD_ID
,      LEASE_RATE_FACTOR
,      TARGET_ARREARS
,      OEC
,      OEC_PERCENTAGE
,      END_OF_TERM_VALUE_DEFAULT
,      END_OF_TERM_VALUE
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      COMMENTS
,      ORIG_ASSET_ID
,      TARGET_AMOUNT
,      TARGET_FREQUENCY
FROM APPS.OKL_ASSETS_V;

Dependencies

[top of page]

APPS.OKL_ASSETS_V references the following:

SchemaAPPS
SynonymOKL_ASSETS_B
SynonymOKL_ASSETS_TL
APPS.OKL_ASSETS_V is referenced by following:

SchemaAPPS
Package BodyOKL_ASS_PVT - show dependent code
Package BodyOKL_LEASE_QUOTE_ASSET_PVT - show dependent code
Package BodyOKL_LEASE_QUOTE_PRICING_PVT - show dependent code
Package BodyOKL_LEASE_QUOTE_PVT - show dependent code
Package BodyOKL_QUOTE_TO_CONTRACT_PVT - show dependent code