VIEW: APPS.PAY_LINK_INPUT_VALUES_D

Source

View Text - Preformatted

SELECT INPLINK.LINK_INPUT_VALUE_ID , INPLINK.EFFECTIVE_START_DATE , INPLINK.EFFECTIVE_END_DATE , HR_CHKFMT.CHANGEFORMAT(DECODE(INPUT.LOOKUP_TYPE, NULL, DECODE(INPUT.HOT_DEFAULT_FLAG, 'Y', NVL(INPLINK.DEFAULT_VALUE, INPUT.DEFAULT_VALUE), INPLINK.DEFAULT_VALUE), HR_GENERAL.DECODE_LOOKUP(INPUT.LOOKUP_TYPE, DECODE(INPUT.HOT_DEFAULT_FLAG, 'Y', NVL(INPLINK.DEFAULT_VALUE, INPUT.DEFAULT_VALUE), INPLINK.DEFAULT_VALUE))), INPUT.UOM, BUS.CURRENCY_CODE) DEFAULT_VALUE , HR_CHKFMT.CHANGEFORMAT(DECODE(INPUT.HOT_DEFAULT_FLAG, 'Y', NVL(INPLINK.MAX_VALUE, INPUT.MAX_VALUE), 'N', INPLINK.MAX_VALUE), INPUT.UOM,BUS.CURRENCY_CODE) MAX_VALUE , HR_CHKFMT.CHANGEFORMAT(DECODE(INPUT.HOT_DEFAULT_FLAG, 'Y', NVL(INPLINK.MIN_VALUE, INPUT.MIN_VALUE), 'N', INPLINK.MIN_VALUE), INPUT.UOM,BUS.CURRENCY_CODE) MIN_VALUE , DECODE(INPUT.HOT_DEFAULT_FLAG, 'Y', NVL(HR1.MEANING, HR2.MEANING), HR1.MEANING) WARNING_OR_ERROR , INPLINK.LAST_UPDATE_DATE , FUSER.USER_NAME FROM PAY_LINK_INPUT_VALUES_F INPLINK , PAY_INPUT_VALUES_F INPUT , HR_LOOKUPS HR1 , HR_LOOKUPS HR2 , PER_BUSINESS_GROUPS BUS , FND_USER FUSER WHERE INPUT.INPUT_VALUE_ID = INPLINK.INPUT_VALUE_ID AND INPLINK.EFFECTIVE_START_DATE BETWEEN INPUT.EFFECTIVE_START_DATE AND INPUT.EFFECTIVE_END_DATE AND HR1.LOOKUP_CODE (+)= INPLINK.WARNING_OR_ERROR AND HR1.LOOKUP_TYPE (+)= 'WARNING_ERROR' AND HR2.LOOKUP_CODE (+)= INPUT.WARNING_OR_ERROR AND HR2.LOOKUP_TYPE (+)= 'WARNING_ERROR' AND BUS.BUSINESS_GROUP_ID (+) + 0 = INPUT.BUSINESS_GROUP_ID + 0 AND FUSER.USER_ID (+)= INPLINK.LAST_UPDATED_BY

View Text - HTML Formatted

SELECT INPLINK.LINK_INPUT_VALUE_ID
, INPLINK.EFFECTIVE_START_DATE
, INPLINK.EFFECTIVE_END_DATE
, HR_CHKFMT.CHANGEFORMAT(DECODE(INPUT.LOOKUP_TYPE
, NULL
, DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(INPLINK.DEFAULT_VALUE
, INPUT.DEFAULT_VALUE)
, INPLINK.DEFAULT_VALUE)
, HR_GENERAL.DECODE_LOOKUP(INPUT.LOOKUP_TYPE
, DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(INPLINK.DEFAULT_VALUE
, INPUT.DEFAULT_VALUE)
, INPLINK.DEFAULT_VALUE)))
, INPUT.UOM
, BUS.CURRENCY_CODE) DEFAULT_VALUE
, HR_CHKFMT.CHANGEFORMAT(DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(INPLINK.MAX_VALUE
, INPUT.MAX_VALUE)
, 'N'
, INPLINK.MAX_VALUE)
, INPUT.UOM
, BUS.CURRENCY_CODE) MAX_VALUE
, HR_CHKFMT.CHANGEFORMAT(DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(INPLINK.MIN_VALUE
, INPUT.MIN_VALUE)
, 'N'
, INPLINK.MIN_VALUE)
, INPUT.UOM
, BUS.CURRENCY_CODE) MIN_VALUE
, DECODE(INPUT.HOT_DEFAULT_FLAG
, 'Y'
, NVL(HR1.MEANING
, HR2.MEANING)
, HR1.MEANING) WARNING_OR_ERROR
, INPLINK.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PAY_LINK_INPUT_VALUES_F INPLINK
, PAY_INPUT_VALUES_F INPUT
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, PER_BUSINESS_GROUPS BUS
, FND_USER FUSER
WHERE INPUT.INPUT_VALUE_ID = INPLINK.INPUT_VALUE_ID
AND INPLINK.EFFECTIVE_START_DATE BETWEEN INPUT.EFFECTIVE_START_DATE
AND INPUT.EFFECTIVE_END_DATE
AND HR1.LOOKUP_CODE (+)= INPLINK.WARNING_OR_ERROR
AND HR1.LOOKUP_TYPE (+)= 'WARNING_ERROR'
AND HR2.LOOKUP_CODE (+)= INPUT.WARNING_OR_ERROR
AND HR2.LOOKUP_TYPE (+)= 'WARNING_ERROR'
AND BUS.BUSINESS_GROUP_ID (+) + 0 = INPUT.BUSINESS_GROUP_ID + 0
AND FUSER.USER_ID (+)= INPLINK.LAST_UPDATED_BY