VIEW: APPS.OKL_POOL_ASSETS_UV

Source

View Text - Preformatted

SELECT CLET.DNZ_CHR_ID DNZ_CHR_ID , CLET.ID KLE_ID , ASTV.ASSET_ID ASSET_ID , ASTV.ASSET_NUMBER ASSET_NUMBER , ASTV.MODEL_NUMBER MODEL_NUMBER , ASTV.MANUFACTURER_NAME MANUFACTURER_NAME , SITM.ID1 ITEM_ID1 , OKVV.ID1 VENDOR_ID1 , KLET.OEC OEC , KLET.RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE FROM OKC_K_ITEMS CIMA,OKX_ASSETS_V ASTV,OKC_K_LINES_B CLEB,OKC_LINE_STYLES_B LSEB,OKC_K_ITEMS CITM,OKX_SYSTEM_ITEMS_V SITM,OKC_K_LINES_B CLEI,OKC_LINE_STYLES_B LSEI,OKC_K_PARTY_ROLES_B CPLB,OKX_VENDORS_V OKVV,OKC_K_LINES_B CLET,OKL_K_LINES KLET,OKC_LINE_STYLES_B LSET,OKL_K_HEADERS KHR WHERE CIMA.OBJECT1_ID1 = ASTV.ID1 AND CIMA.OBJECT1_ID2 = ASTV.ID2 AND CIMA.JTOT_OBJECT1_CODE = 'OKX_ASSET' AND CIMA.CLE_ID = CLEB.ID AND LSEB.ID = CLEB.LSE_ID AND LSEB.LTY_CODE = 'FIXED_ASSET' AND CITM.OBJECT1_ID1 = SITM.ID1 AND CITM.OBJECT1_ID2 = to_char(SITM.ID2) AND CITM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM' AND CITM.CLE_ID = CLEI.ID AND LSEI.ID = CLEI.LSE_ID AND LSEI.LTY_CODE = 'ITEM' AND CLEI.CLE_ID = CLEB.CLE_ID AND CLEI.DNZ_CHR_ID = CLEB.DNZ_CHR_ID AND CPLB.DNZ_CHR_ID(+) = CLEI.DNZ_CHR_ID AND CPLB.CLE_ID(+) = CLEI.ID AND CPLB.OBJECT1_ID1 = OKVV.ID1(+) AND CPLB.OBJECT1_ID2 = OKVV.ID2(+) AND CPLB.RLE_CODE(+) = 'OKL_VENDOR' AND CLET.ID = CLEB.CLE_ID AND LSET.ID = CLET.LSE_ID AND LSET.LTY_CODE = 'FREE_FORM1' AND KLET.ID = CLET.ID AND KHR.ID = CLEB.DNZ_CHR_ID AND KHR.DEAL_TYPE <> 'LOAN' UNION SELECT CLET.DNZ_CHR_ID DNZ_CHR_ID , CLET.ID KLE_ID, null ASSET_ID , null ASSET_NUMBER , null MODEL_NUMBER , null MANUFACTURER_NAME , SITM.ID1 ITEM_ID1 , OKVV.ID1 VENDOR_ID1 , KLET.OEC OEC , KLET.RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE FROM OKC_K_ITEMS CIMA, OKC_K_LINES_B CLEB, OKC_LINE_STYLES_B LSEB, OKC_K_ITEMS CITM, OKX_SYSTEM_ITEMS_V SITM, OKC_K_LINES_B CLEI, OKC_LINE_STYLES_B LSEI, OKC_K_PARTY_ROLES_B CPLB, OKX_VENDORS_V OKVV, OKC_K_LINES_B CLET, OKL_K_LINES KLET, OKC_LINE_STYLES_B LSET, OKL_K_HEADERS KHR WHERE CIMA.CLE_ID = CLEB.ID AND LSEB.ID = CLEB.LSE_ID AND LSEB.LTY_CODE = 'FIXED_ASSET' AND CITM.OBJECT1_ID1 = SITM.ID1 AND CITM.OBJECT1_ID2 = to_char(SITM.ID2) AND CITM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM' AND CITM.CLE_ID = CLEI.ID AND LSEI.ID = CLEI.LSE_ID AND LSEI.LTY_CODE = 'ITEM' AND CLEI.CLE_ID = CLEB.CLE_ID AND CLEI.DNZ_CHR_ID = CLEB.DNZ_CHR_ID AND CPLB.DNZ_CHR_ID(+) = CLEI.DNZ_CHR_ID AND CPLB.CLE_ID(+) = CLEI.ID AND CPLB.OBJECT1_ID1 = OKVV.ID1(+) AND CPLB.OBJECT1_ID2 = OKVV.ID2(+) AND CPLB.RLE_CODE(+) = 'OKL_VENDOR' AND CLET.ID = CLEB.CLE_ID AND LSET.ID = CLET.LSE_ID AND LSET.LTY_CODE = 'FREE_FORM1' AND KLET.ID = CLET.ID AND KHR.ID = CLEB.DNZ_CHR_ID AND KHR.DEAL_TYPE = 'LOAN'

View Text - HTML Formatted

SELECT CLET.DNZ_CHR_ID DNZ_CHR_ID
, CLET.ID KLE_ID
, ASTV.ASSET_ID ASSET_ID
, ASTV.ASSET_NUMBER ASSET_NUMBER
, ASTV.MODEL_NUMBER MODEL_NUMBER
, ASTV.MANUFACTURER_NAME MANUFACTURER_NAME
, SITM.ID1 ITEM_ID1
, OKVV.ID1 VENDOR_ID1
, KLET.OEC OEC
, KLET.RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE
FROM OKC_K_ITEMS CIMA
, OKX_ASSETS_V ASTV
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSEB
, OKC_K_ITEMS CITM
, OKX_SYSTEM_ITEMS_V SITM
, OKC_K_LINES_B CLEI
, OKC_LINE_STYLES_B LSEI
, OKC_K_PARTY_ROLES_B CPLB
, OKX_VENDORS_V OKVV
, OKC_K_LINES_B CLET
, OKL_K_LINES KLET
, OKC_LINE_STYLES_B LSET
, OKL_K_HEADERS KHR
WHERE CIMA.OBJECT1_ID1 = ASTV.ID1
AND CIMA.OBJECT1_ID2 = ASTV.ID2
AND CIMA.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND CIMA.CLE_ID = CLEB.ID
AND LSEB.ID = CLEB.LSE_ID
AND LSEB.LTY_CODE = 'FIXED_ASSET'
AND CITM.OBJECT1_ID1 = SITM.ID1
AND CITM.OBJECT1_ID2 = TO_CHAR(SITM.ID2)
AND CITM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'
AND CITM.CLE_ID = CLEI.ID
AND LSEI.ID = CLEI.LSE_ID
AND LSEI.LTY_CODE = 'ITEM'
AND CLEI.CLE_ID = CLEB.CLE_ID
AND CLEI.DNZ_CHR_ID = CLEB.DNZ_CHR_ID
AND CPLB.DNZ_CHR_ID(+) = CLEI.DNZ_CHR_ID
AND CPLB.CLE_ID(+) = CLEI.ID
AND CPLB.OBJECT1_ID1 = OKVV.ID1(+)
AND CPLB.OBJECT1_ID2 = OKVV.ID2(+)
AND CPLB.RLE_CODE(+) = 'OKL_VENDOR'
AND CLET.ID = CLEB.CLE_ID
AND LSET.ID = CLET.LSE_ID
AND LSET.LTY_CODE = 'FREE_FORM1'
AND KLET.ID = CLET.ID
AND KHR.ID = CLEB.DNZ_CHR_ID
AND KHR.DEAL_TYPE <> 'LOAN' UNION SELECT CLET.DNZ_CHR_ID DNZ_CHR_ID
, CLET.ID KLE_ID
, NULL ASSET_ID
, NULL ASSET_NUMBER
, NULL MODEL_NUMBER
, NULL MANUFACTURER_NAME
, SITM.ID1 ITEM_ID1
, OKVV.ID1 VENDOR_ID1
, KLET.OEC OEC
, KLET.RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE
FROM OKC_K_ITEMS CIMA
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSEB
, OKC_K_ITEMS CITM
, OKX_SYSTEM_ITEMS_V SITM
, OKC_K_LINES_B CLEI
, OKC_LINE_STYLES_B LSEI
, OKC_K_PARTY_ROLES_B CPLB
, OKX_VENDORS_V OKVV
, OKC_K_LINES_B CLET
, OKL_K_LINES KLET
, OKC_LINE_STYLES_B LSET
, OKL_K_HEADERS KHR
WHERE CIMA.CLE_ID = CLEB.ID
AND LSEB.ID = CLEB.LSE_ID
AND LSEB.LTY_CODE = 'FIXED_ASSET'
AND CITM.OBJECT1_ID1 = SITM.ID1
AND CITM.OBJECT1_ID2 = TO_CHAR(SITM.ID2)
AND CITM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'
AND CITM.CLE_ID = CLEI.ID
AND LSEI.ID = CLEI.LSE_ID
AND LSEI.LTY_CODE = 'ITEM'
AND CLEI.CLE_ID = CLEB.CLE_ID
AND CLEI.DNZ_CHR_ID = CLEB.DNZ_CHR_ID
AND CPLB.DNZ_CHR_ID(+) = CLEI.DNZ_CHR_ID
AND CPLB.CLE_ID(+) = CLEI.ID
AND CPLB.OBJECT1_ID1 = OKVV.ID1(+)
AND CPLB.OBJECT1_ID2 = OKVV.ID2(+)
AND CPLB.RLE_CODE(+) = 'OKL_VENDOR'
AND CLET.ID = CLEB.CLE_ID
AND LSET.ID = CLET.LSE_ID
AND LSET.LTY_CODE = 'FREE_FORM1'
AND KLET.ID = CLET.ID
AND KHR.ID = CLEB.DNZ_CHR_ID
AND KHR.DEAL_TYPE = 'LOAN'