VIEW: APPS.PAY_INPUT_VALUES_V

Source

View Text - Preformatted

SELECT PIV.ROWID ROW_ID , PIV.INPUT_VALUE_ID , PIV.EFFECTIVE_START_DATE , PIV.EFFECTIVE_END_DATE , PIV.ELEMENT_TYPE_ID , PIV.LOOKUP_TYPE , PIV.VALUE_SET_ID , FFVS.FLEX_VALUE_SET_NAME VALUE_SET_NAME , PIV.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , PIV.LEGISLATION_CODE , PIV.FORMULA_ID , PIV.DISPLAY_SEQUENCE , PIVTL.NAME , PIV.NAME base_name , PIV.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))) D_DEFAULT_VALUE , PIV.LEGISLATION_SUBGROUP , PIV.MAX_VALUE , HR_CHKFMT.CHANGEFORMAT ( PIV.MAX_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE) D_MAX_VALUE , PIV.MIN_VALUE , HR_CHKFMT.CHANGEFORMAT ( PIV.MIN_VALUE, PIV.UOM, ELEMENT.INPUT_CURRENCY_CODE) D_MIN_VALUE , PIV.LAST_UPDATE_DATE , PIV.LAST_UPDATED_BY , PIV.LAST_UPDATE_LOGIN , PIV.CREATED_BY , PIV.CREATION_DATE , PIV.HOT_DEFAULT_FLAG , PIV.GENERATE_DB_ITEMS_FLAG , PIV.UOM , HR_GENERAL.DECODE_LOOKUP ('UNITS', PIV.UOM) UNIT_OF_MEASURE , PIV.MANDATORY_FLAG , DECODE(MANDATORY_FLAG, 'Y', 'Y', 'N') MANDATORY_FLAG_NAME , DECODE(MANDATORY_FLAG, 'X', 'N', 'Y') USER_ENTERABLE_FLAG , PIV.WARNING_OR_ERROR , HR_GENERAL.DECODE_LOOKUP ('WARNING_ERROR', PIV.WARNING_OR_ERROR) WARNING_OR_ERROR_NAME , FF.FORMULA_NAME FORMULA_NAME FROM PAY_INPUT_VALUES_F_TL PIVTL, PAY_INPUT_VALUES_F PIV, PAY_ELEMENT_TYPES_F ELEMENT, FF_FORMULAS_F_VL FF, FND_FLEX_VALUE_SETS FFVS, FND_SESSIONS FND WHERE PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID AND PIVTL.LANGUAGE = USERENV('LANG') AND PIV.FORMULA_ID = FF.FORMULA_ID(+) AND PIV.VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID (+) AND ELEMENT.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_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 (FF.FORMULA_ID IS NULL OR FND.EFFECTIVE_DATE BETWEEN FF.EFFECTIVE_START_DATE AND FF.EFFECTIVE_END_DATE))

View Text - HTML Formatted

SELECT PIV.ROWID ROW_ID
, PIV.INPUT_VALUE_ID
, PIV.EFFECTIVE_START_DATE
, PIV.EFFECTIVE_END_DATE
, PIV.ELEMENT_TYPE_ID
, PIV.LOOKUP_TYPE
, PIV.VALUE_SET_ID
, FFVS.FLEX_VALUE_SET_NAME VALUE_SET_NAME
, PIV.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PIV.LEGISLATION_CODE
, PIV.FORMULA_ID
, PIV.DISPLAY_SEQUENCE
, PIVTL.NAME
, PIV.NAME BASE_NAME
, PIV.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))) D_DEFAULT_VALUE
, PIV.LEGISLATION_SUBGROUP
, PIV.MAX_VALUE
, HR_CHKFMT.CHANGEFORMAT ( PIV.MAX_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE) D_MAX_VALUE
, PIV.MIN_VALUE
, HR_CHKFMT.CHANGEFORMAT ( PIV.MIN_VALUE
, PIV.UOM
, ELEMENT.INPUT_CURRENCY_CODE) D_MIN_VALUE
, PIV.LAST_UPDATE_DATE
, PIV.LAST_UPDATED_BY
, PIV.LAST_UPDATE_LOGIN
, PIV.CREATED_BY
, PIV.CREATION_DATE
, PIV.HOT_DEFAULT_FLAG
, PIV.GENERATE_DB_ITEMS_FLAG
, PIV.UOM
, HR_GENERAL.DECODE_LOOKUP ('UNITS'
, PIV.UOM) UNIT_OF_MEASURE
, PIV.MANDATORY_FLAG
, DECODE(MANDATORY_FLAG
, 'Y'
, 'Y'
, 'N') MANDATORY_FLAG_NAME
, DECODE(MANDATORY_FLAG
, 'X'
, 'N'
, 'Y') USER_ENTERABLE_FLAG
, PIV.WARNING_OR_ERROR
, HR_GENERAL.DECODE_LOOKUP ('WARNING_ERROR'
, PIV.WARNING_OR_ERROR) WARNING_OR_ERROR_NAME
, FF.FORMULA_NAME FORMULA_NAME
FROM PAY_INPUT_VALUES_F_TL PIVTL
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F ELEMENT
, FF_FORMULAS_F_VL FF
, FND_FLEX_VALUE_SETS FFVS
, FND_SESSIONS FND
WHERE PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PIV.FORMULA_ID = FF.FORMULA_ID(+)
AND PIV.VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID (+)
AND ELEMENT.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_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 (FF.FORMULA_ID IS NULL OR FND.EFFECTIVE_DATE BETWEEN FF.EFFECTIVE_START_DATE
AND FF.EFFECTIVE_END_DATE))