VIEW: APPS.FF_FORMULAS_LOV

Source

View Text - Preformatted

SELECT ff.formula_id , ff.legislation_code , ff.business_group_id , ff.formula_name FROM fnd_sessions fnd , ff_formulas_f_vl ff , ff_formula_types ft WHERE ff.formula_type_id = ft.formula_type_id AND upper (ft.formula_type_name) = 'USER TABLE VALIDATION' AND ff.effective_start_date <= fnd.effective_date AND ff.effective_end_date >= fnd.effective_date AND fnd.session_id = userenv ('sessionid') AND EXISTS ( SELECT 1 FROM ff_compiled_info_f fc WHERE fc.formula_id = ff.formula_id AND fc.effective_start_date <= fnd.effective_date AND fc.effective_end_date >= fnd.effective_date )

View Text - HTML Formatted

SELECT FF.FORMULA_ID
, FF.LEGISLATION_CODE
, FF.BUSINESS_GROUP_ID
, FF.FORMULA_NAME
FROM FND_SESSIONS FND
, FF_FORMULAS_F_VL FF
, FF_FORMULA_TYPES FT
WHERE FF.FORMULA_TYPE_ID = FT.FORMULA_TYPE_ID
AND UPPER (FT.FORMULA_TYPE_NAME) = 'USER TABLE VALIDATION'
AND FF.EFFECTIVE_START_DATE <= FND.EFFECTIVE_DATE
AND FF.EFFECTIVE_END_DATE >= FND.EFFECTIVE_DATE
AND FND.SESSION_ID = USERENV ('SESSIONID')
AND EXISTS ( SELECT 1
FROM FF_COMPILED_INFO_F FC
WHERE FC.FORMULA_ID = FF.FORMULA_ID
AND FC.EFFECTIVE_START_DATE <= FND.EFFECTIVE_DATE
AND FC.EFFECTIVE_END_DATE >= FND.EFFECTIVE_DATE )