VIEW: APPS.PAY_APAC_BALS_ACTION_INFO_V

Source

View Text - Preformatted

SELECT pai2.action_context_id, decode(pai2.action_information5,NULL,pai1.action_information4,pai1.action_information4 || '  (' || pai2.action_information5 || ')') narrative, pai2.action_information2 context, pai2.action_information6 context_description, fnd_number.canonical_to_number(pai2.action_information4) value FROM pay_action_information pai2, pay_action_interlocks lck, pay_assignment_actions paa1, pay_payroll_actions ppa, pay_assignment_actions paa2, pay_action_information pai1 WHERE pai1.action_context_type = 'PA' AND pai1.action_information_category = 'EMEA BALANCE DEFINITION' AND pai2.action_context_type = 'AAP' AND pai2.action_information_category = 'EMEA BALANCES' AND pai1.action_information2 = pai2.action_information1 AND pai2.action_context_id = paa2.assignment_action_id AND nvl(paa2.source_action_id,paa2.assignment_action_id) = lck.locking_action_id AND 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 (pai1.action_information1,ppa.payroll_action_id) AND paa2.payroll_action_id = pai1.action_context_id AND ((nvl(pai1.action_information6,pai2.action_information2)=pai2.action_information2) OR (pai1.action_information6 IS NULL and pai2.action_information2 IS NULL)) ORDER BY nvl(to_number(pai2.action_information5),1) desc, pai2.action_information_id

View Text - HTML Formatted

SELECT PAI2.ACTION_CONTEXT_ID
, DECODE(PAI2.ACTION_INFORMATION5
, NULL
, PAI1.ACTION_INFORMATION4
, PAI1.ACTION_INFORMATION4 || ' (' || PAI2.ACTION_INFORMATION5 || ')') NARRATIVE
, PAI2.ACTION_INFORMATION2 CONTEXT
, PAI2.ACTION_INFORMATION6 CONTEXT_DESCRIPTION
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI2.ACTION_INFORMATION4) VALUE
FROM PAY_ACTION_INFORMATION PAI2
, PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_ACTION_INFORMATION PAI1
WHERE PAI1.ACTION_CONTEXT_TYPE = 'PA'
AND PAI1.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCE DEFINITION'
AND PAI2.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI2.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCES'
AND PAI1.ACTION_INFORMATION2 = PAI2.ACTION_INFORMATION1
AND PAI2.ACTION_CONTEXT_ID = PAA2.ASSIGNMENT_ACTION_ID
AND NVL(PAA2.SOURCE_ACTION_ID
, PAA2.ASSIGNMENT_ACTION_ID) = LCK.LOCKING_ACTION_ID
AND 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 (PAI1.ACTION_INFORMATION1
, PPA.PAYROLL_ACTION_ID)
AND PAA2.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND ((NVL(PAI1.ACTION_INFORMATION6
, PAI2.ACTION_INFORMATION2)=PAI2.ACTION_INFORMATION2) OR (PAI1.ACTION_INFORMATION6 IS NULL
AND PAI2.ACTION_INFORMATION2 IS NULL)) ORDER BY NVL(TO_NUMBER(PAI2.ACTION_INFORMATION5)
, 1) DESC
, PAI2.ACTION_INFORMATION_ID