VIEW: APPS.FF_FORMULAS_F_FV

Source

View Text - Preformatted

SELECT B.ROW_ID, B.FORMULA_ID, B.EFFECTIVE_START_DATE, B.EFFECTIVE_END_DATE, B.BUSINESS_GROUP_ID, B.LEGISLATION_CODE, B.FORMULA_TYPE_ID, B.BASE_FORMULA_NAME, B.DESCRIPTION BASE_DESCRIPTION, B.FORMULA_NAME, B.DESCRIPTION, B.FORMULA_TEXT, B.STICKY_FLAG, B.COMPILE_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.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_VL B, FF_FORMULA_TYPES FTY, FF_COMPILED_INFO_F CPI,FND_SESSIONS SES WHERE FTY.FORMULA_TYPE_ID = B.FORMULA_TYPE_ID AND CPI.FORMULA_ID (+) = B.FORMULA_ID AND CPI.EFFECTIVE_START_DATE (+) = B.EFFECTIVE_START_DATE AND SES.SESSION_ID = USERENV('sessionid') AND SES.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT B.ROW_ID
, B.FORMULA_ID
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.BUSINESS_GROUP_ID
, B.LEGISLATION_CODE
, B.FORMULA_TYPE_ID
, B.BASE_FORMULA_NAME
, B.DESCRIPTION BASE_DESCRIPTION
, B.FORMULA_NAME
, B.DESCRIPTION
, B.FORMULA_TEXT
, B.STICKY_FLAG
, B.COMPILE_FLAG
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.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_VL B
, FF_FORMULA_TYPES FTY
, FF_COMPILED_INFO_F CPI
, FND_SESSIONS SES
WHERE FTY.FORMULA_TYPE_ID = B.FORMULA_TYPE_ID
AND CPI.FORMULA_ID (+) = B.FORMULA_ID
AND CPI.EFFECTIVE_START_DATE (+) = B.EFFECTIVE_START_DATE
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE
AND B.EFFECTIVE_END_DATE