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


TABLE: HR.HR_DU_UPLOAD_LINES

Object Details
Object Name: HR_DU_UPLOAD_LINES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_DU_UPLOAD_LINES
Subobject Name:
Status: VALID


This table holds the details for each item to be uploaded with an item spanning one or more rows


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HR_DU_UPLOAD_LINES_PK
  1. ColumnUPLOAD_LINE_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_DU_UPLOAD_LINES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPLOAD_LINE_ID
HR_DU_UPLOAD_LINES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPLOAD_HEADER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_DU_UPLOAD_LINES HR_DU_UPLOAD_LINES_FK1 TableHR_DU_UPLOAD_HEADERS HR_DU_UPLOAD_LINES UPLOAD_HEADER_ID
TableHR_DU_ERRORS HR_DU_ERRORS_FK3 HR_DU_UPLOAD_LINES HR_DU_ERRORS UPLOAD_LINE_ID
Columns
Name Datatype Length Mandatory Comments
UPLOAD_LINE_ID NUMBER (15) Yes System generated primary key
UPLOAD_HEADER_ID NUMBER (15) Yes Foreign Key to HR_DU_UPLOAD_HEADERS.UPLOAD_HEADER_ID
BATCH_LINE_ID NUMBER (15)
Foreign Key to HR_PUMP_BATCH_LINES.BATCH_LINE_ID
STATUS VARCHAR2 (30) Yes Current status of the batch line. This value is a lookup code of the lookup type HR_DU_STATUS and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.
ORIGINAL_UPLOAD_HEADER_ID NUMBER (15)
This field holds the value of its original upload header id if there were two headers with the same API value, in the same upload.
REFERENCE_TYPE VARCHAR2 (30) Yes The type of referencing used for this row. Parent Child referenced rows will have a reference pointing at the child row with Child Parent references pointing from the child to the parent
PVAL001 VARCHAR2 (2000)
The column data from the source data
PVAL002 VARCHAR2 (2000)
The column data from the source data
PVAL003 VARCHAR2 (2000)
The column data from the source data
PVAL004 VARCHAR2 (2000)
The column data from the source data
PVAL005 VARCHAR2 (2000)
The column data from the source data
PVAL006 VARCHAR2 (2000)
The column data from the source data
PVAL007 VARCHAR2 (2000)
The column data from the source data
PVAL008 VARCHAR2 (2000)
The column data from the source data
PVAL009 VARCHAR2 (2000)
The column data from the source data
PVAL010 VARCHAR2 (2000)
The column data from the source data
PVAL011 VARCHAR2 (2000)
The column data from the source data
PVAL012 VARCHAR2 (2000)
The column data from the source data
PVAL013 VARCHAR2 (2000)
The column data from the source data
PVAL014 VARCHAR2 (2000)
The column data from the source data
PVAL015 VARCHAR2 (2000)
The column data from the source data
PVAL016 VARCHAR2 (2000)
The column data from the source data
PVAL017 VARCHAR2 (2000)
The column data from the source data
PVAL018 VARCHAR2 (2000)
The column data from the source data
PVAL019 VARCHAR2 (2000)
The column data from the source data
PVAL020 VARCHAR2 (2000)
The column data from the source data
PVAL021 VARCHAR2 (2000)
The column data from the source data
PVAL022 VARCHAR2 (2000)
The column data from the source data
PVAL023 VARCHAR2 (2000)
The column data from the source data
PVAL024 VARCHAR2 (2000)
The column data from the source data
PVAL025 VARCHAR2 (2000)
The column data from the source data
PVAL026 VARCHAR2 (2000)
The column data from the source data
PVAL027 VARCHAR2 (2000)
The column data from the source data
PVAL028 VARCHAR2 (2000)
The column data from the source data
PVAL029 VARCHAR2 (2000)
The column data from the source data
PVAL030 VARCHAR2 (2000)
The column data from the source data
PVAL031 VARCHAR2 (2000)
The column data from the source data
PVAL032 VARCHAR2 (2000)
The column data from the source data
PVAL033 VARCHAR2 (2000)
The column data from the source data
PVAL034 VARCHAR2 (2000)
The column data from the source data
PVAL035 VARCHAR2 (2000)
The column data from the source data
PVAL036 VARCHAR2 (2000)
The column data from the source data
PVAL037 VARCHAR2 (2000)
The column data from the source data
PVAL038 VARCHAR2 (2000)
The column data from the source data
PVAL039 VARCHAR2 (2000)
The column data from the source data
PVAL040 VARCHAR2 (2000)
The column data from the source data
PVAL041 VARCHAR2 (2000)
The column data from the source data
PVAL042 VARCHAR2 (2000)
The column data from the source data
PVAL043 VARCHAR2 (2000)
The column data from the source data
PVAL044 VARCHAR2 (2000)
The column data from the source data
PVAL045 VARCHAR2 (2000)
The column data from the source data
PVAL046 VARCHAR2 (2000)
The column data from the source data
PVAL047 VARCHAR2 (2000)
The column data from the source data
PVAL048 VARCHAR2 (2000)
The column data from the source data
PVAL049 VARCHAR2 (2000)
The column data from the source data
PVAL050 VARCHAR2 (2000)
The column data from the source data
PVAL051 VARCHAR2 (2000)
The column data from the source data
PVAL052 VARCHAR2 (2000)
The column data from the source data
PVAL053 VARCHAR2 (2000)
The column data from the source data
PVAL054 VARCHAR2 (2000)
The column data from the source data
PVAL055 VARCHAR2 (2000)
The column data from the source data
PVAL056 VARCHAR2 (2000)
The column data from the source data
PVAL057 VARCHAR2 (2000)
The column data from the source data
PVAL058 VARCHAR2 (2000)
The column data from the source data
PVAL059 VARCHAR2 (2000)
The column data from the source data
PVAL060 VARCHAR2 (2000)
The column data from the source data
PVAL061 VARCHAR2 (2000)
The column data from the source data
PVAL062 VARCHAR2 (2000)
The column data from the source data
PVAL063 VARCHAR2 (2000)
The column data from the source data
PVAL064 VARCHAR2 (2000)
The column data from the source data
PVAL065 VARCHAR2 (2000)
The column data from the source data
PVAL066 VARCHAR2 (2000)
The column data from the source data
PVAL067 VARCHAR2 (2000)
The column data from the source data
PVAL068 VARCHAR2 (2000)
The column data from the source data
PVAL069 VARCHAR2 (2000)
The column data from the source data
PVAL070 VARCHAR2 (2000)
The column data from the source data
PVAL071 VARCHAR2 (2000)
The column data from the source data
PVAL072 VARCHAR2 (2000)
The column data from the source data
PVAL073 VARCHAR2 (2000)
The column data from the source data
PVAL074 VARCHAR2 (2000)
The column data from the source data
PVAL075 VARCHAR2 (2000)
The column data from the source data
PVAL076 VARCHAR2 (2000)
The column data from the source data
PVAL077 VARCHAR2 (2000)
The column data from the source data
PVAL078 VARCHAR2 (2000)
The column data from the source data
PVAL079 VARCHAR2 (2000)
The column data from the source data
PVAL080 VARCHAR2 (2000)
The column data from the source data
PVAL081 VARCHAR2 (2000)
The column data from the source data
PVAL082 VARCHAR2 (2000)
The column data from the source data
PVAL083 VARCHAR2 (2000)
The column data from the source data
PVAL084 VARCHAR2 (2000)
The column data from the source data
PVAL085 VARCHAR2 (2000)
The column data from the source data
PVAL086 VARCHAR2 (2000)
The column data from the source data
PVAL087 VARCHAR2 (2000)
The column data from the source data
PVAL088 VARCHAR2 (2000)
The column data from the source data
PVAL089 VARCHAR2 (2000)
The column data from the source data
PVAL090 VARCHAR2 (2000)
The column data from the source data
PVAL091 VARCHAR2 (2000)
The column data from the source data
PVAL092 VARCHAR2 (2000)
The column data from the source data
PVAL093 VARCHAR2 (2000)
The column data from the source data
PVAL094 VARCHAR2 (2000)
The column data from the source data
PVAL095 VARCHAR2 (2000)
The column data from the source data
PVAL096 VARCHAR2 (2000)
The column data from the source data
PVAL097 VARCHAR2 (2000)
The column data from the source data
PVAL098 VARCHAR2 (2000)
The column data from the source data
PVAL099 VARCHAR2 (2000)
The column data from the source data
PVAL100 VARCHAR2 (2000)
The column data from the source data
PVAL101 VARCHAR2 (2000)
The column data from the source data
PVAL102 VARCHAR2 (2000)
The column data from the source data
PVAL103 VARCHAR2 (2000)
The column data from the source data
PVAL104 VARCHAR2 (2000)
The column data from the source data
PVAL105 VARCHAR2 (2000)
The column data from the source data
PVAL106 VARCHAR2 (2000)
The column data from the source data
PVAL107 VARCHAR2 (2000)
The column data from the source data
PVAL108 VARCHAR2 (2000)
The column data from the source data
PVAL109 VARCHAR2 (2000)
The column data from the source data
PVAL110 VARCHAR2 (2000)
The column data from the source data
PVAL111 VARCHAR2 (2000)
The column data from the source data
PVAL112 VARCHAR2 (2000)
The column data from the source data
PVAL113 VARCHAR2 (2000)
The column data from the source data
PVAL114 VARCHAR2 (2000)
The column data from the source data
PVAL115 VARCHAR2 (2000)
The column data from the source data
PVAL116 VARCHAR2 (2000)
The column data from the source data
PVAL117 VARCHAR2 (2000)
The column data from the source data
PVAL118 VARCHAR2 (2000)
The column data from the source data
PVAL119 VARCHAR2 (2000)
The column data from the source data
PVAL120 VARCHAR2 (2000)
The column data from the source data
PVAL121 VARCHAR2 (2000)
The column data from the source data
PVAL122 VARCHAR2 (2000)
The column data from the source data
PVAL123 VARCHAR2 (2000)
The column data from the source data
PVAL124 VARCHAR2 (2000)
The column data from the source data
PVAL125 VARCHAR2 (2000)
The column data from the source data
PVAL126 VARCHAR2 (2000)
The column data from the source data
PVAL127 VARCHAR2 (2000)
The column data from the source data
PVAL128 VARCHAR2 (2000)
The column data from the source data
PVAL129 VARCHAR2 (2000)
The column data from the source data
PVAL130 VARCHAR2 (2000)
The column data from the source data
PVAL131 VARCHAR2 (2000)
The column data from the source data
PVAL132 VARCHAR2 (2000)
The column data from the source data
PVAL133 VARCHAR2 (2000)
The column data from the source data
PVAL134 VARCHAR2 (2000)
The column data from the source data
PVAL135 VARCHAR2 (2000)
The column data from the source data
PVAL136 VARCHAR2 (2000)
The column data from the source data
PVAL137 VARCHAR2 (2000)
The column data from the source data
PVAL138 VARCHAR2 (2000)
The column data from the source data
PVAL139 VARCHAR2 (2000)
The column data from the source data
PVAL140 VARCHAR2 (2000)
The column data from the source data
PVAL141 VARCHAR2 (2000)
The column data from the source data
PVAL142 VARCHAR2 (2000)
The column data from the source data
PVAL143 VARCHAR2 (2000)
The column data from the source data
PVAL144 VARCHAR2 (2000)
The column data from the source data
PVAL145 VARCHAR2 (2000)
The column data from the source data
PVAL146 VARCHAR2 (2000)
The column data from the source data
PVAL147 VARCHAR2 (2000)
The column data from the source data
PVAL148 VARCHAR2 (2000)
The column data from the source data
PVAL149 VARCHAR2 (2000)
The column data from the source data
PVAL150 VARCHAR2 (2000)
The column data from the source data
PVAL151 VARCHAR2 (2000)
The column data from the source data
PVAL152 VARCHAR2 (2000)
The column data from the source data
PVAL153 VARCHAR2 (2000)
The column data from the source data
PVAL154 VARCHAR2 (2000)
The column data from the source data
PVAL155 VARCHAR2 (2000)
The column data from the source data
PVAL156 VARCHAR2 (2000)
The column data from the source data
PVAL157 VARCHAR2 (2000)
The column data from the source data
PVAL158 VARCHAR2 (2000)
The column data from the source data
PVAL159 VARCHAR2 (2000)
The column data from the source data
PVAL160 VARCHAR2 (2000)
The column data from the source data
PVAL161 VARCHAR2 (2000)
The column data from the source data
PVAL162 VARCHAR2 (2000)
The column data from the source data
PVAL163 VARCHAR2 (2000)
The column data from the source data
PVAL164 VARCHAR2 (2000)
The column data from the source data
PVAL165 VARCHAR2 (2000)
The column data from the source data
PVAL166 VARCHAR2 (2000)
The column data from the source data
PVAL167 VARCHAR2 (2000)
The column data from the source data
PVAL168 VARCHAR2 (2000)
The column data from the source data
PVAL169 VARCHAR2 (2000)
The column data from the source data
PVAL170 VARCHAR2 (2000)
The column data from the source data
PVAL171 VARCHAR2 (2000)
The column data from the source data
PVAL172 VARCHAR2 (2000)
The column data from the source data
PVAL173 VARCHAR2 (2000)
The column data from the source data
PVAL174 VARCHAR2 (2000)
The column data from the source data
PVAL175 VARCHAR2 (2000)
The column data from the source data
PVAL176 VARCHAR2 (2000)
The column data from the source data
PVAL177 VARCHAR2 (2000)
The column data from the source data
PVAL178 VARCHAR2 (2000)
The column data from the source data
PVAL179 VARCHAR2 (2000)
The column data from the source data
PVAL180 VARCHAR2 (2000)
The column data from the source data
PVAL181 VARCHAR2 (2000)
The column data from the source data
PVAL182 VARCHAR2 (2000)
The column data from the source data
PVAL183 VARCHAR2 (2000)
The column data from the source data
PVAL184 VARCHAR2 (2000)
The column data from the source data
PVAL185 VARCHAR2 (2000)
The column data from the source data
PVAL186 VARCHAR2 (2000)
The column data from the source data
PVAL187 VARCHAR2 (2000)
The column data from the source data
PVAL188 VARCHAR2 (2000)
The column data from the source data
PVAL189 VARCHAR2 (2000)
The column data from the source data
PVAL190 VARCHAR2 (2000)
The column data from the source data
PVAL191 VARCHAR2 (2000)
The column data from the source data
PVAL192 VARCHAR2 (2000)
The column data from the source data
PVAL193 VARCHAR2 (2000)
The column data from the source data
PVAL194 VARCHAR2 (2000)
The column data from the source data
PVAL195 VARCHAR2 (2000)
The column data from the source data
PVAL196 VARCHAR2 (2000)
The column data from the source data
PVAL197 VARCHAR2 (2000)
The column data from the source data
PVAL198 VARCHAR2 (2000)
The column data from the source data
PVAL199 VARCHAR2 (2000)
The column data from the source data
PVAL200 VARCHAR2 (2000)
The column data from the source data
PVAL201 VARCHAR2 (2000)
The column data from the source data
PVAL202 VARCHAR2 (2000)
The column data from the source data
PVAL203 VARCHAR2 (2000)
The column data from the source data
PVAL204 VARCHAR2 (2000)
The column data from the source data
PVAL205 VARCHAR2 (2000)
The column data from the source data
PVAL206 VARCHAR2 (2000)
The column data from the source data
PVAL207 VARCHAR2 (2000)
The column data from the source data
PVAL208 VARCHAR2 (2000)
The column data from the source data
PVAL209 VARCHAR2 (2000)
The column data from the source data
PVAL210 VARCHAR2 (2000)
The column data from the source data
PVAL211 VARCHAR2 (2000)
The column data from the source data
PVAL212 VARCHAR2 (2000)
The column data from the source data
PVAL213 VARCHAR2 (2000)
The column data from the source data
PVAL214 VARCHAR2 (2000)
The column data from the source data
PVAL215 VARCHAR2 (2000)
The column data from the source data
PVAL216 VARCHAR2 (2000)
The column data from the source data
PVAL217 VARCHAR2 (2000)
The column data from the source data
PVAL218 VARCHAR2 (2000)
The column data from the source data
PVAL219 VARCHAR2 (2000)
The column data from the source data
PVAL220 VARCHAR2 (2000)
The column data from the source data
PVAL221 VARCHAR2 (2000)
The column data from the source data
PVAL222 VARCHAR2 (2000)
The column data from the source data
PVAL223 VARCHAR2 (2000)
The column data from the source data
PVAL224 VARCHAR2 (2000)
The column data from the source data
PVAL225 VARCHAR2 (2000)
The column data from the source data
PVAL226 VARCHAR2 (2000)
The column data from the source data
PVAL227 VARCHAR2 (2000)
The column data from the source data
PVAL228 VARCHAR2 (2000)
The column data from the source data
PVAL229 VARCHAR2 (2000)
The column data from the source data
PVAL230 VARCHAR2 (2000)
The column data from the source data
LINE_TYPE VARCHAR2 (1) Yes The type of data held in the row. This value is a lookup code of the lookup type HR_DU_LINE_TYPE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES
DI_LINE_NUMBER NUMBER

Line number from the input file
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column
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 does not reference any database object

HR.HR_DU_UPLOAD_LINES is referenced by following:

SchemaAPPS
SynonymHR_DU_UPLOAD_LINES
TriggerHR_DU_UPLOAD_LINES_WHO
SchemaPUBLIC
SynonymHR_DU_UPLOAD_LINES