Product: | OKL - Lease and Finance Management |
---|---|
Description: | View for OKL_FEES_B and OKL_FEES_TL |
Implementation/DBA Data: | APPS.OKL_FEES_V |
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')