eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_JP_ITAX_ENTRIES_V

Source

View Text - Preformatted


SELECT /*+ ORDERED INDEX(FND FND_SESSIONS_U1) INDEX(PET PAY_ELEMENT_TYPES_F_UK2) INDEX(PEE PAY_ELEMENT_ENTRIES_F_N50) INDEX(PEL PAY_ELEMENT_LINKS_F_PK) INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) INDEX(PIV PAY_INPUT_VALUES_F_PK) */ 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)), min(distinct decode(piv.display_sequence,2,peev.input_value_id,NULL)), min(distinct decode(piv.display_sequence,3,peev.input_value_id,NULL)), min(distinct decode(piv.display_sequence,4,peev.input_value_id,NULL)), min(distinct decode(piv.display_sequence,5,peev.input_value_id,NULL)), min(distinct decode(piv.display_sequence,6,peev.input_value_id,NULL)), substrb(min(distinct decode(piv.display_sequence,1,peev.screen_entry_value,NULL)),1,30), min(distinct decode(piv.display_sequence,2,to_number(peev.screen_entry_value),NULL)), substrb(min(distinct decode(piv.display_sequence,3,peev.screen_entry_value,NULL)),1,30), substrb(min(distinct decode(piv.display_sequence,4,peev.screen_entry_value,NULL)),1,1), min(distinct decode(piv.display_sequence,5,to_number(peev.screen_entry_value),NULL)), substrb(min(distinct decode(piv.display_sequence,6,peev.screen_entry_value,NULL)),1,1), substrb(min(distinct decode(piv.display_sequence,1,hr_general.decode_lookup(piv.lookup_type,peev.screen_entry_value),NULL)),1,80), substrb(min(distinct decode(piv.display_sequence,2,hr_jp_general_pkg.decode_org(to_number(peev.screen_entry_value)),NULL)),1,240), substrb(min(distinct decode(piv.display_sequence,3,hr_general.decode_lookup(piv.lookup_type,peev.screen_entry_value),NULL)),1,80), min(distinct pee.creation_date), min(distinct pee.created_by), min(distinct pee.last_update_date), min(distinct pee.last_updated_by), min(distinct pee.last_update_login) from fnd_sessions fnd, pay_element_types_f pet, pay_element_entries_f pee, pay_element_links_f pel, pay_element_entry_values_f peev, pay_input_values_f piv where fnd.session_id = userenv('sessionid') and pet.element_name = 'COM_ITX_INFO' 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 /*+ ORDERED INDEX(FND FND_SESSIONS_U1) INDEX(PET PAY_ELEMENT_TYPES_F_UK2) INDEX(PEE PAY_ELEMENT_ENTRIES_F_N50) INDEX(PEL PAY_ELEMENT_LINKS_F_PK) INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) INDEX(PIV PAY_INPUT_VALUES_F_PK) */ 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))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, PEEV.INPUT_VALUE_ID
, NULL))
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, PEEV.INPUT_VALUE_ID
, NULL))
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 1
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 30)
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 30)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 4
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 1)
, MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 5
, TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 6
, PEEV.SCREEN_ENTRY_VALUE
, NULL))
, 1
, 1)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 1
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, 1
, 80)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 2
, HR_JP_GENERAL_PKG.DECODE_ORG(TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE))
, NULL))
, 1
, 240)
, SUBSTRB(MIN(DISTINCT DECODE(PIV.DISPLAY_SEQUENCE
, 3
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PEEV.SCREEN_ENTRY_VALUE)
, NULL))
, 1
, 80)
, MIN(DISTINCT PEE.CREATION_DATE)
, MIN(DISTINCT PEE.CREATED_BY)
, MIN(DISTINCT PEE.LAST_UPDATE_DATE)
, MIN(DISTINCT PEE.LAST_UPDATED_BY)
, MIN(DISTINCT PEE.LAST_UPDATE_LOGIN)
FROM FND_SESSIONS FND
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRY_VALUES_F PEEV
, PAY_INPUT_VALUES_F PIV
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND PET.ELEMENT_NAME = 'COM_ITX_INFO'
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