VIEW: APPS.OKL_FA_REF_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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