VIEW: APPS.PAY_EMEA_USR_ELE_ACTION_INFO_V

Source

View Text - Preformatted

SELECT pai2.action_context_id, decode(pai2.action_information8,NULL,pai1.action_information4,pai1.action_information4 || '  (' || pai2.action_information8 || ')' ) narrative, pai2.action_information3 context, pai2.action_information9 context_description, decode(pai1.action_information6, 'D',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai2.action_information4)), pai2.action_information4) amount, pai2.action_information5 main_seq, pai2.action_information6 multi_seq, pai2.action_information7 column_seq FROM pay_action_information pai2, pay_assignment_actions apaa, pay_action_interlocks lck, pay_assignment_actions ppaa, pay_payroll_actions ppa, pay_action_information pai1 WHERE pai1.action_context_type = 'PA' AND pai1.action_information_category = 'EMEA ELEMENT DEFINITION' AND pai2.action_context_type = 'AAP' AND pai2.action_information_category = 'EMEA ELEMENT INFO' AND pai1.action_information2 = pai2.action_information1 AND pai1.action_information3 = pai2.action_information2 AND pai1.action_information5 = 'F' AND pai2.action_context_id = apaa.assignment_action_id AND NVL(apaa.source_action_id,apaa.assignment_action_id) = lck.locking_action_id AND lck.locked_action_id = ppaa.assignment_action_id AND ppaa.payroll_action_id = ppa.payroll_action_id AND ppa.action_type in ('P','U') AND ppa.payroll_action_id = NVL (pai1.action_information1,ppa.payroll_action_id) AND apaa.payroll_action_id = pai1.action_context_id AND ( (NVL(pai1.action_information7,pai2.action_information3)=pai2.action_information3) OR (pai1.action_information7 IS NULL and pai2.action_information3 IS NULL)) ORDER BY NVL(TO_NUMBER(pai2.action_information8),1) DESC, TO_NUMBER(pai2.action_information5), NVL(TO_NUMBER(pai2.action_information6),0), TO_NUMBER(pai2.action_information7)

View Text - HTML Formatted

SELECT PAI2.ACTION_CONTEXT_ID
, DECODE(PAI2.ACTION_INFORMATION8
, NULL
, PAI1.ACTION_INFORMATION4
, PAI1.ACTION_INFORMATION4 || ' (' || PAI2.ACTION_INFORMATION8 || ')' ) NARRATIVE
, PAI2.ACTION_INFORMATION3 CONTEXT
, PAI2.ACTION_INFORMATION9 CONTEXT_DESCRIPTION
, DECODE(PAI1.ACTION_INFORMATION6
, 'D'
, FND_DATE.DATE_TO_DISPLAYDATE(FND_DATE.CANONICAL_TO_DATE(PAI2.ACTION_INFORMATION4))
, PAI2.ACTION_INFORMATION4) AMOUNT
, PAI2.ACTION_INFORMATION5 MAIN_SEQ
, PAI2.ACTION_INFORMATION6 MULTI_SEQ
, PAI2.ACTION_INFORMATION7 COLUMN_SEQ
FROM PAY_ACTION_INFORMATION PAI2
, PAY_ASSIGNMENT_ACTIONS APAA
, PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS PPAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ACTION_INFORMATION PAI1
WHERE PAI1.ACTION_CONTEXT_TYPE = 'PA'
AND PAI1.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION'
AND PAI2.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI2.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT INFO'
AND PAI1.ACTION_INFORMATION2 = PAI2.ACTION_INFORMATION1
AND PAI1.ACTION_INFORMATION3 = PAI2.ACTION_INFORMATION2
AND PAI1.ACTION_INFORMATION5 = 'F'
AND PAI2.ACTION_CONTEXT_ID = APAA.ASSIGNMENT_ACTION_ID
AND NVL(APAA.SOURCE_ACTION_ID
, APAA.ASSIGNMENT_ACTION_ID) = LCK.LOCKING_ACTION_ID
AND LCK.LOCKED_ACTION_ID = PPAA.ASSIGNMENT_ACTION_ID
AND PPAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PPA.PAYROLL_ACTION_ID = NVL (PAI1.ACTION_INFORMATION1
, PPA.PAYROLL_ACTION_ID)
AND APAA.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND ( (NVL(PAI1.ACTION_INFORMATION7
, PAI2.ACTION_INFORMATION3)=PAI2.ACTION_INFORMATION3) OR (PAI1.ACTION_INFORMATION7 IS NULL
AND PAI2.ACTION_INFORMATION3 IS NULL)) ORDER BY NVL(TO_NUMBER(PAI2.ACTION_INFORMATION8)
, 1) DESC
, TO_NUMBER(PAI2.ACTION_INFORMATION5)
, NVL(TO_NUMBER(PAI2.ACTION_INFORMATION6)
, 0)
, TO_NUMBER(PAI2.ACTION_INFORMATION7)