[Home] [Help]
View: PAY_NL_SI_INFO_ACTION_INFO_V
View Text
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'
Columns
| Name |
| ACTION_CONTEXT_ID |
| WAO |
| WW |
| ZFW |
| ZW |
| ADDITIONAL_SI1 |
| ADDITIONAL_SI2 |
| ADDITIONAL_SI3 |
| ADDITIONAL_SI4 |
| ADDITIONAL_SI5 |
| ADDITIONAL_SI6 |
| ADDITIONAL_SI7 |
| ADDITIONAL_SI8 |
| ADDITIONAL_SI9 |
| ADDITIONAL_SI10 |
APPS.PAY_NL_SI_INFO_ACTION_INFO_V