OKL Contract Lines Financial

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Lease and Finance Management
Source
Contract Lines Financial Report
Short Name
OKLLNFINEXT
DB package
OKL_K_LINE_FIN_EXT_PVT

SQL 7 lines

                SELECT LFE.*, RMA.DESCRIPTION INSTRUMENT_NUMBER, RMA.BANK BANK_NAME 
                FROM 
		OKL_CNTRCT_LINE_FIN_EXTRACT_T LFE, OKX_RCPT_METHOD_ACCOUNTS_V RMA
		WHERE REQUEST_ID = :L_REQUEST_ID 
            AND CONTRACT_LINE_TYPE_NAME = 'Financial Asset Line' AND RMA.ID1(+) = LFE.ASSET_BILLING_BANK_ACCT_ID
            ORDER BY CONTRACT_CURRENCY, line_supplier, CONTRACT_BOOK_CLASSIFICATION, fa_corp_category, CONTRACT_NUMBER

Parameters 17