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


VIEW: APPS.AMS_HZ_B2C_MAPPING_V

Object Details
Object Name: AMS_HZ_B2C_MAPPING_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_HZ_B2C_MAPPING_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
IMPORT_SOURCE_LINE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
IMPORT_LIST_HEADER_ID NUMBER
Yes
IMPORT_SUCCESSFUL_FLAG VARCHAR2 (1) Yes
OBJECT_VERSION_NUMBER NUMBER (9)
ENABLED_FLAG VARCHAR2 (1)
LOAD_STATUS VARCHAR2 (30)
PARTY_ID NUMBER

PERSON_FIRST_NAME VARCHAR2 (2000)
PERSON_MIDDLE_NAME VARCHAR2 (2000)
PERSON_LAST_NAME VARCHAR2 (2000)
PERSON_NAME_SUFFIX VARCHAR2 (2000)
PERSON_NAME_PREFIX VARCHAR2 (2000)
BEST_TIME_CONTACT_BEGIN VARCHAR2 (2000)
BEST_TIME_CONTACT_END VARCHAR2 (2000)
COUNTRY VARCHAR2 (2000)
ADDRESS1 VARCHAR2 (2000)
ADDRESS2 VARCHAR2 (2000)
CITY VARCHAR2 (2000)
COUNTY VARCHAR2 (2000)
STATE VARCHAR2 (2000)
PROVINCE VARCHAR2 (2000)
POSTAL_CODE VARCHAR2 (2000)
TIME_ZONE VARCHAR2 (2000)
EMAIL_ADDRESS VARCHAR2 (2000)
PHONE_COUNTRY_CODE VARCHAR2 (2000)
PHONE_AREA_CODE VARCHAR2 (2000)
PHONE_NUMBER VARCHAR2 (2000)
PHONE_EXTENTION VARCHAR2 (2000)
GENDER VARCHAR2 (2000)
HOUSEHOLD_INCOME VARCHAR2 (2000)
SITE_USE_TYPE VARCHAR2 (2000)
PERSON_PRE_NAME_ADJUNCT VARCHAR2 (2000)
SALUTATION VARCHAR2 (2000)
ADDRESS3 VARCHAR2 (2000)
ADDRESS4 VARCHAR2 (2000)
ADDRESS_LINES_PHONETIC VARCHAR2 (2000)
APARTMENT_FLAG VARCHAR2 (2000)
PO_BOX_NUMBER VARCHAR2 (2000)
HOUSE_NUMBER VARCHAR2 (2000)
STREET_SUFFIX VARCHAR2 (2000)
SECONDARY_SUFFIX_ELEMENT VARCHAR2 (2000)
STREET VARCHAR2 (2000)
RURAL_ROUTE_TYPE VARCHAR2 (2000)
RURAL_ROUTE_NUMBER VARCHAR2 (2000)
STREET_NUMBER VARCHAR2 (2000)
FLOOR VARCHAR2 (2000)
SUITE VARCHAR2 (2000)
POSTAL_PLUS4_CODE VARCHAR2 (2000)
OVERSEAS_ADDRESS_FLAG VARCHAR2 (2000)
IDENTIFYING_ADDRESS_FLAG VARCHAR2 (2000)
DEDUPE_KEY VARCHAR2 (500)
NOTES VARCHAR2 (4000)
VEHICLE_RESPONSE_CODE VARCHAR2 (30)
SALES_AGENT_EMAIL_ADDRESS VARCHAR2 (2000)
RESOURCE_ID NUMBER

BATCH_ID NUMBER

LOCATION_ID NUMBER

CONTACT_POINT_ID NUMBER

PER_IMP_XML_ELEMENT_ID VARCHAR2 (2000)
ADD_IMP_XML_ELEMENT_ID VARCHAR2 (2000)
CP_IMP_XML_ELEMENT_ID VARCHAR2 (2000)
EM_IMP_XML_ELEMENT_ID VARCHAR2 (2000)
PERSON_LAST_NAME_PHONETIC VARCHAR2 (2000)
PERSON_FIRST_NAME_PHONETIC VARCHAR2 (2000)
URL VARCHAR2 (2000)
SECOND_TITLE VARCHAR2 (2000)
DATE_OF_BIRTH VARCHAR2 (2000)
PERSON_ACADEMIC_TITLE VARCHAR2 (2000)
PERSON_PREVIOUS_TITLE_NAME VARCHAR2 (2000)
PERSON_KNOWN_AS VARCHAR2 (2000)
PERSON_KNOWN_AS2 VARCHAR2 (2000)
PERSON_KNOWN_AS3 VARCHAR2 (2000)
PERSON_KNOWN_AS4 VARCHAR2 (2000)
PERSON_KNOWN_AS5 VARCHAR2 (2000)
PERSON_NAME_PHONETIC VARCHAR2 (2000)
MIDDLE_NAME_PHONETIC VARCHAR2 (2000)
FISCAL_CODE VARCHAR2 (2000)
PLACE_OF_BIRTH VARCHAR2 (2000)
DATE_OF_DEATH VARCHAR2 (2000)
DECLARED_ETHNICITY VARCHAR2 (2000)
MARITAL_STATUS VARCHAR2 (2000)
PERSONAL_INCOME VARCHAR2 (2000)
MARITAL_STATUS_EFFECTIVE_DATE VARCHAR2 (2000)
HEAD_OF_HOUSEHOLD_FLAG VARCHAR2 (2000)
HOUSEHOLD_SIZE VARCHAR2 (2000)
LOCATION_DIRECTIONS VARCHAR2 (2000)
ADDRESS_EFFECTIVE_DATE VARCHAR2 (2000)
ADDRESS_EXPIRATION_DATE VARCHAR2 (2000)
PERSON_ATTRIBUTE1 VARCHAR2 (2000)
PERSON_ATTRIBUTE2 VARCHAR2 (2000)
PERSON_ATTRIBUTE3 VARCHAR2 (2000)
PERSON_ATTRIBUTE4 VARCHAR2 (2000)
PERSON_ATTRIBUTE5 VARCHAR2 (2000)
PERSON_ATTRIBUTE6 VARCHAR2 (2000)
PERSON_ATTRIBUTE7 VARCHAR2 (2000)
PERSON_ATTRIBUTE8 VARCHAR2 (2000)
PERSON_ATTRIBUTE9 VARCHAR2 (2000)
PERSON_ATTRIBUTE10 VARCHAR2 (2000)
PERSON_ATTRIBUTE11 VARCHAR2 (2000)
PERSON_ATTRIBUTE12 VARCHAR2 (2000)
PERSON_ATTRIBUTE13 VARCHAR2 (2000)
PERSON_ATTRIBUTE14 VARCHAR2 (2000)
PERSON_ATTRIBUTE15 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE1 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE2 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE3 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE4 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE5 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE6 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE7 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE8 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE9 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE10 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE11 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE12 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE13 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE14 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE15 VARCHAR2 (2000)
FAX_COUNTRY_CODE VARCHAR2 (2000)
FAX_AREA_CODE VARCHAR2 (2000)
FAX_NUMBER VARCHAR2 (2000)
PERSON_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
ADDRESS_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
PARTY_SITE_USE VARCHAR2 (2000)
SHORT_DESCRIPTION VARCHAR2 (2000)
DESCRIPTION VARCHAR2 (2000)
ORIG_SYSTEM_REFERENCE VARCHAR2 (2000)
TAX_REFERENCE VARCHAR2 (2000)
RENT_OWNED_INDICATOR VARCHAR2 (2000)
PERSON_KEY VARCHAR2 (240)
PERSON_PARTY_ID NUMBER

PERSON_EXIST VARCHAR2 (1)
ADDRESS_KEY VARCHAR2 (240)
PARTY_LOCATION_ID NUMBER

REQUEST_ID NUMBER

RECORD_PROCESSED VARCHAR2 (1)
TRANSPOSED_PHONE_NUMBER VARCHAR2 (60)
CUSTOM_COLUMN1 VARCHAR2 (2000)
CUSTOM_COLUMN2 VARCHAR2 (2000)
CUSTOM_COLUMN3 VARCHAR2 (2000)
CUSTOM_COLUMN4 VARCHAR2 (2000)
CUSTOM_COLUMN5 VARCHAR2 (2000)
CUSTOM_COLUMN6 VARCHAR2 (2000)
CUSTOM_COLUMN7 VARCHAR2 (2000)
CUSTOM_COLUMN8 VARCHAR2 (2000)
CUSTOM_COLUMN9 VARCHAR2 (2000)
CUSTOM_COLUMN10 VARCHAR2 (2000)
CUSTOM_COLUMN11 VARCHAR2 (2000)
CUSTOM_COLUMN12 VARCHAR2 (2000)
CUSTOM_COLUMN13 VARCHAR2 (2000)
CUSTOM_COLUMN14 VARCHAR2 (2000)
CUSTOM_COLUMN15 VARCHAR2 (2000)
CUSTOM_COLUMN16 VARCHAR2 (2000)
CUSTOM_COLUMN17 VARCHAR2 (2000)
CUSTOM_COLUMN18 VARCHAR2 (2000)
CUSTOM_COLUMN19 VARCHAR2 (2000)
CUSTOM_COLUMN20 VARCHAR2 (2000)
CUSTOM_COLUMN21 VARCHAR2 (2000)
CUSTOM_COLUMN22 VARCHAR2 (2000)
CUSTOM_COLUMN23 VARCHAR2 (2000)
CUSTOM_COLUMN24 VARCHAR2 (2000)
CUSTOM_COLUMN25 VARCHAR2 (2000)
PHONE_TYPE VARCHAR2 (2000)
PS_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
PS_ATTRIBUTE1 VARCHAR2 (2000)
PS_ATTRIBUTE2 VARCHAR2 (2000)
PS_ATTRIBUTE3 VARCHAR2 (2000)
PS_ATTRIBUTE4 VARCHAR2 (2000)
PS_ATTRIBUTE5 VARCHAR2 (2000)
PS_ATTRIBUTE6 VARCHAR2 (2000)
PS_ATTRIBUTE7 VARCHAR2 (2000)
PS_ATTRIBUTE8 VARCHAR2 (2000)
PS_ATTRIBUTE9 VARCHAR2 (2000)
PS_ATTRIBUTE10 VARCHAR2 (2000)
PS_ATTRIBUTE11 VARCHAR2 (2000)
PS_ATTRIBUTE12 VARCHAR2 (2000)
PS_ATTRIBUTE13 VARCHAR2 (2000)
PS_ATTRIBUTE14 VARCHAR2 (2000)
PS_ATTRIBUTE15 VARCHAR2 (2000)
PS_ATTRIBUTE16 VARCHAR2 (2000)
PS_ATTRIBUTE17 VARCHAR2 (2000)
PS_ATTRIBUTE18 VARCHAR2 (2000)
PS_ATTRIBUTE19 VARCHAR2 (2000)
PS_ATTRIBUTE20 VARCHAR2 (2000)
NATIVE_LANGUAGE VARCHAR2 (2000)
PERSON_ATTRIBUTE16 VARCHAR2 (2000)
PERSON_ATTRIBUTE17 VARCHAR2 (2000)
PERSON_ATTRIBUTE18 VARCHAR2 (2000)
PERSON_ATTRIBUTE19 VARCHAR2 (2000)
PERSON_ATTRIBUTE20 VARCHAR2 (2000)
PERSON_ATTRIBUTE21 VARCHAR2 (2000)
PERSON_ATTRIBUTE22 VARCHAR2 (2000)
PERSON_ATTRIBUTE23 VARCHAR2 (2000)
PERSON_ATTRIBUTE24 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE16 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE17 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE18 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE19 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE20 VARCHAR2 (2000)
CUSTOM_PROCESSING_STATUS VARCHAR2 (30)
AMS_COL201 VARCHAR2 (4000)
AMS_COL202 VARCHAR2 (4000)
AMS_COL203 VARCHAR2 (4000)
AMS_COL204 VARCHAR2 (4000)
AMS_COL205 VARCHAR2 (4000)
AMS_COL206 VARCHAR2 (4000)
AMS_COL207 VARCHAR2 (4000)
AMS_COL208 VARCHAR2 (4000)
AMS_COL209 VARCHAR2 (4000)
AMS_COL210 VARCHAR2 (4000)
AMS_COL211 VARCHAR2 (4000)
AMS_COL212 VARCHAR2 (4000)
AMS_COL213 VARCHAR2 (4000)
AMS_COL214 VARCHAR2 (4000)
AMS_COL215 VARCHAR2 (4000)
AMS_COL216 VARCHAR2 (4000)
AMS_COL217 VARCHAR2 (4000)
AMS_COL218 VARCHAR2 (4000)
AMS_COL219 VARCHAR2 (4000)
AMS_COL220 VARCHAR2 (4000)
AMS_COL221 VARCHAR2 (4000)
AMS_COL222 VARCHAR2 (4000)
AMS_COL223 VARCHAR2 (4000)
AMS_COL224 VARCHAR2 (4000)
AMS_COL225 VARCHAR2 (4000)
AMS_COL226 VARCHAR2 (4000)
AMS_COL227 VARCHAR2 (4000)
AMS_COL228 VARCHAR2 (4000)
AMS_COL229 VARCHAR2 (4000)
AMS_COL230 VARCHAR2 (4000)
AMS_COL231 VARCHAR2 (4000)
AMS_COL232 VARCHAR2 (4000)
AMS_COL233 VARCHAR2 (4000)
AMS_COL234 VARCHAR2 (4000)
AMS_COL235 VARCHAR2 (4000)
AMS_COL236 VARCHAR2 (4000)
AMS_COL237 VARCHAR2 (4000)
AMS_COL238 VARCHAR2 (4000)
AMS_COL239 VARCHAR2 (4000)
AMS_COL240 VARCHAR2 (4000)
AMS_COL241 VARCHAR2 (4000)
AMS_COL242 VARCHAR2 (4000)
AMS_COL243 VARCHAR2 (4000)
AMS_COL244 VARCHAR2 (4000)
AMS_COL245 VARCHAR2 (4000)
AMS_COL246 VARCHAR2 (4000)
AMS_COL247 VARCHAR2 (4000)
AMS_COL248 VARCHAR2 (4000)
AMS_COL249 VARCHAR2 (4000)
AMS_COL250 VARCHAR2 (4000)
AMS_COL251 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL252 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL253 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL254 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL255 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL256 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL257 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL258 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL259 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL260 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL261 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL262 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL263 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL264 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL265 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL266 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL267 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL268 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL269 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL270 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL271 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL272 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL273 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL274 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL275 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL276 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL277 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL278 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL279 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL280 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL281 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL282 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL283 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL284 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL285 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL286 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL287 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL288 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL289 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL290 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL291 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL292 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL293 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL294 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL295 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL296 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL297 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL298 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL299 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL300 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL301 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL302 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL303 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL304 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL305 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL306 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL307 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL308 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL309 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL310 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL311 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL312 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL313 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL314 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL315 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL316 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL317 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL318 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL319 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL320 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL321 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL322 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL323 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL324 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL325 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL326 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL327 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL328 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL329 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL330 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL331 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL332 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL333 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL334 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL335 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL336 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL337 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL338 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL339 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL340 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL341 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL342 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL343 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL344 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL345 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL346 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL347 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL348 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL349 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL350 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL351 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL352 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL353 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL354 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL355 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL356 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL357 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL358 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL359 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL360 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL361 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL362 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL363 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL364 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL365 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL366 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL367 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL368 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL369 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL370 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL371 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL372 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL373 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL374 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL375 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL376 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL377 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL378 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL379 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL380 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL381 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL382 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL383 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL384 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL385 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL386 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL387 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL388 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL389 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL390 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL391 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL392 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL393 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL394 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL395 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL396 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL397 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL398 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL399 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL400 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
Query Text

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


SELECT IMPORT_SOURCE_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      IMPORT_LIST_HEADER_ID
,      IMPORT_SUCCESSFUL_FLAG
,      OBJECT_VERSION_NUMBER
,      ENABLED_FLAG
,      LOAD_STATUS
,      PARTY_ID
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_NAME_PREFIX
,      BEST_TIME_CONTACT_BEGIN
,      BEST_TIME_CONTACT_END
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      CITY
,      COUNTY
,      STATE
,      PROVINCE
,      POSTAL_CODE
,      TIME_ZONE
,      EMAIL_ADDRESS
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENTION
,      GENDER
,      HOUSEHOLD_INCOME
,      SITE_USE_TYPE
,      PERSON_PRE_NAME_ADJUNCT
,      SALUTATION
,      ADDRESS3
,      ADDRESS4
,      ADDRESS_LINES_PHONETIC
,      APARTMENT_FLAG
,      PO_BOX_NUMBER
,      HOUSE_NUMBER
,      STREET_SUFFIX
,      SECONDARY_SUFFIX_ELEMENT
,      STREET
,      RURAL_ROUTE_TYPE
,      RURAL_ROUTE_NUMBER
,      STREET_NUMBER
,      FLOOR
,      SUITE
,      POSTAL_PLUS4_CODE
,      OVERSEAS_ADDRESS_FLAG
,      IDENTIFYING_ADDRESS_FLAG
,      DEDUPE_KEY
,      NOTES
,      VEHICLE_RESPONSE_CODE
,      SALES_AGENT_EMAIL_ADDRESS
,      RESOURCE_ID
,      BATCH_ID
,      LOCATION_ID
,      CONTACT_POINT_ID
,      PER_IMP_XML_ELEMENT_ID
,      ADD_IMP_XML_ELEMENT_ID
,      CP_IMP_XML_ELEMENT_ID
,      EM_IMP_XML_ELEMENT_ID
,      PERSON_LAST_NAME_PHONETIC
,      PERSON_FIRST_NAME_PHONETIC
,      URL
,      SECOND_TITLE
,      DATE_OF_BIRTH
,      PERSON_ACADEMIC_TITLE
,      PERSON_PREVIOUS_TITLE_NAME
,      PERSON_KNOWN_AS
,      PERSON_KNOWN_AS2
,      PERSON_KNOWN_AS3
,      PERSON_KNOWN_AS4
,      PERSON_KNOWN_AS5
,      PERSON_NAME_PHONETIC
,      MIDDLE_NAME_PHONETIC
,      FISCAL_CODE
,      PLACE_OF_BIRTH
,      DATE_OF_DEATH
,      DECLARED_ETHNICITY
,      MARITAL_STATUS
,      PERSONAL_INCOME
,      MARITAL_STATUS_EFFECTIVE_DATE
,      HEAD_OF_HOUSEHOLD_FLAG
,      HOUSEHOLD_SIZE
,      LOCATION_DIRECTIONS
,      ADDRESS_EFFECTIVE_DATE
,      ADDRESS_EXPIRATION_DATE
,      PERSON_ATTRIBUTE1
,      PERSON_ATTRIBUTE2
,      PERSON_ATTRIBUTE3
,      PERSON_ATTRIBUTE4
,      PERSON_ATTRIBUTE5
,      PERSON_ATTRIBUTE6
,      PERSON_ATTRIBUTE7
,      PERSON_ATTRIBUTE8
,      PERSON_ATTRIBUTE9
,      PERSON_ATTRIBUTE10
,      PERSON_ATTRIBUTE11
,      PERSON_ATTRIBUTE12
,      PERSON_ATTRIBUTE13
,      PERSON_ATTRIBUTE14
,      PERSON_ATTRIBUTE15
,      ADDRESS_ATTRIBUTE1
,      ADDRESS_ATTRIBUTE2
,      ADDRESS_ATTRIBUTE3
,      ADDRESS_ATTRIBUTE4
,      ADDRESS_ATTRIBUTE5
,      ADDRESS_ATTRIBUTE6
,      ADDRESS_ATTRIBUTE7
,      ADDRESS_ATTRIBUTE8
,      ADDRESS_ATTRIBUTE9
,      ADDRESS_ATTRIBUTE10
,      ADDRESS_ATTRIBUTE11
,      ADDRESS_ATTRIBUTE12
,      ADDRESS_ATTRIBUTE13
,      ADDRESS_ATTRIBUTE14
,      ADDRESS_ATTRIBUTE15
,      FAX_COUNTRY_CODE
,      FAX_AREA_CODE
,      FAX_NUMBER
,      PERSON_ATTRIBUTE_CATEGORY
,      ADDRESS_ATTRIBUTE_CATEGORY
,      PARTY_SITE_USE
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      ORIG_SYSTEM_REFERENCE
,      TAX_REFERENCE
,      RENT_OWNED_INDICATOR
,      PERSON_KEY
,      PERSON_PARTY_ID
,      PERSON_EXIST
,      ADDRESS_KEY
,      PARTY_LOCATION_ID
,      REQUEST_ID
,      RECORD_PROCESSED
,      TRANSPOSED_PHONE_NUMBER
,      CUSTOM_COLUMN1
,      CUSTOM_COLUMN2
,      CUSTOM_COLUMN3
,      CUSTOM_COLUMN4
,      CUSTOM_COLUMN5
,      CUSTOM_COLUMN6
,      CUSTOM_COLUMN7
,      CUSTOM_COLUMN8
,      CUSTOM_COLUMN9
,      CUSTOM_COLUMN10
,      CUSTOM_COLUMN11
,      CUSTOM_COLUMN12
,      CUSTOM_COLUMN13
,      CUSTOM_COLUMN14
,      CUSTOM_COLUMN15
,      CUSTOM_COLUMN16
,      CUSTOM_COLUMN17
,      CUSTOM_COLUMN18
,      CUSTOM_COLUMN19
,      CUSTOM_COLUMN20
,      CUSTOM_COLUMN21
,      CUSTOM_COLUMN22
,      CUSTOM_COLUMN23
,      CUSTOM_COLUMN24
,      CUSTOM_COLUMN25
,      PHONE_TYPE
,      PS_ATTRIBUTE_CATEGORY
,      PS_ATTRIBUTE1
,      PS_ATTRIBUTE2
,      PS_ATTRIBUTE3
,      PS_ATTRIBUTE4
,      PS_ATTRIBUTE5
,      PS_ATTRIBUTE6
,      PS_ATTRIBUTE7
,      PS_ATTRIBUTE8
,      PS_ATTRIBUTE9
,      PS_ATTRIBUTE10
,      PS_ATTRIBUTE11
,      PS_ATTRIBUTE12
,      PS_ATTRIBUTE13
,      PS_ATTRIBUTE14
,      PS_ATTRIBUTE15
,      PS_ATTRIBUTE16
,      PS_ATTRIBUTE17
,      PS_ATTRIBUTE18
,      PS_ATTRIBUTE19
,      PS_ATTRIBUTE20
,      NATIVE_LANGUAGE
,      PERSON_ATTRIBUTE16
,      PERSON_ATTRIBUTE17
,      PERSON_ATTRIBUTE18
,      PERSON_ATTRIBUTE19
,      PERSON_ATTRIBUTE20
,      PERSON_ATTRIBUTE21
,      PERSON_ATTRIBUTE22
,      PERSON_ATTRIBUTE23
,      PERSON_ATTRIBUTE24
,      ADDRESS_ATTRIBUTE16
,      ADDRESS_ATTRIBUTE17
,      ADDRESS_ATTRIBUTE18
,      ADDRESS_ATTRIBUTE19
,      ADDRESS_ATTRIBUTE20
,      CUSTOM_PROCESSING_STATUS
,      AMS_COL201
,      AMS_COL202
,      AMS_COL203
,      AMS_COL204
,      AMS_COL205
,      AMS_COL206
,      AMS_COL207
,      AMS_COL208
,      AMS_COL209
,      AMS_COL210
,      AMS_COL211
,      AMS_COL212
,      AMS_COL213
,      AMS_COL214
,      AMS_COL215
,      AMS_COL216
,      AMS_COL217
,      AMS_COL218
,      AMS_COL219
,      AMS_COL220
,      AMS_COL221
,      AMS_COL222
,      AMS_COL223
,      AMS_COL224
,      AMS_COL225
,      AMS_COL226
,      AMS_COL227
,      AMS_COL228
,      AMS_COL229
,      AMS_COL230
,      AMS_COL231
,      AMS_COL232
,      AMS_COL233
,      AMS_COL234
,      AMS_COL235
,      AMS_COL236
,      AMS_COL237
,      AMS_COL238
,      AMS_COL239
,      AMS_COL240
,      AMS_COL241
,      AMS_COL242
,      AMS_COL243
,      AMS_COL244
,      AMS_COL245
,      AMS_COL246
,      AMS_COL247
,      AMS_COL248
,      AMS_COL249
,      AMS_COL250
,      AMS_COL251
,      AMS_COL252
,      AMS_COL253
,      AMS_COL254
,      AMS_COL255
,      AMS_COL256
,      AMS_COL257
,      AMS_COL258
,      AMS_COL259
,      AMS_COL260
,      AMS_COL261
,      AMS_COL262
,      AMS_COL263
,      AMS_COL264
,      AMS_COL265
,      AMS_COL266
,      AMS_COL267
,      AMS_COL268
,      AMS_COL269
,      AMS_COL270
,      AMS_COL271
,      AMS_COL272
,      AMS_COL273
,      AMS_COL274
,      AMS_COL275
,      AMS_COL276
,      AMS_COL277
,      AMS_COL278
,      AMS_COL279
,      AMS_COL280
,      AMS_COL281
,      AMS_COL282
,      AMS_COL283
,      AMS_COL284
,      AMS_COL285
,      AMS_COL286
,      AMS_COL287
,      AMS_COL288
,      AMS_COL289
,      AMS_COL290
,      AMS_COL291
,      AMS_COL292
,      AMS_COL293
,      AMS_COL294
,      AMS_COL295
,      AMS_COL296
,      AMS_COL297
,      AMS_COL298
,      AMS_COL299
,      AMS_COL300
,      AMS_COL301
,      AMS_COL302
,      AMS_COL303
,      AMS_COL304
,      AMS_COL305
,      AMS_COL306
,      AMS_COL307
,      AMS_COL308
,      AMS_COL309
,      AMS_COL310
,      AMS_COL311
,      AMS_COL312
,      AMS_COL313
,      AMS_COL314
,      AMS_COL315
,      AMS_COL316
,      AMS_COL317
,      AMS_COL318
,      AMS_COL319
,      AMS_COL320
,      AMS_COL321
,      AMS_COL322
,      AMS_COL323
,      AMS_COL324
,      AMS_COL325
,      AMS_COL326
,      AMS_COL327
,      AMS_COL328
,      AMS_COL329
,      AMS_COL330
,      AMS_COL331
,      AMS_COL332
,      AMS_COL333
,      AMS_COL334
,      AMS_COL335
,      AMS_COL336
,      AMS_COL337
,      AMS_COL338
,      AMS_COL339
,      AMS_COL340
,      AMS_COL341
,      AMS_COL342
,      AMS_COL343
,      AMS_COL344
,      AMS_COL345
,      AMS_COL346
,      AMS_COL347
,      AMS_COL348
,      AMS_COL349
,      AMS_COL350
,      AMS_COL351
,      AMS_COL352
,      AMS_COL353
,      AMS_COL354
,      AMS_COL355
,      AMS_COL356
,      AMS_COL357
,      AMS_COL358
,      AMS_COL359
,      AMS_COL360
,      AMS_COL361
,      AMS_COL362
,      AMS_COL363
,      AMS_COL364
,      AMS_COL365
,      AMS_COL366
,      AMS_COL367
,      AMS_COL368
,      AMS_COL369
,      AMS_COL370
,      AMS_COL371
,      AMS_COL372
,      AMS_COL373
,      AMS_COL374
,      AMS_COL375
,      AMS_COL376
,      AMS_COL377
,      AMS_COL378
,      AMS_COL379
,      AMS_COL380
,      AMS_COL381
,      AMS_COL382
,      AMS_COL383
,      AMS_COL384
,      AMS_COL385
,      AMS_COL386
,      AMS_COL387
,      AMS_COL388
,      AMS_COL389
,      AMS_COL390
,      AMS_COL391
,      AMS_COL392
,      AMS_COL393
,      AMS_COL394
,      AMS_COL395
,      AMS_COL396
,      AMS_COL397
,      AMS_COL398
,      AMS_COL399
,      AMS_COL400
FROM APPS.AMS_HZ_B2C_MAPPING_V;

Dependencies

[top of page]

APPS.AMS_HZ_B2C_MAPPING_V references the following:

SchemaAPPS
SynonymAMS_IMP_LIST_HEADERS_ALL
SynonymAMS_IMP_SOURCE_LINES
APPS.AMS_HZ_B2C_MAPPING_V is referenced by following:

SchemaAPPS
Package BodyAMS_LISTGENERATION_PKG - show dependent code
Package BodyAMS_LISTIMPORT_PVT - show dependent code
Package BodyAMS_LIST_IMPORT_PUB - show dependent code