View: OKL_CS_AST_ADDONS_UV

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

View Text

SELECT A.PARENT_LINE_ID PARENT_LINE_ID
, A.ASSET_NUMBER ASSET_NUMBER
, F.NAME NAME
, F.DESCRIPTION DESCRIPTION
FROM OKX_ASSET_LINES_V A
, OKC_K_LINES_B B
, OKC_LINE_STYLES_B ST_1
, OKC_K_LINES_B C
, OKC_K_LINES_B D
, OKC_K_ITEMS_V E
, OKX_SYSTEM_ITEMS_V F
WHERE B.ID = A.PARENT_LINE_ID
AND C.CLE_ID = B.ID
AND C.LSE_ID = ST_1.ID
AND ST_1.LTY_CODE = 'ITEM'
AND D.CLE_ID = C.ID
AND E.CLE_ID = D.ID
AND TO_CHAR(F.ID1) = E.OBJECT1_ID1
AND TO_CHAR(F.ID2) = E.OBJECT1_ID2

Columns