VIEW: APPS.OKL_LA_REAL_ESTATE_UV

Source

View Text - Preformatted

SELECT cle.id id, to_char(KLE.INITIAL_DIRECT_COST) INITIAL_DIRECT_COST, to_char(KLE.OCCUPANCY) OCCUPANCY, to_char(KLE.COVERAGE) COVERAGE, KLE.DATE_LAST_INSPECTION DATE_LAST_INSPECTION, KLE.DATE_NEXT_INSPECTION_DUE DATE_NEXT_INSPECTION_DUE, to_char(KLE.WEIGHTED_AVERAGE_LIFE) WEIGHTED_AVERAGE_LIFE, to_char(KLE.BOND_EQUIVALENT_YIELD) BOND_EQUIVALENT_YIELD, to_char(KLE.REFINANCE_AMOUNT) REFINANCE_AMOUNT, TO_CHAR(NULL) YEAR_BUILT, KLE.CREDIT_TENANT_YN CREDIT_TENANT_YN, KLE.SECURED_DEAL_YN SECURED_DEAL_YN, to_char(KLE.AMOUNT) AMOUNT, kLE.PRC_CODE PRC_CODE, KLE.DATE_APPRAISAL DATE_APPRAISAL, to_char(KLE.APPRAISAL_VALUE) APPRAISAL_VALUE, to_char(KLE.GROSS_SQUARE_FOOTAGE) GROSS_SQUARE_FOOTAGE, to_char(KLE.NET_RENTABLE) NET_RENTABLE, KLE.DATE_LETTER_ACCEPTANCE DATE_LETTER_ACCEPTANCE, KLE.DATE_COMMITMENT_EXPIRATION DATE_COMMITMENT_EXPIRATION, cpl.object1_id1 VEND_ID1, cpl.object1_id2 VEND_ID2, pv.VENDOR_NAME VENDOR_NAME, TO_CHAR(NULL) ITEM_ID1, TO_CHAR(NULL) ITEM_ID2, TO_CHAR(NULL) ITEM_NAME, cle.DNZ_CHR_ID DNZ_CHR_ID, cpl.id PARTY_ID, cle.lse_id lse_id, tl.name asset_number, tl.item_description description, TO_CHAR(NULL) party_site_id, TO_CHAR(NULL) ib_address, to_char(null) chr_party_id, TO_CHAR(NULL) modelid, TO_CHAR(NULL) faid, TO_CHAR(NULL) IBID, to_char(null) KHRCURRENCYCODE, to_char(null) ORGID FROM OKL_K_LINES KLE,OKC_K_LINES_B CLE,OKC_K_LINES_TL TL,OKC_K_LINES_B CLE_ITEM,OKC_K_PARTY_ROLES_B CPL,PO_VENDORS PV WHERE cle.id = cle.id AND tl.language = USERENV('LANG') AND kle.id = cle.id AND tl.id = cle.id and cle.id = cle_item.cle_id and cle_item.lse_id = 34 and cle_item.id = cpl.cle_id (+) and cle_item.dnz_chr_id = cpl.dnz_chr_id(+) and cpl.rle_code(+) = 'OKL_VENDOR' and cpl.jtot_object1_code(+) = 'OKX_VENDOR' and cpl.object1_id1 = pv.vendor_id (+)

View Text - HTML Formatted

SELECT CLE.ID ID
, TO_CHAR(KLE.INITIAL_DIRECT_COST) INITIAL_DIRECT_COST
, TO_CHAR(KLE.OCCUPANCY) OCCUPANCY
, TO_CHAR(KLE.COVERAGE) COVERAGE
, KLE.DATE_LAST_INSPECTION DATE_LAST_INSPECTION
, KLE.DATE_NEXT_INSPECTION_DUE DATE_NEXT_INSPECTION_DUE
, TO_CHAR(KLE.WEIGHTED_AVERAGE_LIFE) WEIGHTED_AVERAGE_LIFE
, TO_CHAR(KLE.BOND_EQUIVALENT_YIELD) BOND_EQUIVALENT_YIELD
, TO_CHAR(KLE.REFINANCE_AMOUNT) REFINANCE_AMOUNT
, TO_CHAR(NULL) YEAR_BUILT
, KLE.CREDIT_TENANT_YN CREDIT_TENANT_YN
, KLE.SECURED_DEAL_YN SECURED_DEAL_YN
, TO_CHAR(KLE.AMOUNT) AMOUNT
, KLE.PRC_CODE PRC_CODE
, KLE.DATE_APPRAISAL DATE_APPRAISAL
, TO_CHAR(KLE.APPRAISAL_VALUE) APPRAISAL_VALUE
, TO_CHAR(KLE.GROSS_SQUARE_FOOTAGE) GROSS_SQUARE_FOOTAGE
, TO_CHAR(KLE.NET_RENTABLE) NET_RENTABLE
, KLE.DATE_LETTER_ACCEPTANCE DATE_LETTER_ACCEPTANCE
, KLE.DATE_COMMITMENT_EXPIRATION DATE_COMMITMENT_EXPIRATION
, CPL.OBJECT1_ID1 VEND_ID1
, CPL.OBJECT1_ID2 VEND_ID2
, PV.VENDOR_NAME VENDOR_NAME
, TO_CHAR(NULL) ITEM_ID1
, TO_CHAR(NULL) ITEM_ID2
, TO_CHAR(NULL) ITEM_NAME
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, CPL.ID PARTY_ID
, CLE.LSE_ID LSE_ID
, TL.NAME ASSET_NUMBER
, TL.ITEM_DESCRIPTION DESCRIPTION
, TO_CHAR(NULL) PARTY_SITE_ID
, TO_CHAR(NULL) IB_ADDRESS
, TO_CHAR(NULL) CHR_PARTY_ID
, TO_CHAR(NULL) MODELID
, TO_CHAR(NULL) FAID
, TO_CHAR(NULL) IBID
, TO_CHAR(NULL) KHRCURRENCYCODE
, TO_CHAR(NULL) ORGID
FROM OKL_K_LINES KLE
, OKC_K_LINES_B CLE
, OKC_K_LINES_TL TL
, OKC_K_LINES_B CLE_ITEM
, OKC_K_PARTY_ROLES_B CPL
, PO_VENDORS PV
WHERE CLE.ID = CLE.ID
AND TL.LANGUAGE = USERENV('LANG')
AND KLE.ID = CLE.ID
AND TL.ID = CLE.ID
AND CLE.ID = CLE_ITEM.CLE_ID
AND CLE_ITEM.LSE_ID = 34
AND CLE_ITEM.ID = CPL.CLE_ID (+)
AND CLE_ITEM.DNZ_CHR_ID = CPL.DNZ_CHR_ID(+)
AND CPL.RLE_CODE(+) = 'OKL_VENDOR'
AND CPL.JTOT_OBJECT1_CODE(+) = 'OKX_VENDOR'
AND CPL.OBJECT1_ID1 = PV.VENDOR_ID (+)