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_NL_PAY_DED_ACTION_INFO_V

Source

View Text - Preformatted


SELECT PAI_1.ACTION_CONTEXT_ID Action_Context_Id ,PAI_1.ACTION_INFORMATION4 Main_Sequence ,PAI_1.ACTION_INFORMATION5 Sub_Sequence ,PAI_1.ACTION_INFORMATION6 Description ,PAI_1.ACTION_INFORMATION7 Extra_Info1 ,MAX(PAI_1.ACTION_INFORMATION8) Extra_Info2 ,PAI_1.action_information9 Extra_Info3 ,DECODE(MAX(PAI_1.ACTION_INFORMATION13),NULL, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION10)), MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION10)) ) Standard_Rate ,DECODE(MAX(PAI_1.ACTION_INFORMATION13),NULL, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION11)), MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION11)) ) Special_Rate ,DECODE(MAX(PAI_1.ACTION_INFORMATION13),NULL, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION12)), MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION12)) ) Payable ,MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION13)) Year FROM PAY_ACTION_INFORMATION PAI_1 /* AIC ---- NL Calculations */ WHERE /* AIC ---- NL Calculations */ PAI_1.ACTION_CONTEXT_TYPE = 'AAP' AND PAI_1.ACTION_INFORMATION_CATEGORY = 'NL CALCULATIONS' GROUP BY PAI_1.ACTION_CONTEXT_ID , PAI_1.ACTION_INFORMATION4, PAI_1.ACTION_INFORMATION5,PAI_1.ACTION_INFORMATION6,PAI_1.ACTION_INFORMATION7, PAI_1.action_information9,PAI_1.EFFECTIVE_DATE

View Text - HTML Formatted

SELECT PAI_1.ACTION_CONTEXT_ID ACTION_CONTEXT_ID
, PAI_1.ACTION_INFORMATION4 MAIN_SEQUENCE
, PAI_1.ACTION_INFORMATION5 SUB_SEQUENCE
, PAI_1.ACTION_INFORMATION6 DESCRIPTION
, PAI_1.ACTION_INFORMATION7 EXTRA_INFO1
, MAX(PAI_1.ACTION_INFORMATION8) EXTRA_INFO2
, PAI_1.ACTION_INFORMATION9 EXTRA_INFO3
, DECODE(MAX(PAI_1.ACTION_INFORMATION13)
, NULL
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION10))
, MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION10)) ) STANDARD_RATE
, DECODE(MAX(PAI_1.ACTION_INFORMATION13)
, NULL
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION11))
, MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION11)) ) SPECIAL_RATE
, DECODE(MAX(PAI_1.ACTION_INFORMATION13)
, NULL
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION12))
, MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION12)) ) PAYABLE
, MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION13)) YEAR
FROM PAY_ACTION_INFORMATION PAI_1 /* AIC ---- NL CALCULATIONS */
WHERE /* AIC ---- NL CALCULATIONS */ PAI_1.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_1.ACTION_INFORMATION_CATEGORY = 'NL CALCULATIONS' GROUP BY PAI_1.ACTION_CONTEXT_ID
, PAI_1.ACTION_INFORMATION4
, PAI_1.ACTION_INFORMATION5
, PAI_1.ACTION_INFORMATION6
, PAI_1.ACTION_INFORMATION7
, PAI_1.ACTION_INFORMATION9
, PAI_1.EFFECTIVE_DATE