VIEW: APPS.OKL_SPLIT_ASSET_COMP_UV

Source

View Text - Preformatted

SELECT tdas.ID ID ,cle.cle_id TOP_CLE_ID ,tal.KLE_ID FA_CLE_ID ,tdas.TAL_ID TAL_ID ,tdas.ASSET_NUMBER ASSET_NUMBER ,tdas.DESCRIPTION DESCRIPTION ,tdas.QUANTITY QUANTITY ,tdas.COST COST ,tdas.SPLIT_PERCENT SPLIT_PERCENT ,tdas.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,i.NAME INVENTORY_ITEM_NAME ,i.DESCRIPTION INVENTORY_ITEM_DESCRIPTION ,i.ID2 INVENTORY_ORG_ID FROM OKL_TXD_ASSETS_V TDAS,OKL_TXL_ASSETS_B TAL,OKX_SYSTEM_ITEMS_V I,OKC_K_LINES_B CLE WHERE cle.id = tal.kle_id and tdas.INVENTORY_ITEM_ID = i.ID1 and tal.ID = tdas.TAL_ID and tal.TAL_TYPE = 'ALI' and EXISTS (select '1' from OKL_TRX_ASSETS TAS where TAS.ID = TAL.TAS_ID and TAS.TAS_TYPE = 'ALI' and TAS.TSU_CODE = 'ENTERED')

View Text - HTML Formatted

SELECT TDAS.ID ID
, CLE.CLE_ID TOP_CLE_ID
, TAL.KLE_ID FA_CLE_ID
, TDAS.TAL_ID TAL_ID
, TDAS.ASSET_NUMBER ASSET_NUMBER
, TDAS.DESCRIPTION DESCRIPTION
, TDAS.QUANTITY QUANTITY
, TDAS.COST COST
, TDAS.SPLIT_PERCENT SPLIT_PERCENT
, TDAS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, I.NAME INVENTORY_ITEM_NAME
, I.DESCRIPTION INVENTORY_ITEM_DESCRIPTION
, I.ID2 INVENTORY_ORG_ID
FROM OKL_TXD_ASSETS_V TDAS
, OKL_TXL_ASSETS_B TAL
, OKX_SYSTEM_ITEMS_V I
, OKC_K_LINES_B CLE
WHERE CLE.ID = TAL.KLE_ID
AND TDAS.INVENTORY_ITEM_ID = I.ID1
AND TAL.ID = TDAS.TAL_ID
AND TAL.TAL_TYPE = 'ALI'
AND EXISTS (SELECT '1'
FROM OKL_TRX_ASSETS TAS
WHERE TAS.ID = TAL.TAS_ID
AND TAS.TAS_TYPE = 'ALI'
AND TAS.TSU_CODE = 'ENTERED')