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_PAYMNTS_ACTION_INFO_V

Source

View Text - Preformatted


SELECT /*+ ORDERED INDEX(lck PAY_ACTION_INTERLOCKS_PK) INDEX(paa1 PAY_ASSIGNMENT_ACTIONS_PK) INDEX(paa2 PAY_ASSIGNMENT_ACTIONS_PK) INDEX(ppa PAY_PAYROLL_ACTIONS_PK) INDEX(pai PAY_ACTION_INFORMATION_N2) INDEX(pet.pac PAY_ACTION_INTERLOCKS_PK) INDEX(pet.paa PAY_ASSIGNMENT_ACTIONS_PK) INDEX(pet.ppa PAY_PAYROLL_ACTIONS_PK) INDEX(pet.pet PAY_ELEMENT_TYPES_F_PK) INDEX(pet.piv PAY_INPUT_VALUES_F_UK2) INDEX(pet.prr PAY_RUN_RESULTS_N50) INDEX(pet.prv PAY_RUN_RESULT_VALUES_PK) USE_NL(lck, paa1, paa2, ppa, pai) */ /* Hints added to resolve performance bug 2421978 */ lck.locking_action_id, pai.action_information4, pai.action_information5, pet.result_value value, pet.result_value FROM pay_action_interlocks lck, pay_assignment_actions paa1, pay_assignment_actions paa2, pay_payroll_actions ppa, pay_action_information pai, pay_emea_payment_values_v pet WHERE lck.locked_action_id = paa1.assignment_action_id AND paa1.source_action_id IS NULL AND paa1.payroll_action_id = ppa.payroll_action_id AND ppa.action_type IN ('P','U') AND ppa.payroll_action_id = NVL (pai.action_information1,ppa.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

View Text - HTML Formatted

SELECT /*+ ORDERED INDEX(LCK PAY_ACTION_INTERLOCKS_PK) INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PPA PAY_PAYROLL_ACTIONS_PK) INDEX(PAI PAY_ACTION_INFORMATION_N2) INDEX(PET.PAC PAY_ACTION_INTERLOCKS_PK) INDEX(PET.PAA PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PET.PPA PAY_PAYROLL_ACTIONS_PK) INDEX(PET.PET PAY_ELEMENT_TYPES_F_PK) INDEX(PET.PIV PAY_INPUT_VALUES_F_UK2) INDEX(PET.PRR PAY_RUN_RESULTS_N50) INDEX(PET.PRV PAY_RUN_RESULT_VALUES_PK) USE_NL(LCK
, PAA1
, PAA2
, PPA
, PAI) */ /* HINTS ADDED TO RESOLVE PERFORMANCE BUG 2421978 */ LCK.LOCKING_ACTION_ID
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION5
, PET.RESULT_VALUE VALUE
, PET.RESULT_VALUE
FROM PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PAYROLL_ACTIONS PPA
, PAY_ACTION_INFORMATION PAI
, PAY_EMEA_PAYMENT_VALUES_V PET
WHERE LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID
AND PAA1.SOURCE_ACTION_ID IS NULL
AND PAA1.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PPA.PAYROLL_ACTION_ID = NVL (PAI.ACTION_INFORMATION1
, PPA.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