VIEW: APPS.PER_ABS_ATTENDANCE_TYPES_V

Source

View Text - Preformatted

SELECT ABT.ROWID , ABT.ABSENCE_ATTENDANCE_TYPE_ID , ABT.BUSINESS_GROUP_ID , ABT.INPUT_VALUE_ID , ABT.DATE_EFFECTIVE , ABTL.NAME , ABT.ABSENCE_CATEGORY , ABT.COMMENTS , ABT.DATE_END , ABT.HOURS_OR_DAYS , ABT.INCREASING_OR_DECREASING_FLAG , ABT.REQUEST_ID , ABT.PROGRAM_APPLICATION_ID , ABT.PROGRAM_ID , ABT.PROGRAM_UPDATE_DATE , ABT.ATTRIBUTE_CATEGORY , ABT.ATTRIBUTE1 , ABT.ATTRIBUTE2 , ABT.ATTRIBUTE3 , ABT.ATTRIBUTE4 , ABT.ATTRIBUTE5 , ABT.ATTRIBUTE6 , ABT.ATTRIBUTE7 , ABT.ATTRIBUTE8 , ABT.ATTRIBUTE9 , ABT.ATTRIBUTE10 , ABT.ATTRIBUTE11 , ABT.ATTRIBUTE12 , ABT.ATTRIBUTE13 , ABT.ATTRIBUTE14 , ABT.ATTRIBUTE15 , ABT.ATTRIBUTE16 , ABT.ATTRIBUTE17 , ABT.ATTRIBUTE18 , ABT.ATTRIBUTE19 , ABT.ATTRIBUTE20 , ABT.LAST_UPDATE_DATE , ABT.LAST_UPDATED_BY , ABT.LAST_UPDATE_LOGIN , ABT.CREATED_BY , ABT.CREATION_DATE , LKP1.MEANING , LKP2.MEANING , LKP3.MEANING , ELTTL.ELEMENT_NAME , IPV.ELEMENT_TYPE_ID , IPVTL.NAME , IPV.UOM , ABT.OBJECT_VERSION_NUMBER , ABT.INFORMATION_CATEGORY , ABT.INFORMATION1 , ABT.INFORMATION2 , ABT.INFORMATION3 , ABT.INFORMATION4 , ABT.INFORMATION5 , ABT.INFORMATION6 , ABT.INFORMATION7 , ABT.INFORMATION8 , ABT.INFORMATION9 , ABT.INFORMATION10 , ABT.INFORMATION11 , ABT.INFORMATION12 , ABT.INFORMATION13 , ABT.INFORMATION14 , ABT.INFORMATION15 , ABT.INFORMATION16 , ABT.INFORMATION17 , ABT.INFORMATION18 , ABT.INFORMATION19 , ABT.INFORMATION20 ,ABT.USER_ROLE ,ABT.ASSIGNMENT_STATUS_TYPE_ID ,ABT.ADVANCE_PAY ,ABT.ABSENCE_OVERLAP_FLAG FROM PER_ABSENCE_ATTENDANCE_TYPES ABT , PER_ABS_ATTENDANCE_TYPES_TL ABTL, PAY_INPUT_VALUES_F IPV , PAY_INPUT_VALUES_F_TL IPVTL , PAY_ELEMENT_TYPES_F ELT , PAY_ELEMENT_TYPES_F_TL ELTTL , HR_LOOKUPS LKP1 , HR_LOOKUPS LKP2 , HR_LOOKUPS LKP3 WHERE ABT.INPUT_VALUE_ID = IPV.INPUT_VALUE_ID(+) AND IPV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID(+) AND ELT.element_type_id = ELTTL.element_type_id(+) AND IPV.input_value_id = IPVTL.input_value_id(+) AND ABT.INCREASING_OR_DECREASING_FLAG = LKP2.LOOKUP_CODE(+) AND ABT.ABSENCE_CATEGORY = LKP3.LOOKUP_CODE(+) AND ABT.HOURS_OR_DAYS = LKP1.LOOKUP_CODE(+) AND LKP1.LOOKUP_TYPE(+) = 'HOURS_OR_DAYS' AND LKP2.LOOKUP_TYPE(+) = 'INCREASING_OR_DECREASING' AND LKP3.LOOKUP_TYPE(+) = 'ABSENCE_CATEGORY' AND ABT.DATE_EFFECTIVE BETWEEN NVL(IPV.EFFECTIVE_START_DATE, ABT.DATE_EFFECTIVE) AND NVL(IPV.EFFECTIVE_END_DATE, ABT.DATE_EFFECTIVE) AND ABT.DATE_EFFECTIVE BETWEEN NVL(ELT.EFFECTIVE_START_DATE, ABT.DATE_EFFECTIVE) AND NVL(ELT.EFFECTIVE_END_DATE, ABT.DATE_EFFECTIVE) AND decode(elt.element_type_id, null, '1', ELTTL.language) = decode (elt.element_type_id, null, '1', userenv('LANG')) AND decode( ipvtl.input_value_id, null, '1', IPVTL.language) = decode(ipvtl.input_value_id, null, '1', userenv('LANG')) AND ABTL.ABSENCE_ATTENDANCE_TYPE_ID = ABT.ABSENCE_ATTENDANCE_TYPE_ID AND ABTL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT ABT.ROWID
, ABT.ABSENCE_ATTENDANCE_TYPE_ID
, ABT.BUSINESS_GROUP_ID
, ABT.INPUT_VALUE_ID
, ABT.DATE_EFFECTIVE
, ABTL.NAME
, ABT.ABSENCE_CATEGORY
, ABT.COMMENTS
, ABT.DATE_END
, ABT.HOURS_OR_DAYS
, ABT.INCREASING_OR_DECREASING_FLAG
, ABT.REQUEST_ID
, ABT.PROGRAM_APPLICATION_ID
, ABT.PROGRAM_ID
, ABT.PROGRAM_UPDATE_DATE
, ABT.ATTRIBUTE_CATEGORY
, ABT.ATTRIBUTE1
, ABT.ATTRIBUTE2
, ABT.ATTRIBUTE3
, ABT.ATTRIBUTE4
, ABT.ATTRIBUTE5
, ABT.ATTRIBUTE6
, ABT.ATTRIBUTE7
, ABT.ATTRIBUTE8
, ABT.ATTRIBUTE9
, ABT.ATTRIBUTE10
, ABT.ATTRIBUTE11
, ABT.ATTRIBUTE12
, ABT.ATTRIBUTE13
, ABT.ATTRIBUTE14
, ABT.ATTRIBUTE15
, ABT.ATTRIBUTE16
, ABT.ATTRIBUTE17
, ABT.ATTRIBUTE18
, ABT.ATTRIBUTE19
, ABT.ATTRIBUTE20
, ABT.LAST_UPDATE_DATE
, ABT.LAST_UPDATED_BY
, ABT.LAST_UPDATE_LOGIN
, ABT.CREATED_BY
, ABT.CREATION_DATE
, LKP1.MEANING
, LKP2.MEANING
, LKP3.MEANING
, ELTTL.ELEMENT_NAME
, IPV.ELEMENT_TYPE_ID
, IPVTL.NAME
, IPV.UOM
, ABT.OBJECT_VERSION_NUMBER
, ABT.INFORMATION_CATEGORY
, ABT.INFORMATION1
, ABT.INFORMATION2
, ABT.INFORMATION3
, ABT.INFORMATION4
, ABT.INFORMATION5
, ABT.INFORMATION6
, ABT.INFORMATION7
, ABT.INFORMATION8
, ABT.INFORMATION9
, ABT.INFORMATION10
, ABT.INFORMATION11
, ABT.INFORMATION12
, ABT.INFORMATION13
, ABT.INFORMATION14
, ABT.INFORMATION15
, ABT.INFORMATION16
, ABT.INFORMATION17
, ABT.INFORMATION18
, ABT.INFORMATION19
, ABT.INFORMATION20
, ABT.USER_ROLE
, ABT.ASSIGNMENT_STATUS_TYPE_ID
, ABT.ADVANCE_PAY
, ABT.ABSENCE_OVERLAP_FLAG
FROM PER_ABSENCE_ATTENDANCE_TYPES ABT
, PER_ABS_ATTENDANCE_TYPES_TL ABTL
, PAY_INPUT_VALUES_F IPV
, PAY_INPUT_VALUES_F_TL IPVTL
, PAY_ELEMENT_TYPES_F ELT
, PAY_ELEMENT_TYPES_F_TL ELTTL
, HR_LOOKUPS LKP1
, HR_LOOKUPS LKP2
, HR_LOOKUPS LKP3
WHERE ABT.INPUT_VALUE_ID = IPV.INPUT_VALUE_ID(+)
AND IPV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID(+)
AND ELT.ELEMENT_TYPE_ID = ELTTL.ELEMENT_TYPE_ID(+)
AND IPV.INPUT_VALUE_ID = IPVTL.INPUT_VALUE_ID(+)
AND ABT.INCREASING_OR_DECREASING_FLAG = LKP2.LOOKUP_CODE(+)
AND ABT.ABSENCE_CATEGORY = LKP3.LOOKUP_CODE(+)
AND ABT.HOURS_OR_DAYS = LKP1.LOOKUP_CODE(+)
AND LKP1.LOOKUP_TYPE(+) = 'HOURS_OR_DAYS'
AND LKP2.LOOKUP_TYPE(+) = 'INCREASING_OR_DECREASING'
AND LKP3.LOOKUP_TYPE(+) = 'ABSENCE_CATEGORY'
AND ABT.DATE_EFFECTIVE BETWEEN NVL(IPV.EFFECTIVE_START_DATE
, ABT.DATE_EFFECTIVE)
AND NVL(IPV.EFFECTIVE_END_DATE
, ABT.DATE_EFFECTIVE)
AND ABT.DATE_EFFECTIVE BETWEEN NVL(ELT.EFFECTIVE_START_DATE
, ABT.DATE_EFFECTIVE)
AND NVL(ELT.EFFECTIVE_END_DATE
, ABT.DATE_EFFECTIVE)
AND DECODE(ELT.ELEMENT_TYPE_ID
, NULL
, '1'
, ELTTL.LANGUAGE) = DECODE (ELT.ELEMENT_TYPE_ID
, NULL
, '1'
, USERENV('LANG'))
AND DECODE( IPVTL.INPUT_VALUE_ID
, NULL
, '1'
, IPVTL.LANGUAGE) = DECODE(IPVTL.INPUT_VALUE_ID
, NULL
, '1'
, USERENV('LANG'))
AND ABTL.ABSENCE_ATTENDANCE_TYPE_ID = ABT.ABSENCE_ATTENDANCE_TYPE_ID
AND ABTL.LANGUAGE = USERENV('LANG')