DBA Data[Home] [Help]

VIEW: APPS.IBY_FORMULA_FACTOR_V

Source

View Text - Preformatted

SELECT fc.risk_factor_code, fc.factor_type, fc.interface_name, fl.formula_name, fl.payeeid, fl.implicit_flag, fi.weight from iby_risk_factors fc, iby_risk_formulas fl, iby_risk_formula_item fi where fc.risk_factor_id = fi.risk_factor_id and fl.risk_formula_id = fi.risk_formula_id
View Text - HTML Formatted

SELECT FC.RISK_FACTOR_CODE
, FC.FACTOR_TYPE
, FC.INTERFACE_NAME
, FL.FORMULA_NAME
, FL.PAYEEID
, FL.IMPLICIT_FLAG
, FI.WEIGHT
FROM IBY_RISK_FACTORS FC
, IBY_RISK_FORMULAS FL
, IBY_RISK_FORMULA_ITEM FI
WHERE FC.RISK_FACTOR_ID = FI.RISK_FACTOR_ID
AND FL.RISK_FORMULA_ID = FI.RISK_FORMULA_ID