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_EMEA_PAYMENT_VALUES_V

Source

View Text - Preformatted


SELECT pet.rowid row_id, pet.element_type_id, piv.input_value_id, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) result_value, pet.processing_priority, pac.locking_action_id assignment_action_id FROM pay_action_interlocks pac, pay_assignment_actions paa, pay_payroll_actions ppa, pay_element_types_f pet, pay_input_values_f piv, pay_run_results prr, pay_run_result_values prv WHERE prr.element_type_id = pet.element_type_id AND prr.status IN ('P','PA') AND piv.element_type_id = pet.element_type_id AND prv.input_value_id = piv.input_value_id AND prv.run_result_id = prr.run_result_id AND piv.name = 'Pay Value' AND piv.uom = 'M' AND pac.locked_action_id = prr.assignment_action_id AND pac.locked_action_id = paa.assignment_action_id AND paa.payroll_action_id = ppa.payroll_action_id AND ppa.effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date AND ppa.effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date GROUP BY pac.locking_action_id, pet.processing_priority, pet.element_type_id, piv.input_value_id, pet.rowid

View Text - HTML Formatted

SELECT PET.ROWID ROW_ID
, PET.ELEMENT_TYPE_ID
, PIV.INPUT_VALUE_ID
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PRV.RESULT_VALUE)) RESULT_VALUE
, PET.PROCESSING_PRIORITY
, PAC.LOCKING_ACTION_ID ASSIGNMENT_ACTION_ID
FROM PAY_ACTION_INTERLOCKS PAC
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULTS PRR
, PAY_RUN_RESULT_VALUES PRV
WHERE PRR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRR.STATUS IN ('P'
, 'PA')
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID
AND PIV.NAME = 'PAY VALUE'
AND PIV.UOM = 'M'
AND PAC.LOCKED_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAC.LOCKED_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE GROUP BY PAC.LOCKING_ACTION_ID
, PET.PROCESSING_PRIORITY
, PET.ELEMENT_TYPE_ID
, PIV.INPUT_VALUE_ID
, PET.ROWID