VIEW: APPS.PAY_KR_DEPENDENT_V

Source

View Text - Preformatted

SELECT pee.element_entry_id, pee.effective_start_date, pee.effective_end_date, pee.assignment_id, pel.element_link_Id, pee.object_version_number, min(distinct decode(piv.display_sequence,1,peev.input_value_id,NULL)) INPUT_VALUE_ID1, min(distinct decode(piv.display_sequence,2,peev.input_value_id,NULL)) INPUT_VALUE_ID2, min(distinct decode(piv.display_sequence,3,peev.input_value_id,NULL)) INPUT_VALUE_ID3, min(distinct decode(piv.display_sequence,4,peev.input_value_id,NULL)) INPUT_VALUE_ID4, min(distinct decode(piv.display_sequence,5,peev.input_value_id,NULL)) INPUT_VALUE_ID5, min(distinct decode(piv.display_sequence,6,peev.input_value_id,NULL)) INPUT_VALUE_ID6, min(distinct decode(piv.display_sequence,7,peev.input_value_id,NULL)) INPUT_VALUE_ID7, min(distinct decode(piv.display_sequence,8,peev.input_value_id,NULL)) INPUT_VALUE_ID8, substrb(min(distinct decode(piv.display_sequence,1,peev.screen_entry_value,NULL)),1,1) ENTRY_VALUE1, min(distinct decode(piv.display_sequence,2,to_number(peev.screen_entry_value),NULL)) ENTRY_VALUE2, min(distinct decode(piv.display_sequence,3,to_number(peev.screen_entry_value),NULL)) ENTRY_VALUE3, min(distinct decode(piv.display_sequence,4,to_number(peev.screen_entry_value),NULL)) ENTRY_VALUE4, min(distinct decode(piv.display_sequence,5,to_number(peev.screen_entry_value),NULL)) ENTRY_VALUE5, min(distinct decode(piv.display_sequence,6,to_number(peev.screen_entry_value),NULL)) ENTRY_VALUE6, substrb(min(distinct decode(piv.display_sequence,7,peev.screen_entry_value,NULL)),1,1) ENTRY_VALUE7, min(distinct decode(piv.display_sequence,8,to_number(peev.screen_entry_value),NULL)) ENTRY_VALUE8, min(distinct pee.creation_date) CREATION_DATE, min(distinct pee.created_by) CREATED_BY, min(distinct pee.last_update_date) LAST_UPDATE_DATE, min(distinct pee.last_updated_by) LAST_UPDATED_BY, min(distinct pee.last_update_login) LAST_UPDATE_LOGIN from pay_input_values_f piv, pay_element_entry_values_f peev, pay_element_links_f pel, pay_element_entries_f pee, pay_element_types_f pet, fnd_sessions fnd where fnd.session_id = userenv('sessionid') and pet.element_name = 'DPNT_TAX_EXEM' and fnd.effective_date between pet.effective_start_date and pet.effective_end_date and pee.entry_type = 'E' and fnd.effective_date between pee.effective_start_date and pee.effective_end_date and pel.element_link_id = pee.element_link_id and pel.element_type_id + 0 = pet.element_type_id and fnd.effective_date between pel.effective_start_date and pel.effective_end_date and peev.element_entry_id = nvl(pee.element_entry_id,pel.element_link_id) and peev.effective_start_date = pee.effective_start_date and peev.effective_end_date = pee.effective_end_date and piv.input_value_id = peev.input_value_id and fnd.effective_date between piv.effective_start_date and piv.effective_end_date group by pee.element_entry_id, pee.effective_start_date, pee.effective_end_date, pee.assignment_id, pel.element_link_id, pee.object_version_number

View Text - HTML Formatted

SELECT PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEE.ASSIGNMENT_ID
, PEL.ELEMENT_LINK_ID
, PEE.OBJECT_VERSION_NUMBER
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 1
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID1
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID2
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID3
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID4
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID5
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID6
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 7
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID7
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 8
, PEEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID8
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 1
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 1) ENTRY_VALUE1
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE2
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE3
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE4
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE5
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE6
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 7
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 1) ENTRY_VALUE7
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 8
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL)) ENTRY_VALUE8
, MIN(DISTINCT PEE.CREATION_DATE) CREATION_DATE
, MIN(DISTINCT PEE.CREATED_BY) CREATED_BY
, MIN(DISTINCT PEE.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, MIN(DISTINCT PEE.LAST_UPDATED_BY) LAST_UPDATED_BY
, MIN(DISTINCT PEE.LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN
FROM PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_ENTRY_VALUES_F PEEV
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_TYPES_F PET
, FND_SESSIONS FND
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND PET.ELEMENT_NAME = 'DPNT_TAX_EXEM'
AND FND.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PEE.ENTRY_TYPE = 'E'
AND FND.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PEL.ELEMENT_TYPE_ID + 0 = PET.ELEMENT_TYPE_ID
AND FND.EFFECTIVE_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PEEV.ELEMENT_ENTRY_ID = NVL(PEE.ELEMENT_ENTRY_ID
, PEL.ELEMENT_LINK_ID)
AND PEEV.EFFECTIVE_START_DATE = PEE.EFFECTIVE_START_DATE
AND PEEV.EFFECTIVE_END_DATE = PEE.EFFECTIVE_END_DATE
AND PIV.INPUT_VALUE_ID = PEEV.INPUT_VALUE_ID
AND FND.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE GROUP BY PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEE.ASSIGNMENT_ID
, PEL.ELEMENT_LINK_ID
, PEE.OBJECT_VERSION_NUMBER