VIEW: APPS.PAY_FORMULA_RESULT_RULES_D

Source

View Text - Preformatted

SELECT FR.FORMULA_RESULT_RULE_ID , FR.EFFECTIVE_START_DATE , FR.EFFECTIVE_END_DATE , FR.RESULT_NAME , RT.MEANING , ELTL.ELEMENT_NAME , IVTL.NAME , UT.MEANING , SV.MEANING , FR.LAST_UPDATE_DATE , FU.USER_NAME FROM PAY_FORMULA_RESULT_RULES_F FR , PAY_INPUT_VALUES_F_TL IVTL , PAY_INPUT_VALUES_F IV , PAY_ELEMENT_TYPES_F_TL ELTL , PAY_ELEMENT_TYPES_F EL , HR_LOOKUPS RT , HR_LOOKUPS SV , HR_LOOKUPS UT , FND_USER FU WHERE EL.ELEMENT_TYPE_ID = ELTL.ELEMENT_TYPE_ID (+) AND DECODE(ELTL.ELEMENT_TYPE_ID,NULL,'1',ELTL.LANGUAGE) = DECODE(ELTL.ELEMENT_TYPE_ID,NULL,'1',USERENV('LANG')) AND IV.INPUT_VALUE_ID = IVTL.INPUT_VALUE_ID (+) AND DECODE(IVTL.INPUT_VALUE_ID,NULL,'1',IVTL.LANGUAGE) = DECODE(IVTL.INPUT_VALUE_ID,NULL,'1',USERENV('LANG')) AND FR.ELEMENT_TYPE_ID = EL.ELEMENT_TYPE_ID(+) AND FR.EFFECTIVE_START_DATE BETWEEN NVL(EL.EFFECTIVE_START_DATE, FR.EFFECTIVE_START_DATE) AND NVL(EL.EFFECTIVE_END_DATE, FR.EFFECTIVE_START_DATE) AND FR.INPUT_VALUE_ID = IV.INPUT_VALUE_ID(+) AND FR.EFFECTIVE_START_DATE BETWEEN NVL(IV.EFFECTIVE_START_DATE, FR.EFFECTIVE_START_DATE) AND NVL(IV.EFFECTIVE_END_DATE, FR.EFFECTIVE_START_DATE) AND (FR.RESULT_RULE_TYPE = RT.LOOKUP_CODE AND RT.LOOKUP_TYPE = 'RESULT_RULE_TYPE') AND (IV.UOM = UT.LOOKUP_CODE(+) AND (UT.LOOKUP_TYPE = 'UNITS' OR UT.LOOKUP_TYPE IS NULL)) AND (FR.SEVERITY_LEVEL = SV.LOOKUP_CODE(+) AND (SV.LOOKUP_TYPE = 'FORMULA_RESULT_MESSAGE_LEVEL' OR SV.LOOKUP_TYPE IS NULL)) AND FU.USER_ID (+)= FR.LAST_UPDATED_BY

View Text - HTML Formatted

SELECT FR.FORMULA_RESULT_RULE_ID
, FR.EFFECTIVE_START_DATE
, FR.EFFECTIVE_END_DATE
, FR.RESULT_NAME
, RT.MEANING
, ELTL.ELEMENT_NAME
, IVTL.NAME
, UT.MEANING
, SV.MEANING
, FR.LAST_UPDATE_DATE
, FU.USER_NAME
FROM PAY_FORMULA_RESULT_RULES_F FR
, PAY_INPUT_VALUES_F_TL IVTL
, PAY_INPUT_VALUES_F IV
, PAY_ELEMENT_TYPES_F_TL ELTL
, PAY_ELEMENT_TYPES_F EL
, HR_LOOKUPS RT
, HR_LOOKUPS SV
, HR_LOOKUPS UT
, FND_USER FU
WHERE EL.ELEMENT_TYPE_ID = ELTL.ELEMENT_TYPE_ID (+)
AND DECODE(ELTL.ELEMENT_TYPE_ID
, NULL
, '1'
, ELTL.LANGUAGE) = DECODE(ELTL.ELEMENT_TYPE_ID
, NULL
, '1'
, USERENV('LANG'))
AND IV.INPUT_VALUE_ID = IVTL.INPUT_VALUE_ID (+)
AND DECODE(IVTL.INPUT_VALUE_ID
, NULL
, '1'
, IVTL.LANGUAGE) = DECODE(IVTL.INPUT_VALUE_ID
, NULL
, '1'
, USERENV('LANG'))
AND FR.ELEMENT_TYPE_ID = EL.ELEMENT_TYPE_ID(+)
AND FR.EFFECTIVE_START_DATE BETWEEN NVL(EL.EFFECTIVE_START_DATE
, FR.EFFECTIVE_START_DATE)
AND NVL(EL.EFFECTIVE_END_DATE
, FR.EFFECTIVE_START_DATE)
AND FR.INPUT_VALUE_ID = IV.INPUT_VALUE_ID(+)
AND FR.EFFECTIVE_START_DATE BETWEEN NVL(IV.EFFECTIVE_START_DATE
, FR.EFFECTIVE_START_DATE)
AND NVL(IV.EFFECTIVE_END_DATE
, FR.EFFECTIVE_START_DATE)
AND (FR.RESULT_RULE_TYPE = RT.LOOKUP_CODE
AND RT.LOOKUP_TYPE = 'RESULT_RULE_TYPE')
AND (IV.UOM = UT.LOOKUP_CODE(+)
AND (UT.LOOKUP_TYPE = 'UNITS' OR UT.LOOKUP_TYPE IS NULL))
AND (FR.SEVERITY_LEVEL = SV.LOOKUP_CODE(+)
AND (SV.LOOKUP_TYPE = 'FORMULA_RESULT_MESSAGE_LEVEL' OR SV.LOOKUP_TYPE IS NULL))
AND FU.USER_ID (+)= FR.LAST_UPDATED_BY