[Home] [Help]
View: PAY_WNU_ASG_INFO_V
View Text
SELECT AEI.ASSIGNMENT_EXTRA_INFO_ID WNU_ASG_EXTRA_INFO_ID
, AEI.ASSIGNMENT_ID ASSIGNMENT_ID
, AEI.INFORMATION_TYPE INFORMATION_TYPE
, AEI.AEI_INFORMATION_CATEGORY AEI_INFORMATION_CATEGORY
, AEI.OBJECT_VERSION_NUMBER WNU_OBJECT_VERSION_NUM
, AEI.AEI_INFORMATION1 PREVIOUS_ASSIGNMENT_NUMBER
, AEI.AEI_INFORMATION2 NOT_INCLUDED_IN_WNU
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
WHERE AEI. INFORMATION_TYPE = 'GB_WNU'
Columns
Name |
WNU_ASG_EXTRA_INFO_ID |
ASSIGNMENT_ID |
INFORMATION_TYPE |
AEI_INFORMATION_CATEGORY |
WNU_OBJECT_VERSION_NUM |
PREVIOUS_ASSIGNMENT_NUMBER |
NOT_INCLUDED_IN_WNU |