VIEW: APPS.PAY_NL_SI_INFO_ACTION_INFO_V

Source

View Text - Preformatted

SELECT PAI_NL_SI_EMP.ACTION_CONTEXT_ID Action_Context_Id ,PAI_NL_SI_EMP.ACTION_INFORMATION4 WAO ,PAI_NL_SI_EMP.ACTION_INFORMATION5 WW ,PAI_NL_SI_EMP.ACTION_INFORMATION6 ZFW ,PAI_NL_SI_EMP.ACTION_INFORMATION7 ZW ,PAI_NL_SI_EMP.ACTION_INFORMATION8 Additional_SI1 ,PAI_NL_SI_EMP.ACTION_INFORMATION9 Additional_SI2 ,PAI_NL_SI_EMP.ACTION_INFORMATION10 Additional_SI3 ,PAI_NL_SI_EMP.ACTION_INFORMATION11 Additional_SI4 ,PAI_NL_SI_EMP.ACTION_INFORMATION12 Additional_SI5 ,PAI_NL_SI_EMP.ACTION_INFORMATION13 Additional_SI6 ,PAI_NL_SI_EMP.ACTION_INFORMATION14 Additional_SI7 ,PAI_NL_SI_EMP.ACTION_INFORMATION15 Additional_SI8 ,PAI_NL_SI_EMP.ACTION_INFORMATION16 Additional_SI9 ,PAI_NL_SI_EMP.ACTION_INFORMATION17 Additional_SI10 FROM PAY_ACTION_INFORMATION PAI_NL_SI_EMP /* AIC ---- NL SI Employee Details*/ WHERE PAI_NL_SI_EMP.ACTION_CONTEXT_TYPE = 'AAP' AND PAI_NL_SI_EMP.ACTION_INFORMATION_CATEGORY = 'NL SI EMPLOYEE DETAILS'

View Text - HTML Formatted

SELECT PAI_NL_SI_EMP.ACTION_CONTEXT_ID ACTION_CONTEXT_ID
, PAI_NL_SI_EMP.ACTION_INFORMATION4 WAO
, PAI_NL_SI_EMP.ACTION_INFORMATION5 WW
, PAI_NL_SI_EMP.ACTION_INFORMATION6 ZFW
, PAI_NL_SI_EMP.ACTION_INFORMATION7 ZW
, PAI_NL_SI_EMP.ACTION_INFORMATION8 ADDITIONAL_SI1
, PAI_NL_SI_EMP.ACTION_INFORMATION9 ADDITIONAL_SI2
, PAI_NL_SI_EMP.ACTION_INFORMATION10 ADDITIONAL_SI3
, PAI_NL_SI_EMP.ACTION_INFORMATION11 ADDITIONAL_SI4
, PAI_NL_SI_EMP.ACTION_INFORMATION12 ADDITIONAL_SI5
, PAI_NL_SI_EMP.ACTION_INFORMATION13 ADDITIONAL_SI6
, PAI_NL_SI_EMP.ACTION_INFORMATION14 ADDITIONAL_SI7
, PAI_NL_SI_EMP.ACTION_INFORMATION15 ADDITIONAL_SI8
, PAI_NL_SI_EMP.ACTION_INFORMATION16 ADDITIONAL_SI9
, PAI_NL_SI_EMP.ACTION_INFORMATION17 ADDITIONAL_SI10
FROM PAY_ACTION_INFORMATION PAI_NL_SI_EMP /* AIC ---- NL SI EMPLOYEE DETAILS*/
WHERE PAI_NL_SI_EMP.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_NL_SI_EMP.ACTION_INFORMATION_CATEGORY = 'NL SI EMPLOYEE DETAILS'