Product: | FF - FastFormula |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.FF_FORMULAS_F_V |
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