VIEW: APPS.PAY_LINK_INPUT_VALUES_V

Source

View Text - Preformatted

SELECT LINK.ROWID ROW_ID , LINK.LINK_INPUT_VALUE_ID , PIVTL.NAME NAME , PIV.NAME , PIV.UOM , HR_GENERAL.DECODE_LOOKUP('UNITS',PIV.UOM) UNIT_OF_MEASURE , LINK.WARNING_OR_ERROR , PIV.WARNING_OR_ERROR ELEMENT_WARNING_OR_ERROR , DECODE (PIV.WARNING_OR_ERROR, NULL, NULL, '"'||HR_GENERAL.DECODE_LOOKUP('WARNING_ERROR', PIV.WARNING_OR_ERROR)||'"') HOT_WARNING_OR_ERROR , DECODE (PIV.HOT_DEFAULT_FLAG, 'N', DECODE(LINK.WARNING_OR_ERROR, NULL, NULL, HR_GENERAL.DECODE_LOOKUP('WARNING_ERROR', LINK.WARNING_OR_ERROR)), DECODE (NVL (LINK.WARNING_OR_ERROR, PIV.WARNING_OR_ERROR), NULL, NULL, NVL (DECODE(LINK.WARNING_OR_ERROR, NULL, NULL, HR_GENERAL.DECODE_LOOKUP('WARNING_ERROR', LINK.WARNING_OR_ERROR)), '"'|| DECODE(PIV.WARNING_OR_ERROR, NULL, NULL, HR_GENERAL.DECODE_LOOKUP('WARNING_ERROR', PIV.WARNING_OR_ERROR))||'"'))) DISPLAY_WARNING_OR_ERROR , LINK.MAX_VALUE , PIV.MAX_VALUE ELEMENT_MAX_VALUE , DECODE (PIV.MAX_VALUE, NULL, NULL, '"'||HR_CHKFMT.CHANGEFORMAT (PIV.MAX_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE)||'"') HOT_MAX_VALUE , DECODE (PIV.HOT_DEFAULT_FLAG, 'N', HR_CHKFMT.CHANGEFORMAT (LINK.MAX_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE), DECODE (NVL (LINK.MAX_VALUE, PIV.MAX_VALUE), NULL, NULL, NVL (HR_CHKFMT.CHANGEFORMAT (LINK.MAX_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE), '"'||HR_CHKFMT.CHANGEFORMAT (PIV.MAX_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE)||'"'))) DISPLAY_MAX , LINK.MIN_VALUE , PIV.MIN_VALUE ELEMENT_MIN_VALUE , DECODE (PIV.MIN_VALUE, NULL, NULL, '"'||HR_CHKFMT.CHANGEFORMAT (PIV.MIN_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE)||'"') HOT_MIN_VALUE , DECODE (PIV.HOT_DEFAULT_FLAG, 'N', HR_CHKFMT.CHANGEFORMAT (LINK.MIN_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE), DECODE (NVL (LINK.MIN_VALUE, PIV.MIN_VALUE), NULL, NULL, NVL (HR_CHKFMT.CHANGEFORMAT (LINK.MIN_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE), '"'||HR_CHKFMT.CHANGEFORMAT (PIV.MIN_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE)||'"'))) DISPLAY_MIN , LINK.DEFAULT_VALUE , DECODE (PIV.DEFAULT_VALUE, NULL, NULL, '"'||DECODE (PIV.LOOKUP_TYPE, NULL, DECODE (PIV.VALUE_SET_ID, NULL, HR_CHKFMT.CHANGEFORMAT (PIV.DEFAULT_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE), PAY_INPUT_VALUES_PKG.DECODE_VSET_VALUE(PIV.VALUE_SET_ID, PIV.DEFAULT_VALUE)), HR_GENERAL.DECODE_LOOKUP (PIV.LOOKUP_TYPE, PIV.DEFAULT_VALUE))||'"') HOT_DEFAULT_VALUE , DECODE (PIV.LOOKUP_TYPE, NULL, DECODE(PIV.VALUE_SET_ID, NULL, DECODE(PIV.HOT_DEFAULT_FLAG, 'N', HR_CHKFMT.CHANGEFORMAT (LINK.DEFAULT_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE), DECODE (NVL(LINK.DEFAULT_VALUE, PIV.DEFAULT_VALUE), NULL, NULL, NVL (HR_CHKFMT.CHANGEFORMAT (LINK.DEFAULT_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE), '"'|| HR_CHKFMT.CHANGEFORMAT (PIV.DEFAULT_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE)||'"')) ), DECODE(PIV.HOT_DEFAULT_FLAG, 'N', PAY_INPUT_VALUES_PKG.DECODE_VSET_VALUE(PIV.VALUE_SET_ID, LINK.DEFAULT_VALUE), PAY_INPUT_VALUES_PKG.DECODE_VSET_VALUE(PIV.VALUE_SET_ID, NVL(LINK.DEFAULT_VALUE, PIV.DEFAULT_VALUE))) ), DECODE(PIV.HOT_DEFAULT_FLAG, 'N', HR_GENERAL.DECODE_LOOKUP (PIV.LOOKUP_TYPE, LINK.DEFAULT_VALUE), HR_GENERAL.DECODE_LOOKUP (PIV.LOOKUP_TYPE, NVL(LINK.DEFAULT_VALUE, PIV.DEFAULT_VALUE)))) DISPLAY_DEFAULT_VALUE , LINK.EFFECTIVE_START_DATE EFFECTIVE_START_DATE , LINK.EFFECTIVE_END_DATE EFFECTIVE_END_DATE , LINK.ELEMENT_LINK_ID ELEMENT_LINK_ID , LINK.INPUT_VALUE_ID INPUT_VALUE_ID , LINK.COSTED_FLAG COSTED_FLAG , LINK.LAST_UPDATE_DATE , LINK.LAST_UPDATED_BY , LINK.LAST_UPDATE_LOGIN , LINK.CREATED_BY , LINK.CREATION_DATE , PIV.LOOKUP_TYPE , PIV.VALUE_SET_ID , FFVS.FLEX_VALUE_SET_NAME VALUE_SET_NAME , PIV.DISPLAY_SEQUENCE , PIV.HOT_DEFAULT_FLAG , PIV.GENERATE_DB_ITEMS_FLAG , DECODE(PIV.MANDATORY_FLAG, 'Y','Y', 'N') MANDATORY_FLAG , DECODE(PIV.MANDATORY_FLAG, 'X','N', 'Y') USER_ENTERABLE_FLAG , FF.FORMULA_NAME FORMULA_NAME FROM PAY_INPUT_VALUES_F_TL PIVTL, PAY_INPUT_VALUES_F PIV, PAY_LINK_INPUT_VALUES_F LINK, PAY_ELEMENT_TYPES_F ELEMENT, FF_FORMULAS_F FF, FND_FLEX_VALUE_SETS FFVS, FND_SESSIONS FND WHERE PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID AND PIVTL.LANGUAGE = USERENV('LANG') AND LINK.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID AND ELEMENT.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID AND PIV.FORMULA_ID = FF.FORMULA_ID(+) AND PIV.VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID (+) AND (USERENV('sessionid') = FND.SESSION_ID AND FND.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE AND ELEMENT.EFFECTIVE_END_DATE AND FND.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE AND PIV.EFFECTIVE_END_DATE AND FND.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE AND LINK.EFFECTIVE_END_DATE AND FND.EFFECTIVE_DATE BETWEEN NVL(FF.EFFECTIVE_START_DATE, FND.EFFECTIVE_DATE) AND NVL(FF.EFFECTIVE_END_DATE, FND.EFFECTIVE_DATE))

View Text - HTML Formatted

SELECT LINK.ROWID ROW_ID
, LINK.LINK_INPUT_VALUE_ID
, PIVTL.NAME NAME
, PIV.NAME
, PIV.UOM
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, PIV.UOM) UNIT_OF_MEASURE
, LINK.WARNING_OR_ERROR
, PIV.WARNING_OR_ERROR ELEMENT_WARNING_OR_ERROR
, DECODE (PIV.WARNING_OR_ERROR
, NULL
, NULL
, '"'||HR_GENERAL.DECODE_LOOKUP('WARNING_ERROR'
, PIV.WARNING_OR_ERROR)||'"') HOT_WARNING_OR_ERROR
, DECODE (PIV.HOT_DEFAULT_FLAG
, 'N'
, DECODE(LINK.WARNING_OR_ERROR
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('WARNING_ERROR'
, LINK.WARNING_OR_ERROR))
, DECODE (NVL (LINK.WARNING_OR_ERROR
, PIV.WARNING_OR_ERROR)
, NULL
, NULL
, NVL (DECODE(LINK.WARNING_OR_ERROR
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('WARNING_ERROR'
, LINK.WARNING_OR_ERROR))
, '"'|| DECODE(PIV.WARNING_OR_ERROR
, NULL
, NULL
, HR_GENERAL.DECODE_LOOKUP('WARNING_ERROR'
, PIV.WARNING_OR_ERROR))||'"'))) DISPLAY_WARNING_OR_ERROR
, LINK.MAX_VALUE
, PIV.MAX_VALUE ELEMENT_MAX_VALUE
, DECODE (PIV.MAX_VALUE
, NULL
, NULL
, '"'||HR_CHKFMT.CHANGEFORMAT (PIV.MAX_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)||'"') HOT_MAX_VALUE
, DECODE (PIV.HOT_DEFAULT_FLAG
, 'N'
, HR_CHKFMT.CHANGEFORMAT (LINK.MAX_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)
, DECODE (NVL (LINK.MAX_VALUE
, PIV.MAX_VALUE)
, NULL
, NULL
, NVL (HR_CHKFMT.CHANGEFORMAT (LINK.MAX_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)
, '"'||HR_CHKFMT.CHANGEFORMAT (PIV.MAX_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)||'"'))) DISPLAY_MAX
, LINK.MIN_VALUE
, PIV.MIN_VALUE ELEMENT_MIN_VALUE
, DECODE (PIV.MIN_VALUE
, NULL
, NULL
, '"'||HR_CHKFMT.CHANGEFORMAT (PIV.MIN_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)||'"') HOT_MIN_VALUE
, DECODE (PIV.HOT_DEFAULT_FLAG
, 'N'
, HR_CHKFMT.CHANGEFORMAT (LINK.MIN_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)
, DECODE (NVL (LINK.MIN_VALUE
, PIV.MIN_VALUE)
, NULL
, NULL
, NVL (HR_CHKFMT.CHANGEFORMAT (LINK.MIN_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)
, '"'||HR_CHKFMT.CHANGEFORMAT (PIV.MIN_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)||'"'))) DISPLAY_MIN
, LINK.DEFAULT_VALUE
, DECODE (PIV.DEFAULT_VALUE
, NULL
, NULL
, '"'||DECODE (PIV.LOOKUP_TYPE
, NULL
, DECODE (PIV.VALUE_SET_ID
, NULL
, HR_CHKFMT.CHANGEFORMAT (PIV.DEFAULT_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)
, PAY_INPUT_VALUES_PKG.DECODE_VSET_VALUE(PIV.VALUE_SET_ID
, PIV.DEFAULT_VALUE))
, HR_GENERAL.DECODE_LOOKUP (PIV.LOOKUP_TYPE
, PIV.DEFAULT_VALUE))||'"') HOT_DEFAULT_VALUE
, DECODE (PIV.LOOKUP_TYPE
, NULL
, DECODE(PIV.VALUE_SET_ID
, NULL
, DECODE(PIV.HOT_DEFAULT_FLAG
, 'N'
, HR_CHKFMT.CHANGEFORMAT (LINK.DEFAULT_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)
, DECODE (NVL(LINK.DEFAULT_VALUE
, PIV.DEFAULT_VALUE)
, NULL
, NULL
, NVL (HR_CHKFMT.CHANGEFORMAT (LINK.DEFAULT_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)
, '"'|| HR_CHKFMT.CHANGEFORMAT (PIV.DEFAULT_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE)||'"')) )
, DECODE(PIV.HOT_DEFAULT_FLAG
, 'N'
, PAY_INPUT_VALUES_PKG.DECODE_VSET_VALUE(PIV.VALUE_SET_ID
, LINK.DEFAULT_VALUE)
, PAY_INPUT_VALUES_PKG.DECODE_VSET_VALUE(PIV.VALUE_SET_ID
, NVL(LINK.DEFAULT_VALUE
, PIV.DEFAULT_VALUE))) )
, DECODE(PIV.HOT_DEFAULT_FLAG
, 'N'
, HR_GENERAL.DECODE_LOOKUP (PIV.LOOKUP_TYPE
, LINK.DEFAULT_VALUE)
, HR_GENERAL.DECODE_LOOKUP (PIV.LOOKUP_TYPE
, NVL(LINK.DEFAULT_VALUE
, PIV.DEFAULT_VALUE)))) DISPLAY_DEFAULT_VALUE
, LINK.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, LINK.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, LINK.ELEMENT_LINK_ID ELEMENT_LINK_ID
, LINK.INPUT_VALUE_ID INPUT_VALUE_ID
, LINK.COSTED_FLAG COSTED_FLAG
, LINK.LAST_UPDATE_DATE
, LINK.LAST_UPDATED_BY
, LINK.LAST_UPDATE_LOGIN
, LINK.CREATED_BY
, LINK.CREATION_DATE
, PIV.LOOKUP_TYPE
, PIV.VALUE_SET_ID
, FFVS.FLEX_VALUE_SET_NAME VALUE_SET_NAME
, PIV.DISPLAY_SEQUENCE
, PIV.HOT_DEFAULT_FLAG
, PIV.GENERATE_DB_ITEMS_FLAG
, DECODE(PIV.MANDATORY_FLAG
, 'Y'
, 'Y'
, 'N') MANDATORY_FLAG
, DECODE(PIV.MANDATORY_FLAG
, 'X'
, 'N'
, 'Y') USER_ENTERABLE_FLAG
, FF.FORMULA_NAME FORMULA_NAME
FROM PAY_INPUT_VALUES_F_TL PIVTL
, PAY_INPUT_VALUES_F PIV
, PAY_LINK_INPUT_VALUES_F LINK
, PAY_ELEMENT_TYPES_F ELEMENT
, FF_FORMULAS_F FF
, FND_FLEX_VALUE_SETS FFVS
, FND_SESSIONS FND
WHERE PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND LINK.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND ELEMENT.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PIV.FORMULA_ID = FF.FORMULA_ID(+)
AND PIV.VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID (+)
AND (USERENV('SESSIONID') = FND.SESSION_ID
AND FND.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE
AND ELEMENT.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE
AND LINK.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN NVL(FF.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE)
AND NVL(FF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE))