VIEW: APPS.OKL_CS_AST_ADDONS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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