FND Design Data [Home] [Help]

View: OKL_FEES_V

Product: OKL - Leasing and Finance Management
Description: View for OKL_FEES_B and OKL_FEES_TL
Implementation/DBA Data: ViewAPPS.OKL_FEES_V
View Text

SELECT FEE.ROWID ROW_ID
, FEE.ID ID
, FEE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FEE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, FEE.ATTRIBUTE1 ATTRIBUTE1
, FEE.ATTRIBUTE2 ATTRIBUTE2
, FEE.ATTRIBUTE3 ATTRIBUTE3
, FEE.ATTRIBUTE4 ATTRIBUTE4
, FEE.ATTRIBUTE5 ATTRIBUTE5
, FEE.ATTRIBUTE6 ATTRIBUTE6
, FEE.ATTRIBUTE7 ATTRIBUTE7
, FEE.ATTRIBUTE8 ATTRIBUTE8
, FEE.ATTRIBUTE9 ATTRIBUTE9
, FEE.ATTRIBUTE10 ATTRIBUTE10
, FEE.ATTRIBUTE11 ATTRIBUTE11
, FEE.ATTRIBUTE12 ATTRIBUTE12
, FEE.ATTRIBUTE13 ATTRIBUTE13
, FEE.ATTRIBUTE14 ATTRIBUTE14
, FEE.ATTRIBUTE15 ATTRIBUTE15
, FEE.CREATED_BY CREATED_BY
, FEE.CREATION_DATE CREATION_DATE
, FEE.LAST_UPDATED_BY LAST_UPDATED_BY
, FEE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FEE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FEE.PARENT_OBJECT_CODE PARENT_OBJECT_CODE
, FEE.PARENT_OBJECT_ID PARENT_OBJECT_ID
, FEE.STREAM_TYPE_ID STREAM_TYPE_ID
, FEE.FEE_TYPE FEE_TYPE
, FEE.STRUCTURED_PRICING STRUCTURED_PRICING
, FEE.RATE_TEMPLATE_ID RATE_TEMPLATE_ID
, FEE.RATE_CARD_ID RATE_CARD_ID
, FEE.LEASE_RATE_FACTOR LEASE_RATE_FACTOR
, FEE.TARGET_ARREARS TARGET_ARREARS
, FEE.EFFECTIVE_FROM EFFECTIVE_FROM
, FEE.EFFECTIVE_TO EFFECTIVE_TO
, FEE.SUPPLIER_ID SUPPLIER_ID
, FEE.ROLLOVER_QUOTE_ID ROLLOVER_QUOTE_ID
, FEE.INITIAL_DIRECT_COST INITIAL_DIRECT_COST
, FEE.FEE_AMOUNT FEE_AMOUNT
, FEE.TARGET_AMOUNT TARGET_AMOUNT
, FEE.TARGET_FREQUENCY TARGET_FREQUENCY
, FEE.PAYMENT_TYPE_ID PAYMENT_TYPE_ID
, FEET.SHORT_DESCRIPTION SHORT_DESCRIPTION
, FEET.DESCRIPTION DESCRIPTION
, FEET.COMMENTS COMMENTS
, FEE.FEE_PURPOSE_CODE FEE_PURPOSE_CODE
FROM OKL_FEES_B FEE
, OKL_FEES_TL FEET
WHERE FEE.ID = FEET.ID
AND FEET.LANGUAGE = USERENV('LANG')

Columns

Name
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
STREAM_TYPE_ID
FEE_TYPE
STRUCTURED_PRICING
RATE_TEMPLATE_ID
RATE_CARD_ID
LEASE_RATE_FACTOR
TARGET_ARREARS
EFFECTIVE_FROM
EFFECTIVE_TO
SUPPLIER_ID
ROLLOVER_QUOTE_ID
INITIAL_DIRECT_COST
FEE_AMOUNT
TARGET_AMOUNT
TARGET_FREQUENCY
PAYMENT_TYPE_ID
SHORT_DESCRIPTION
DESCRIPTION
COMMENTS
FEE_PURPOSE_CODE