View: OKL_FA_DEP_REF_V

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_FA_DEP_REF_V

View Text

SELECT FXL.FA_TRANSACTION_ID OKL_DEPRN_RUN_ID
, FXL.ASSET_BOOK_TYPE_CODE OKL_ASSET_BOOK_TYPE_CODE
, FXL.PERIOD_COUNTER OKL_PERIOD_COUNTER
, FXL.ASSET_ID OKL_ASSET_ID /* OTHER FOREIGN KEYS */
, FXH.KHR_ID OKL_KHR_ID
, FXL.KLE_ID OKL_KLE_ID
, FXL.ASSET_NUMBER OKL_ASSET_NUMBER /* CONTRACT RELATED SOURCES */
, FXH.CONTRACT_NUMBER OKL_CONTRACT_NUMBER
, FXH.CUSTOMER_NAME OKL_CUSTOMER_NAME
, FXH.CUSTOMER_ACCOUNT_NUMBER OKL_CUSTOMER_ACCOUNT_NUMBER
, FXH.CONVERTED_NUMBER OKL_CONVERTED_NUMBER
, FXH.CONTRACT_EFFECTIVE_FROM OKL_CONTRACT_EFFECTIVE_FROM
, FXH.CONTRACT_CURRENCY_CODE OKL_CONTRACT_CURRENCY_CODE
, FXH.SALES_REP_NAME OKL_SALES_REP_NAME
, FXH.PO_ORDER_NUMBER OKL_PO_ORDER_NUMBER
, FXH.VENDOR_PROGRAM_NUMBER OKL_VENDOR_PROGRAM_NUMBER
, FXH.ASSIGNABLE_FLAG OKL_ASSIGNABLE_FLAG
, FXH.CONVERTED_ACCOUNT_FLAG OKL_CONVERTED_ACCOUNT_FLAG
, FXH.ACCRUAL_OVERRIDE_FLAG OKL_KHR_ACCRUAL_OVERRIDE_FLAG /* CONTRACT DFF INFORMATION */
, FXH.KHR_ATTRIBUTE_CATEGORY OKL_KHR_ATTRIBUTE_CATEGORY
, FXH.KHR_ATTRIBUTE1 OKL_KHR_ATTRIBUTE1
, FXH.KHR_ATTRIBUTE2 OKL_KHR_ATTRIBUTE2
, FXH.KHR_ATTRIBUTE3 OKL_KHR_ATTRIBUTE3
, FXH.KHR_ATTRIBUTE4 OKL_KHR_ATTRIBUTE4
, FXH.KHR_ATTRIBUTE5 OKL_KHR_ATTRIBUTE5
, FXH.KHR_ATTRIBUTE6 OKL_KHR_ATTRIBUTE6
, FXH.KHR_ATTRIBUTE7 OKL_KHR_ATTRIBUTE7
, FXH.KHR_ATTRIBUTE8 OKL_KHR_ATTRIBUTE8
, FXH.KHR_ATTRIBUTE9 OKL_KHR_ATTRIBUTE9
, FXH.KHR_ATTRIBUTE10 OKL_KHR_ATTRIBUTE10
, FXH.KHR_ATTRIBUTE11 OKL_KHR_ATTRIBUTE11
, FXH.KHR_ATTRIBUTE12 OKL_KHR_ATTRIBUTE12
, FXH.KHR_ATTRIBUTE13 OKL_KHR_ATTRIBUTE13
, FXH.KHR_ATTRIBUTE14 OKL_KHR_ATTRIBUTE14
, FXH.KHR_ATTRIBUTE15 OKL_KHR_ATTRIBUTE15 /* CUSTOMER DFF INFORMATION */
, FXH.CUST_ATTRIBUTE_CATEGORY OKL_CUST_ATTRIBUTE_CATEGORY
, FXH.CUST_ATTRIBUTE1 OKL_CUST_ATTRIBUTE1
, FXH.CUST_ATTRIBUTE2 OKL_CUST_ATTRIBUTE2
, FXH.CUST_ATTRIBUTE3 OKL_CUST_ATTRIBUTE3
, FXH.CUST_ATTRIBUTE4 OKL_CUST_ATTRIBUTE4
, FXH.CUST_ATTRIBUTE5 OKL_CUST_ATTRIBUTE5
, FXH.CUST_ATTRIBUTE6 OKL_CUST_ATTRIBUTE6
, FXH.CUST_ATTRIBUTE7 OKL_CUST_ATTRIBUTE7
, FXH.CUST_ATTRIBUTE8 OKL_CUST_ATTRIBUTE8
, FXH.CUST_ATTRIBUTE9 OKL_CUST_ATTRIBUTE9
, FXH.CUST_ATTRIBUTE10 OKL_CUST_ATTRIBUTE10
, FXH.CUST_ATTRIBUTE11 OKL_CUST_ATTRIBUTE11
, FXH.CUST_ATTRIBUTE12 OKL_CUST_ATTRIBUTE12
, FXH.CUST_ATTRIBUTE13 OKL_CUST_ATTRIBUTE13
, FXH.CUST_ATTRIBUTE14 OKL_CUST_ATTRIBUTE14
, FXH.CUST_ATTRIBUTE15 OKL_CUST_ATTRIBUTE15 /*PRODUCTS
AND QUALITY RELATED SOURCES */
, FXH.PRODUCT_NAME OKL_PRODUCT_NAME
, FXH.BOOK_CLASSIFICATION_CODE OKL_BOOK_CLASSIFICATION_CODE
, FXH.TAX_OWNER_CODE OKL_TAX_OWNER_CODE
, FXH.INT_CALC_METHOD_CODE OKL_INT_CALC_METHOD_CODE
, FXH.REV_REC_METHOD_CODE OKL_REV_REC_METHOD_CODE /* CONTRACT LINE RELATED INFORMATION */
, FXL.CONTRACT_LINE_NUMBER OKL_CONTRACT_LINE_NUMBER
, FXL.ASSET_BOOK_TYPE_NAME OKL_ASSET_BOOK_TYPE_NAME
, FXL.ASSET_VENDOR_NAME OKL_ASSET_VENDOR_NAME
, FXL.INSTALLED_SITE_ID OKL_INSTALLED_SITE_ID /* ASSET DFF INFORMATION */
, FXL.LINE_ATTRIBUTE_CATEGORY OKL_ASSET_ATTRIBUTE_CATEGORY
, FXL.LINE_ATTRIBUTE1 OKL_ASSET_ATTRIBUTE1
, FXL.LINE_ATTRIBUTE2 OKL_ASSET_ATTRIBUTE2
, FXL.LINE_ATTRIBUTE3 OKL_ASSET_ATTRIBUTE3
, FXL.LINE_ATTRIBUTE4 OKL_ASSET_ATTRIBUTE4
, FXL.LINE_ATTRIBUTE5 OKL_ASSET_ATTRIBUTE5
, FXL.LINE_ATTRIBUTE6 OKL_ASSET_ATTRIBUTE6
, FXL.LINE_ATTRIBUTE7 OKL_ASSET_ATTRIBUTE7
, FXL.LINE_ATTRIBUTE8 OKL_ASSET_ATTRIBUTE8
, FXL.LINE_ATTRIBUTE9 OKL_ASSET_ATTRIBUTE9
, FXL.LINE_ATTRIBUTE10 OKL_ASSET_ATTRIBUTE10
, FXL.LINE_ATTRIBUTE11 OKL_ASSET_ATTRIBUTE11
, FXL.LINE_ATTRIBUTE12 OKL_ASSET_ATTRIBUTE12
, FXL.LINE_ATTRIBUTE13 OKL_ASSET_ATTRIBUTE13
, FXL.LINE_ATTRIBUTE14 OKL_ASSET_ATTRIBUTE14
, FXL.LINE_ATTRIBUTE15 OKL_ASSET_ATTRIBUTE15 /* RENT INVESTOR AGREEMENT RELATED SOURCES */
, FXH.RENT_IA_CONTRACT_NUMBER OKL_RENT_IA_CONTRACT_NUMBER
, FXH.RENT_IA_PRODUCT_NAME OKL_RENT_IA_PRODUCT_NAME
, FXH.RENT_IA_ACCOUNTING_CODE OKL_RENT_IA_ACCOUNTING_CODE /* RESIDUAL INVESTOR AGREEMENT RELATED SOURCES */
, FXH.RES_IA_CONTRACT_NUMBER OKL_RES_IA_CONTRACT_NUMBER
, FXH.RES_IA_PRODUCT_NAME OKL_RES_IA_PRODUCT_NAME
, FXH.RES_IA_ACCOUNTING_CODE OKL_RES_IA_ACCOUNTING_CODE /* EQUIVALENT CODES FOR THE TRANSLATABLE SOURCES */
, FXH.CONTRACT_STATUS_CODE OKL_CONTRACT_STATUS_CODE
, FXL.INVENTORY_ORG_CODE OKL_INVENTORY_ORG_CODE
FROM OKL_EXT_FA_HEADER_SOURCES_B FXH
, OKL_EXT_FA_LINE_SOURCES_B FXL
WHERE FXL.SOURCE_TABLE = 'FA_DEPRN_SUMMARY'
AND FXH.HEADER_EXTENSION_ID = FXL.HEADER_EXTENSION_ID

Columns