VIEW: APPS.OKL_SPLIT_ASSET_TRX_UV

Source

View Text - Preformatted

SELECT ASDB.ID ID, ASDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ASDTL.SFWT_FLAG SFWT_FLAG, ASDB.TAL_ID TAL_ID, ASDB.TARGET_KLE_ID TARGET_KLE_ID, ASDB.LINE_DETAIL_NUMBER LINE_DETAIL_NUMBER, ASDB.ASSET_NUMBER ASSET_NUMBER, ASDTL.DESCRIPTION DESCRIPTION, ASDB.QUANTITY QUANTITY, KLEB_TOP.OEC * (ASDB.QUANTITY/TALB.CURRENT_UNITS) COST, ASDB.TAX_BOOK TAX_BOOK, ASDB.LIFE_IN_MONTHS_TAX LIFE_IN_MONTHS_TAX, ASDB.DEPRN_METHOD_TAX DEPRN_METHOD_TAX, ASDB.DEPRN_RATE_TAX DEPRN_RATE_TAX, ASDB.SALVAGE_VALUE SALVAGE_VALUE, ASDB.SPLIT_PERCENT SPLIT_PERCENT, ASDB.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ASDB.CURRENCY_CODE, ASDB.CURRENCY_CONVERSION_TYPE, ASDB.CURRENCY_CONVERSION_RATE, ASDB.CURRENCY_CONVERSION_DATE, MTL.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE FROM OKL_TXD_ASSETS_B ASDB,OKL_TXD_ASSETS_TL ASDTL,OKL_TXL_ASSETS_B TALB,OKL_TRX_ASSETS TASB,OKC_K_LINES_B CLEB,OKC_K_LINES_B CLEB_TOP,OKL_K_LINES KLEB_TOP,MTL_SYSTEM_ITEMS_B MTL,OKC_K_ITEMS MODEL_CIM,OKC_K_LINES_B MODEL_CLE WHERE ASDB.ID = ASDTL.ID and ASDTL.LANGUAGE = USERENV('LANG') and TALB.ID = ASDB.TAL_ID and TALB.TAL_TYPE = 'ALI' and TASB.ID = TALB.TAS_ID and TASB.TAS_TYPE = 'ALI' and TASB.TSU_CODE = 'ENTERED' and CLEB.ID = TALB.KLE_ID and CLEB_TOP.ID = CLEB.CLE_ID and KLEB_TOP.ID = CLEB_TOP.ID AND TO_CHAR(mtl.organization_id)=model_cim.object1_id2 and model_cim.jtot_object1_code = 'OKX_SYSITEM' AND model_cim.cle_id = model_cle.id AND model_cim.dnz_chr_id = model_cle.dnz_chr_id AND model_cim.object1_id1=mtl.inventory_item_id AND cleb_top.id=model_cle.cle_id and model_cle.lse_id=34

View Text - HTML Formatted

SELECT ASDB.ID ID
, ASDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ASDTL.SFWT_FLAG SFWT_FLAG
, ASDB.TAL_ID TAL_ID
, ASDB.TARGET_KLE_ID TARGET_KLE_ID
, ASDB.LINE_DETAIL_NUMBER LINE_DETAIL_NUMBER
, ASDB.ASSET_NUMBER ASSET_NUMBER
, ASDTL.DESCRIPTION DESCRIPTION
, ASDB.QUANTITY QUANTITY
, KLEB_TOP.OEC * (ASDB.QUANTITY/TALB.CURRENT_UNITS) COST
, ASDB.TAX_BOOK TAX_BOOK
, ASDB.LIFE_IN_MONTHS_TAX LIFE_IN_MONTHS_TAX
, ASDB.DEPRN_METHOD_TAX DEPRN_METHOD_TAX
, ASDB.DEPRN_RATE_TAX DEPRN_RATE_TAX
, ASDB.SALVAGE_VALUE SALVAGE_VALUE
, ASDB.SPLIT_PERCENT SPLIT_PERCENT
, ASDB.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ASDB.CURRENCY_CODE
, ASDB.CURRENCY_CONVERSION_TYPE
, ASDB.CURRENCY_CONVERSION_RATE
, ASDB.CURRENCY_CONVERSION_DATE
, MTL.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
FROM OKL_TXD_ASSETS_B ASDB
, OKL_TXD_ASSETS_TL ASDTL
, OKL_TXL_ASSETS_B TALB
, OKL_TRX_ASSETS TASB
, OKC_K_LINES_B CLEB
, OKC_K_LINES_B CLEB_TOP
, OKL_K_LINES KLEB_TOP
, MTL_SYSTEM_ITEMS_B MTL
, OKC_K_ITEMS MODEL_CIM
, OKC_K_LINES_B MODEL_CLE
WHERE ASDB.ID = ASDTL.ID
AND ASDTL.LANGUAGE = USERENV('LANG')
AND TALB.ID = ASDB.TAL_ID
AND TALB.TAL_TYPE = 'ALI'
AND TASB.ID = TALB.TAS_ID
AND TASB.TAS_TYPE = 'ALI'
AND TASB.TSU_CODE = 'ENTERED'
AND CLEB.ID = TALB.KLE_ID
AND CLEB_TOP.ID = CLEB.CLE_ID
AND KLEB_TOP.ID = CLEB_TOP.ID
AND TO_CHAR(MTL.ORGANIZATION_ID)=MODEL_CIM.OBJECT1_ID2
AND MODEL_CIM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'
AND MODEL_CIM.CLE_ID = MODEL_CLE.ID
AND MODEL_CIM.DNZ_CHR_ID = MODEL_CLE.DNZ_CHR_ID
AND MODEL_CIM.OBJECT1_ID1=MTL.INVENTORY_ITEM_ID
AND CLEB_TOP.ID=MODEL_CLE.CLE_ID
AND MODEL_CLE.LSE_ID=34