eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKL_BPD_BATCH_CONT_LINES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_BATCH_CONT_LINES_UV

View Text

SELECT BTC.ID
, BTC.NAME
, BTC.TRX_STATUS_CODE
, IH.ID
, IH.IRM_ID
, IL.CNR_ID
, 'NULL'
, IH.CURRENCY_CODE
, IH.CHECK_NUMBER
, IH.DATE_EFFECTIVE
, IH.RCPT_STATUS_CODE
, IH.AMOUNT
, IH.ILE_ID
, IL.KHR_ID
, CKH.CONTRACT_NUMBER
, XPY.PARTY_NUMBER
FROM OKX_PARTIES_V XPY
, OKC_K_HEADERS_B CKH
, OKC_K_PARTY_ROLES_V CPR
, OKL_TRX_CSH_BATCH_V BTC
, OKL_TRX_CSH_RCPT_ALL_B IH
, OKL_TXL_RCPT_APPS_ALL_B IL
WHERE BTC.ID = IH.BTC_ID
AND IH.ID = IL.RCT_ID_DETAILS
AND IL.KHR_ID = DNZ_CHR_ID
AND IL.KHR_ID = CKH.ID
AND RLE_CODE = 'LESSEE'
AND XPY.ID1 = CPR.OBJECT1_ID1
AND XPY.ID2 = '#'

Columns

Name
BTC_ID
BTC_NAME
BTC_STATUS
ID
IRM_ID
CONSOLIDATED_INVOICE_ID
CONSOLIDATED_INVOICE_NUMBER
CURRENCY_CODE
CHECK_NUMBER
RECEIPT_DATE
RCPT_STATUS_CODE
AMOUNT
ILE_ID
KHR_ID
CONTRACT_NUMBER
CUSTOMER_NUMBER