VIEW: APPS.PAY_INPUT_VALUES_D

Source

View Text - Preformatted

SELECT INPUT.INPUT_VALUE_ID , INPUT.EFFECTIVE_START_DATE , INPUT.EFFECTIVE_END_DATE , INPUT.LOOKUP_TYPE , FORMULA.FORMULA_NAME , INPUT.DISPLAY_SEQUENCE , DECODE(INPUT.MANDATORY_FLAG, 'Y', 'Yes', 'No') REQUIRED , DECODE(INPUT.MANDATORY_FLAG, 'X', 'No', 'Yes') USER_ENTERABLE , HR1.MEANING , INPUT.DEFAULT_VALUE , INPUT.MAX_VALUE , INPUT.MIN_VALUE , HR2.MEANING , INPUT.LAST_UPDATE_DATE , FUSER.USER_NAME FROM PAY_INPUT_VALUES_F INPUT , FF_FORMULAS_F FORMULA , HR_LOOKUPS HR1 , HR_LOOKUPS HR2 , FND_USER FUSER WHERE FORMULA.FORMULA_ID (+)= INPUT.FORMULA_ID AND INPUT.EFFECTIVE_START_DATE BETWEEN NVL (FORMULA.EFFECTIVE_START_DATE, INPUT.EFFECTIVE_START_DATE) AND NVL (FORMULA.EFFECTIVE_END_DATE, INPUT.EFFECTIVE_START_DATE) AND HR1.LOOKUP_CODE (+)= INPUT.UOM AND HR1.LOOKUP_TYPE (+)= 'UNITS' AND HR2.LOOKUP_CODE (+)= INPUT.WARNING_OR_ERROR AND HR2.LOOKUP_TYPE (+)= 'WARNING_ERROR' AND FUSER.USER_ID (+)= INPUT.LAST_UPDATED_BY

View Text - HTML Formatted

SELECT INPUT.INPUT_VALUE_ID
, INPUT.EFFECTIVE_START_DATE
, INPUT.EFFECTIVE_END_DATE
, INPUT.LOOKUP_TYPE
, FORMULA.FORMULA_NAME
, INPUT.DISPLAY_SEQUENCE
, DECODE(INPUT.MANDATORY_FLAG
, 'Y'
, 'YES'
, 'NO') REQUIRED
, DECODE(INPUT.MANDATORY_FLAG
, 'X'
, 'NO'
, 'YES') USER_ENTERABLE
, HR1.MEANING
, INPUT.DEFAULT_VALUE
, INPUT.MAX_VALUE
, INPUT.MIN_VALUE
, HR2.MEANING
, INPUT.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PAY_INPUT_VALUES_F INPUT
, FF_FORMULAS_F FORMULA
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, FND_USER FUSER
WHERE FORMULA.FORMULA_ID (+)= INPUT.FORMULA_ID
AND INPUT.EFFECTIVE_START_DATE BETWEEN NVL (FORMULA.EFFECTIVE_START_DATE
, INPUT.EFFECTIVE_START_DATE)
AND NVL (FORMULA.EFFECTIVE_END_DATE
, INPUT.EFFECTIVE_START_DATE)
AND HR1.LOOKUP_CODE (+)= INPUT.UOM
AND HR1.LOOKUP_TYPE (+)= 'UNITS'
AND HR2.LOOKUP_CODE (+)= INPUT.WARNING_OR_ERROR
AND HR2.LOOKUP_TYPE (+)= 'WARNING_ERROR'
AND FUSER.USER_ID (+)= INPUT.LAST_UPDATED_BY