FND Design Data [Home] [Help]

View: OKL_FA_REF_VL

Product: OKL - Lease and Finance Management
Description:
Implementation/DBA Data: ViewAPPS.OKL_FA_REF_VL
View Text

SELECT /* PREDICATES */ FXL.FA_TRANSACTION_ID OKL_FA_TRANSACTION_ID
, FXHL.LANGUAGE LANGUAGE
, FXL.ASSET_ID OKL_ASSET_ID /* TRANSLATABLE SOURCES FOLLOWS */
, FXHL.CONTRACT_STATUS OKL_CONTRACT_STATUS
, FXHL.TRANSACTION_TYPE_NAME OKL_TRANSACTION_TYPE_NAME
, FXLL.INVENTORY_ORG_NAME OKL_INVENTORY_ORG_NAME
, FXLL.TRANS_LINE_DESCRIPTION OKL_TRANS_LINE_DESCRIPTION
, NULL OKL_INVENTORY_ITEM_NAME
FROM OKL_EXT_FA_LINE_SOURCES_B FXL
, OKL_EXT_FA_LINE_SOURCES_TL FXLL
, OKL_EXT_FA_HEADER_SOURCES_TL FXHL
WHERE FXL.LINE_EXTENSION_ID = FXLL.LINE_EXTENSION_ID
AND FXL.HEADER_EXTENSION_ID = FXHL.HEADER_EXTENSION_ID
AND FXLL.LANGUAGE = FXHL.LANGUAGE

Columns

Name
OKL_FA_TRANSACTION_ID
LANGUAGE
OKL_ASSET_ID
TEHL_CONTRACT_STATUS
TEHL_TRANSACTION_TYPE_NAME
TELL_INVENTORY_ORG_NAME
TCL_DESCRIPTION_TRANS
TELL_INVENTORY_ITEM_NAME