VIEW: APPS.FF_FORMULAS_F_V

Source

View Text - Preformatted

SELECT FRA.ROWID ROW_ID , FRA.FORMULA_ID , FRA.EFFECTIVE_START_DATE , FRA.EFFECTIVE_END_DATE , FRA.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , FRA.LEGISLATION_CODE , FRA.FORMULA_TYPE_ID , FRA.FORMULA_NAME , FRA.DESCRIPTION , FRA.FORMULA_TEXT , FRA.STICKY_FLAG , FRA.LAST_UPDATE_DATE , FRA.LAST_UPDATED_BY , FRA.LAST_UPDATE_LOGIN , FRA.CREATED_BY , FRA.CREATION_DATE ,nvl(hr_general.decode_lookup('FORMULA_TYPE',FTY.FORMULA_TYPE_NAME), FTY.FORMULA_TYPE_NAME) FORMULA_TYPE , DECODE(CPI.FORMULA_ID,NULL,'N','Y') VERIFIED FROM FF_FORMULAS_F FRA, FF_FORMULA_TYPES FTY, FF_COMPILED_INFO_F CPI, FND_SESSIONS SES WHERE FTY.FORMULA_TYPE_ID = FRA.FORMULA_TYPE_ID AND CPI.FORMULA_ID (+) = FRA.FORMULA_ID AND CPI.EFFECTIVE_START_DATE (+) = FRA.EFFECTIVE_START_DATE AND SES.SESSION_ID = USERENV('sessionid') AND SES.EFFECTIVE_DATE BETWEEN FRA.EFFECTIVE_START_DATE AND FRA.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT FRA.ROWID ROW_ID
, FRA.FORMULA_ID
, FRA.EFFECTIVE_START_DATE
, FRA.EFFECTIVE_END_DATE
, FRA.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, FRA.LEGISLATION_CODE
, FRA.FORMULA_TYPE_ID
, FRA.FORMULA_NAME
, FRA.DESCRIPTION
, FRA.FORMULA_TEXT
, FRA.STICKY_FLAG
, FRA.LAST_UPDATE_DATE
, FRA.LAST_UPDATED_BY
, FRA.LAST_UPDATE_LOGIN
, FRA.CREATED_BY
, FRA.CREATION_DATE
, NVL(HR_GENERAL.DECODE_LOOKUP('FORMULA_TYPE'
, FTY.FORMULA_TYPE_NAME)
, FTY.FORMULA_TYPE_NAME) FORMULA_TYPE
, DECODE(CPI.FORMULA_ID
, NULL
, 'N'
, 'Y') VERIFIED
FROM FF_FORMULAS_F FRA
, FF_FORMULA_TYPES FTY
, FF_COMPILED_INFO_F CPI
, FND_SESSIONS SES
WHERE FTY.FORMULA_TYPE_ID = FRA.FORMULA_TYPE_ID
AND CPI.FORMULA_ID (+) = FRA.FORMULA_ID
AND CPI.EFFECTIVE_START_DATE (+) = FRA.EFFECTIVE_START_DATE
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN FRA.EFFECTIVE_START_DATE
AND FRA.EFFECTIVE_END_DATE