View: FF_FORMULAS_LOV

Product:	FF - FastFormula
Description:	Used to support user interface
Implementation/DBA Data:	APPS.FF_FORMULAS_LOV

View Text

SELECT FF.FORMULA_ID
, FF.LEGISLATION_CODE
, FF.BUSINESS_GROUP_ID
, FF.FORMULA_NAME
FROM FND_SESSIONS FND
, FF_FORMULAS_F 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 )

Columns