VIEW: APPS.OKL_BPD_BATCH_CONT_LINES_UV

Source

View Text - Preformatted

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 = '#'

View Text - HTML Formatted

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 = '#'