[Home] [Help]
View: OKL_SPLIT_ASSET_COMP_UV
Product: | OKL - Lease and Finance Management |
Description: | User interface view used in assets lov on split asset into components page |
Implementation/DBA Data: |
APPS.OKL_SPLIT_ASSET_COMP_UV
|
View Text
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')
Columns
Name |
ID |
TOP_CLE_ID |
FA_CLE_ID |
TAL_ID |
ASSET_NUMBER |
DESCRIPTION |
QUANTITY |
COST |
SPLIT_PERCENT |
INVENTORY_ITEM_ID |
INVENTORY_ITEM_NAME |
INVENTORY_ITEM_DESCRIPTION |
INVENTORY_ORG_ID |