VIEW: APPS.PER_CAGR_ENTITLEMENT_ITEMS_V

Source

View Text - Preformatted

SELECT CEI.CAGR_ENTITLEMENT_ITEM_ID, CEI.BUSINESS_GROUP_ID, NVL(CEITL.ITEM_NAME,CEI.ITEM_NAME) ITEM_NAME, CEI.ELEMENT_TYPE_ID, PET.ELEMENT_NAME, CEI.INPUT_VALUE_ID, PIV.NAME INPUT_VALUE_NAME, CEI.LEGISLATION_CODE, CEI.BENEFICIAL_RULE, SUBSTR(hr_general.decode_lookup('CAGR_BENEFICIAL_RULE', CEI.BENEFICIAL_RULE), 1, 80) BENEFICIAL_RULE_DESC, CEI.CAGR_API_ID, PCA.API_NAME, CEI.CAGR_API_PARAM_ID, CEI.COLUMN_TYPE, SUBSTR(hr_general.decode_lookup('CAGR_PARAM_TYPES', CEI.COLUMN_TYPE), 1, 80) COLUMN_TYPE_DESC, CEI.COLUMN_SIZE COLUMN_SIZE, CAP.DISPLAY_NAME, CEI.CATEGORY_NAME, SUBSTR(hr_general.decode_lookup('CAGR_CATEGORIES', CEI.CATEGORY_NAME), 1, 80) CATEGORY_NAME_DESC, CEI.BENEFICIAL_FORMULA_ID, CEI.UOM, SUBSTR(hr_general.decode_lookup(NVL(CAP.UOM_LOOKUP,'UNITS'), CEI.UOM), 1, 80) UOM_DESC, CEI.FLEX_VALUE_SET_ID, CAP.DEFAULT_UOM, F.FLEX_VALUE_SET_NAME, CEI.MULTIPLE_ENTRIES_ALLOWED_FLAG, CEI.AUTO_CREATE_ENTRIES_FLAG, CEI.BENEFICIAL_RULE_VALUE_SET_ID, B.FLEX_VALUE_SET_NAME BENEFICIAL_RULE_VALUE_SET, CAP.UOM_PARAMETER UOM_PARAMETER, CAP.UOM_LOOKUP PARAMETER_LOOKUP_TYPE, CEI.OBJECT_VERSION_NUMBER, CEI.LAST_UPDATE_DATE, CEI.LAST_UPDATED_BY, CEI.LAST_UPDATE_LOGIN, CEI.CREATED_BY, CEI.CREATION_DATE FROM per_cagr_entitlement_items cei, per_cagr_entitlement_items_tl ceitl, per_cagr_apis pca, per_cagr_api_parameters cap, pay_element_types_v pet, PAY_INPUT_VALUES_V PIV , FND_FLEX_VALUE_SETS F, FND_FLEX_VALUE_SETS B WHERE F.FLEX_VALUE_SET_ID (+) = cei.FLEX_VALUE_SET_ID AND B.FLEX_VALUE_SET_ID(+) = cei.beneficial_rule_value_set_id AND pca.cagr_api_id (+) = cei.cagr_api_id AND ceitl.language = USERENV('LANG') AND ceitl.cagr_entitlement_item_id (+) = cei.cagr_entitlement_item_id AND cap.cagr_api_param_id (+) = cei.cagr_api_param_id AND pet.element_type_id (+) = cei.element_type_id AND piv.input_value_id (+) = cei.input_value_id

View Text - HTML Formatted

SELECT CEI.CAGR_ENTITLEMENT_ITEM_ID
, CEI.BUSINESS_GROUP_ID
, NVL(CEITL.ITEM_NAME
, CEI.ITEM_NAME) ITEM_NAME
, CEI.ELEMENT_TYPE_ID
, PET.ELEMENT_NAME
, CEI.INPUT_VALUE_ID
, PIV.NAME INPUT_VALUE_NAME
, CEI.LEGISLATION_CODE
, CEI.BENEFICIAL_RULE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_BENEFICIAL_RULE'
, CEI.BENEFICIAL_RULE)
, 1
, 80) BENEFICIAL_RULE_DESC
, CEI.CAGR_API_ID
, PCA.API_NAME
, CEI.CAGR_API_PARAM_ID
, CEI.COLUMN_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_PARAM_TYPES'
, CEI.COLUMN_TYPE)
, 1
, 80) COLUMN_TYPE_DESC
, CEI.COLUMN_SIZE COLUMN_SIZE
, CAP.DISPLAY_NAME
, CEI.CATEGORY_NAME
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_CATEGORIES'
, CEI.CATEGORY_NAME)
, 1
, 80) CATEGORY_NAME_DESC
, CEI.BENEFICIAL_FORMULA_ID
, CEI.UOM
, SUBSTR(HR_GENERAL.DECODE_LOOKUP(NVL(CAP.UOM_LOOKUP
, 'UNITS')
, CEI.UOM)
, 1
, 80) UOM_DESC
, CEI.FLEX_VALUE_SET_ID
, CAP.DEFAULT_UOM
, F.FLEX_VALUE_SET_NAME
, CEI.MULTIPLE_ENTRIES_ALLOWED_FLAG
, CEI.AUTO_CREATE_ENTRIES_FLAG
, CEI.BENEFICIAL_RULE_VALUE_SET_ID
, B.FLEX_VALUE_SET_NAME BENEFICIAL_RULE_VALUE_SET
, CAP.UOM_PARAMETER UOM_PARAMETER
, CAP.UOM_LOOKUP PARAMETER_LOOKUP_TYPE
, CEI.OBJECT_VERSION_NUMBER
, CEI.LAST_UPDATE_DATE
, CEI.LAST_UPDATED_BY
, CEI.LAST_UPDATE_LOGIN
, CEI.CREATED_BY
, CEI.CREATION_DATE
FROM PER_CAGR_ENTITLEMENT_ITEMS CEI
, PER_CAGR_ENTITLEMENT_ITEMS_TL CEITL
, PER_CAGR_APIS PCA
, PER_CAGR_API_PARAMETERS CAP
, PAY_ELEMENT_TYPES_V PET
, PAY_INPUT_VALUES_V PIV
, FND_FLEX_VALUE_SETS F
, FND_FLEX_VALUE_SETS B
WHERE F.FLEX_VALUE_SET_ID (+) = CEI.FLEX_VALUE_SET_ID
AND B.FLEX_VALUE_SET_ID(+) = CEI.BENEFICIAL_RULE_VALUE_SET_ID
AND PCA.CAGR_API_ID (+) = CEI.CAGR_API_ID
AND CEITL.LANGUAGE = USERENV('LANG')
AND CEITL.CAGR_ENTITLEMENT_ITEM_ID (+) = CEI.CAGR_ENTITLEMENT_ITEM_ID
AND CAP.CAGR_API_PARAM_ID (+) = CEI.CAGR_API_PARAM_ID
AND PET.ELEMENT_TYPE_ID (+) = CEI.ELEMENT_TYPE_ID
AND PIV.INPUT_VALUE_ID (+) = CEI.INPUT_VALUE_ID