DBA Data[Home] [Help] [Dependency Information]


VIEW: HR.HR_DU_UPLOAD_LINES#

Object Details
Object Name: HR_DU_UPLOAD_LINES#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
UPLOAD_LINE_ID NUMBER (15) Yes
UPLOAD_HEADER_ID NUMBER (15) Yes
BATCH_LINE_ID NUMBER (15)
STATUS VARCHAR2 (30) Yes
ORIGINAL_UPLOAD_HEADER_ID NUMBER (15)
REFERENCE_TYPE VARCHAR2 (30) Yes
PVAL001 VARCHAR2 (2000)
PVAL002 VARCHAR2 (2000)
PVAL003 VARCHAR2 (2000)
PVAL004 VARCHAR2 (2000)
PVAL005 VARCHAR2 (2000)
PVAL006 VARCHAR2 (2000)
PVAL007 VARCHAR2 (2000)
PVAL008 VARCHAR2 (2000)
PVAL009 VARCHAR2 (2000)
PVAL010 VARCHAR2 (2000)
PVAL011 VARCHAR2 (2000)
PVAL012 VARCHAR2 (2000)
PVAL013 VARCHAR2 (2000)
PVAL014 VARCHAR2 (2000)
PVAL015 VARCHAR2 (2000)
PVAL016 VARCHAR2 (2000)
PVAL017 VARCHAR2 (2000)
PVAL018 VARCHAR2 (2000)
PVAL019 VARCHAR2 (2000)
PVAL020 VARCHAR2 (2000)
PVAL021 VARCHAR2 (2000)
PVAL022 VARCHAR2 (2000)
PVAL023 VARCHAR2 (2000)
PVAL024 VARCHAR2 (2000)
PVAL025 VARCHAR2 (2000)
PVAL026 VARCHAR2 (2000)
PVAL027 VARCHAR2 (2000)
PVAL028 VARCHAR2 (2000)
PVAL029 VARCHAR2 (2000)
PVAL030 VARCHAR2 (2000)
PVAL031 VARCHAR2 (2000)
PVAL032 VARCHAR2 (2000)
PVAL033 VARCHAR2 (2000)
PVAL034 VARCHAR2 (2000)
PVAL035 VARCHAR2 (2000)
PVAL036 VARCHAR2 (2000)
PVAL037 VARCHAR2 (2000)
PVAL038 VARCHAR2 (2000)
PVAL039 VARCHAR2 (2000)
PVAL040 VARCHAR2 (2000)
PVAL041 VARCHAR2 (2000)
PVAL042 VARCHAR2 (2000)
PVAL043 VARCHAR2 (2000)
PVAL044 VARCHAR2 (2000)
PVAL045 VARCHAR2 (2000)
PVAL046 VARCHAR2 (2000)
PVAL047 VARCHAR2 (2000)
PVAL048 VARCHAR2 (2000)
PVAL049 VARCHAR2 (2000)
PVAL050 VARCHAR2 (2000)
PVAL051 VARCHAR2 (2000)
PVAL052 VARCHAR2 (2000)
PVAL053 VARCHAR2 (2000)
PVAL054 VARCHAR2 (2000)
PVAL055 VARCHAR2 (2000)
PVAL056 VARCHAR2 (2000)
PVAL057 VARCHAR2 (2000)
PVAL058 VARCHAR2 (2000)
PVAL059 VARCHAR2 (2000)
PVAL060 VARCHAR2 (2000)
PVAL061 VARCHAR2 (2000)
PVAL062 VARCHAR2 (2000)
PVAL063 VARCHAR2 (2000)
PVAL064 VARCHAR2 (2000)
PVAL065 VARCHAR2 (2000)
PVAL066 VARCHAR2 (2000)
PVAL067 VARCHAR2 (2000)
PVAL068 VARCHAR2 (2000)
PVAL069 VARCHAR2 (2000)
PVAL070 VARCHAR2 (2000)
PVAL071 VARCHAR2 (2000)
PVAL072 VARCHAR2 (2000)
PVAL073 VARCHAR2 (2000)
PVAL074 VARCHAR2 (2000)
PVAL075 VARCHAR2 (2000)
PVAL076 VARCHAR2 (2000)
PVAL077 VARCHAR2 (2000)
PVAL078 VARCHAR2 (2000)
PVAL079 VARCHAR2 (2000)
PVAL080 VARCHAR2 (2000)
PVAL081 VARCHAR2 (2000)
PVAL082 VARCHAR2 (2000)
PVAL083 VARCHAR2 (2000)
PVAL084 VARCHAR2 (2000)
PVAL085 VARCHAR2 (2000)
PVAL086 VARCHAR2 (2000)
PVAL087 VARCHAR2 (2000)
PVAL088 VARCHAR2 (2000)
PVAL089 VARCHAR2 (2000)
PVAL090 VARCHAR2 (2000)
PVAL091 VARCHAR2 (2000)
PVAL092 VARCHAR2 (2000)
PVAL093 VARCHAR2 (2000)
PVAL094 VARCHAR2 (2000)
PVAL095 VARCHAR2 (2000)
PVAL096 VARCHAR2 (2000)
PVAL097 VARCHAR2 (2000)
PVAL098 VARCHAR2 (2000)
PVAL099 VARCHAR2 (2000)
PVAL100 VARCHAR2 (2000)
PVAL101 VARCHAR2 (2000)
PVAL102 VARCHAR2 (2000)
PVAL103 VARCHAR2 (2000)
PVAL104 VARCHAR2 (2000)
PVAL105 VARCHAR2 (2000)
PVAL106 VARCHAR2 (2000)
PVAL107 VARCHAR2 (2000)
PVAL108 VARCHAR2 (2000)
PVAL109 VARCHAR2 (2000)
PVAL110 VARCHAR2 (2000)
PVAL111 VARCHAR2 (2000)
PVAL112 VARCHAR2 (2000)
PVAL113 VARCHAR2 (2000)
PVAL114 VARCHAR2 (2000)
PVAL115 VARCHAR2 (2000)
PVAL116 VARCHAR2 (2000)
PVAL117 VARCHAR2 (2000)
PVAL118 VARCHAR2 (2000)
PVAL119 VARCHAR2 (2000)
PVAL120 VARCHAR2 (2000)
PVAL121 VARCHAR2 (2000)
PVAL122 VARCHAR2 (2000)
PVAL123 VARCHAR2 (2000)
PVAL124 VARCHAR2 (2000)
PVAL125 VARCHAR2 (2000)
PVAL126 VARCHAR2 (2000)
PVAL127 VARCHAR2 (2000)
PVAL128 VARCHAR2 (2000)
PVAL129 VARCHAR2 (2000)
PVAL130 VARCHAR2 (2000)
PVAL131 VARCHAR2 (2000)
PVAL132 VARCHAR2 (2000)
PVAL133 VARCHAR2 (2000)
PVAL134 VARCHAR2 (2000)
PVAL135 VARCHAR2 (2000)
PVAL136 VARCHAR2 (2000)
PVAL137 VARCHAR2 (2000)
PVAL138 VARCHAR2 (2000)
PVAL139 VARCHAR2 (2000)
PVAL140 VARCHAR2 (2000)
PVAL141 VARCHAR2 (2000)
PVAL142 VARCHAR2 (2000)
PVAL143 VARCHAR2 (2000)
PVAL144 VARCHAR2 (2000)
PVAL145 VARCHAR2 (2000)
PVAL146 VARCHAR2 (2000)
PVAL147 VARCHAR2 (2000)
PVAL148 VARCHAR2 (2000)
PVAL149 VARCHAR2 (2000)
PVAL150 VARCHAR2 (2000)
PVAL151 VARCHAR2 (2000)
PVAL152 VARCHAR2 (2000)
PVAL153 VARCHAR2 (2000)
PVAL154 VARCHAR2 (2000)
PVAL155 VARCHAR2 (2000)
PVAL156 VARCHAR2 (2000)
PVAL157 VARCHAR2 (2000)
PVAL158 VARCHAR2 (2000)
PVAL159 VARCHAR2 (2000)
PVAL160 VARCHAR2 (2000)
PVAL161 VARCHAR2 (2000)
PVAL162 VARCHAR2 (2000)
PVAL163 VARCHAR2 (2000)
PVAL164 VARCHAR2 (2000)
PVAL165 VARCHAR2 (2000)
PVAL166 VARCHAR2 (2000)
PVAL167 VARCHAR2 (2000)
PVAL168 VARCHAR2 (2000)
PVAL169 VARCHAR2 (2000)
PVAL170 VARCHAR2 (2000)
PVAL171 VARCHAR2 (2000)
PVAL172 VARCHAR2 (2000)
PVAL173 VARCHAR2 (2000)
PVAL174 VARCHAR2 (2000)
PVAL175 VARCHAR2 (2000)
PVAL176 VARCHAR2 (2000)
PVAL177 VARCHAR2 (2000)
PVAL178 VARCHAR2 (2000)
PVAL179 VARCHAR2 (2000)
PVAL180 VARCHAR2 (2000)
PVAL181 VARCHAR2 (2000)
PVAL182 VARCHAR2 (2000)
PVAL183 VARCHAR2 (2000)
PVAL184 VARCHAR2 (2000)
PVAL185 VARCHAR2 (2000)
PVAL186 VARCHAR2 (2000)
PVAL187 VARCHAR2 (2000)
PVAL188 VARCHAR2 (2000)
PVAL189 VARCHAR2 (2000)
PVAL190 VARCHAR2 (2000)
PVAL191 VARCHAR2 (2000)
PVAL192 VARCHAR2 (2000)
PVAL193 VARCHAR2 (2000)
PVAL194 VARCHAR2 (2000)
PVAL195 VARCHAR2 (2000)
PVAL196 VARCHAR2 (2000)
PVAL197 VARCHAR2 (2000)
PVAL198 VARCHAR2 (2000)
PVAL199 VARCHAR2 (2000)
PVAL200 VARCHAR2 (2000)
PVAL201 VARCHAR2 (2000)
PVAL202 VARCHAR2 (2000)
PVAL203 VARCHAR2 (2000)
PVAL204 VARCHAR2 (2000)
PVAL205 VARCHAR2 (2000)
PVAL206 VARCHAR2 (2000)
PVAL207 VARCHAR2 (2000)
PVAL208 VARCHAR2 (2000)
PVAL209 VARCHAR2 (2000)
PVAL210 VARCHAR2 (2000)
PVAL211 VARCHAR2 (2000)
PVAL212 VARCHAR2 (2000)
PVAL213 VARCHAR2 (2000)
PVAL214 VARCHAR2 (2000)
PVAL215 VARCHAR2 (2000)
PVAL216 VARCHAR2 (2000)
PVAL217 VARCHAR2 (2000)
PVAL218 VARCHAR2 (2000)
PVAL219 VARCHAR2 (2000)
PVAL220 VARCHAR2 (2000)
PVAL221 VARCHAR2 (2000)
PVAL222 VARCHAR2 (2000)
PVAL223 VARCHAR2 (2000)
PVAL224 VARCHAR2 (2000)
PVAL225 VARCHAR2 (2000)
PVAL226 VARCHAR2 (2000)
PVAL227 VARCHAR2 (2000)
PVAL228 VARCHAR2 (2000)
PVAL229 VARCHAR2 (2000)
PVAL230 VARCHAR2 (2000)
LINE_TYPE VARCHAR2 (1) Yes
DI_LINE_NUMBER NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

SECURITY_GROUP_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UPLOAD_LINE_ID
,      UPLOAD_HEADER_ID
,      BATCH_LINE_ID
,      STATUS
,      ORIGINAL_UPLOAD_HEADER_ID
,      REFERENCE_TYPE
,      PVAL001
,      PVAL002
,      PVAL003
,      PVAL004
,      PVAL005
,      PVAL006
,      PVAL007
,      PVAL008
,      PVAL009
,      PVAL010
,      PVAL011
,      PVAL012
,      PVAL013
,      PVAL014
,      PVAL015
,      PVAL016
,      PVAL017
,      PVAL018
,      PVAL019
,      PVAL020
,      PVAL021
,      PVAL022
,      PVAL023
,      PVAL024
,      PVAL025
,      PVAL026
,      PVAL027
,      PVAL028
,      PVAL029
,      PVAL030
,      PVAL031
,      PVAL032
,      PVAL033
,      PVAL034
,      PVAL035
,      PVAL036
,      PVAL037
,      PVAL038
,      PVAL039
,      PVAL040
,      PVAL041
,      PVAL042
,      PVAL043
,      PVAL044
,      PVAL045
,      PVAL046
,      PVAL047
,      PVAL048
,      PVAL049
,      PVAL050
,      PVAL051
,      PVAL052
,      PVAL053
,      PVAL054
,      PVAL055
,      PVAL056
,      PVAL057
,      PVAL058
,      PVAL059
,      PVAL060
,      PVAL061
,      PVAL062
,      PVAL063
,      PVAL064
,      PVAL065
,      PVAL066
,      PVAL067
,      PVAL068
,      PVAL069
,      PVAL070
,      PVAL071
,      PVAL072
,      PVAL073
,      PVAL074
,      PVAL075
,      PVAL076
,      PVAL077
,      PVAL078
,      PVAL079
,      PVAL080
,      PVAL081
,      PVAL082
,      PVAL083
,      PVAL084
,      PVAL085
,      PVAL086
,      PVAL087
,      PVAL088
,      PVAL089
,      PVAL090
,      PVAL091
,      PVAL092
,      PVAL093
,      PVAL094
,      PVAL095
,      PVAL096
,      PVAL097
,      PVAL098
,      PVAL099
,      PVAL100
,      PVAL101
,      PVAL102
,      PVAL103
,      PVAL104
,      PVAL105
,      PVAL106
,      PVAL107
,      PVAL108
,      PVAL109
,      PVAL110
,      PVAL111
,      PVAL112
,      PVAL113
,      PVAL114
,      PVAL115
,      PVAL116
,      PVAL117
,      PVAL118
,      PVAL119
,      PVAL120
,      PVAL121
,      PVAL122
,      PVAL123
,      PVAL124
,      PVAL125
,      PVAL126
,      PVAL127
,      PVAL128
,      PVAL129
,      PVAL130
,      PVAL131
,      PVAL132
,      PVAL133
,      PVAL134
,      PVAL135
,      PVAL136
,      PVAL137
,      PVAL138
,      PVAL139
,      PVAL140
,      PVAL141
,      PVAL142
,      PVAL143
,      PVAL144
,      PVAL145
,      PVAL146
,      PVAL147
,      PVAL148
,      PVAL149
,      PVAL150
,      PVAL151
,      PVAL152
,      PVAL153
,      PVAL154
,      PVAL155
,      PVAL156
,      PVAL157
,      PVAL158
,      PVAL159
,      PVAL160
,      PVAL161
,      PVAL162
,      PVAL163
,      PVAL164
,      PVAL165
,      PVAL166
,      PVAL167
,      PVAL168
,      PVAL169
,      PVAL170
,      PVAL171
,      PVAL172
,      PVAL173
,      PVAL174
,      PVAL175
,      PVAL176
,      PVAL177
,      PVAL178
,      PVAL179
,      PVAL180
,      PVAL181
,      PVAL182
,      PVAL183
,      PVAL184
,      PVAL185
,      PVAL186
,      PVAL187
,      PVAL188
,      PVAL189
,      PVAL190
,      PVAL191
,      PVAL192
,      PVAL193
,      PVAL194
,      PVAL195
,      PVAL196
,      PVAL197
,      PVAL198
,      PVAL199
,      PVAL200
,      PVAL201
,      PVAL202
,      PVAL203
,      PVAL204
,      PVAL205
,      PVAL206
,      PVAL207
,      PVAL208
,      PVAL209
,      PVAL210
,      PVAL211
,      PVAL212
,      PVAL213
,      PVAL214
,      PVAL215
,      PVAL216
,      PVAL217
,      PVAL218
,      PVAL219
,      PVAL220
,      PVAL221
,      PVAL222
,      PVAL223
,      PVAL224
,      PVAL225
,      PVAL226
,      PVAL227
,      PVAL228
,      PVAL229
,      PVAL230
,      LINE_TYPE
,      DI_LINE_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SECURITY_GROUP_ID
FROM HR.HR_DU_UPLOAD_LINES#;

Dependencies

[top of page]

HR.HR_DU_UPLOAD_LINES# references the following:

SchemaHR
TableHR_DU_UPLOAD_LINES
HR.HR_DU_UPLOAD_LINES# is referenced by following:

SchemaAPPS
SynonymHR_DU_UPLOAD_LINES
TriggerHR_DU_UPLOAD_LINES_WHO