View: PER_CAGR_ENTITLEMENT_ITEMS_V

Product:	PER - Human Resources
Description:	Used to suppor Collective Agreements Entitlement Item User Interface
Implementation/DBA Data:	APPS.PER_CAGR_ENTITLEMENT_ITEMS_V

View Text

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.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

Columns