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_IE_EAR_DED_V

Source

View Text - Preformatted


SELECT LCK.LOCKING_ACTION_ID ASSIGNMENT_ACTION_ID, SUBSTR(PAI.ACTION_INFORMATION4, 1,30) ELEMENT_NAME, SUBSTR(PAI.ACTION_INFORMATION5, 1,2) E_OR_D, PET.RESULT_VALUE ELEMENT_VALUE FROM PAY_ACTION_INTERLOCKS LCK, PAY_ACTION_INFORMATION PAI, PAY_IE_PAYMENT_VALUES_V PET, PAY_ASSIGNMENT_ACTIONS PAA1, PAY_ASSIGNMENT_ACTIONS PAA2 WHERE LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID /*AND PAI.ACTION_INFORMATION1 = PAA1.PAYROLL_ACTION_ID */ AND PAI.ACTION_CONTEXT_TYPE = 'PA' AND PAI.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION' AND PAA1.ASSIGNMENT_ACTION_ID = PET.ASSIGNMENT_ACTION_ID AND PET.ELEMENT_TYPE_ID = PAI.ACTION_INFORMATION2 AND PET.INPUT_VALUE_ID = PAI.ACTION_INFORMATION3 AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID AND PAA2.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID AND PAI.ACTION_INFORMATION1 IS NULL union all SELECT LCK.LOCKING_ACTION_ID ASSIGNMENT_ACTION_ID, SUBSTR(PAI.ACTION_INFORMATION4, 1,30) ELEMENT_NAME, SUBSTR(PAI.ACTION_INFORMATION5, 1,2) E_OR_D, PET.RESULT_VALUE ELEMENT_VALUE FROM PAY_ACTION_INTERLOCKS LCK, PAY_ACTION_INFORMATION PAI, PAY_IE_PAYMENT_VALUES_V PET, PAY_ASSIGNMENT_ACTIONS PAA1, PAY_ASSIGNMENT_ACTIONS PAA2 WHERE LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID AND PAI.ACTION_INFORMATION1 = PAA1.PAYROLL_ACTION_ID AND PAI.ACTION_CONTEXT_TYPE = 'PA' AND PAI.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION' AND PAA1.ASSIGNMENT_ACTION_ID = PET.ASSIGNMENT_ACTION_ID AND PET.ELEMENT_TYPE_ID = PAI.ACTION_INFORMATION2 AND PET.INPUT_VALUE_ID = PAI.ACTION_INFORMATION3 AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID AND PAA2.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID AND PAI.ACTION_INFORMATION1 IS NOT NULL

View Text - HTML Formatted

SELECT LCK.LOCKING_ACTION_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI.ACTION_INFORMATION4
, 1
, 30) ELEMENT_NAME
, SUBSTR(PAI.ACTION_INFORMATION5
, 1
, 2) E_OR_D
, PET.RESULT_VALUE ELEMENT_VALUE
FROM PAY_ACTION_INTERLOCKS LCK
, PAY_ACTION_INFORMATION PAI
, PAY_IE_PAYMENT_VALUES_V PET
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_ASSIGNMENT_ACTIONS PAA2
WHERE LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID /*AND PAI.ACTION_INFORMATION1 = PAA1.PAYROLL_ACTION_ID */
AND PAI.ACTION_CONTEXT_TYPE = 'PA'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION'
AND PAA1.ASSIGNMENT_ACTION_ID = PET.ASSIGNMENT_ACTION_ID
AND PET.ELEMENT_TYPE_ID = PAI.ACTION_INFORMATION2
AND PET.INPUT_VALUE_ID = PAI.ACTION_INFORMATION3
AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAI.ACTION_INFORMATION1 IS NULL UNION ALL SELECT LCK.LOCKING_ACTION_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI.ACTION_INFORMATION4
, 1
, 30) ELEMENT_NAME
, SUBSTR(PAI.ACTION_INFORMATION5
, 1
, 2) E_OR_D
, PET.RESULT_VALUE ELEMENT_VALUE
FROM PAY_ACTION_INTERLOCKS LCK
, PAY_ACTION_INFORMATION PAI
, PAY_IE_PAYMENT_VALUES_V PET
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_ASSIGNMENT_ACTIONS PAA2
WHERE LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID
AND PAI.ACTION_INFORMATION1 = PAA1.PAYROLL_ACTION_ID
AND PAI.ACTION_CONTEXT_TYPE = 'PA'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION'
AND PAA1.ASSIGNMENT_ACTION_ID = PET.ASSIGNMENT_ACTION_ID
AND PET.ELEMENT_TYPE_ID = PAI.ACTION_INFORMATION2
AND PET.INPUT_VALUE_ID = PAI.ACTION_INFORMATION3
AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAI.ACTION_INFORMATION1 IS NOT NULL