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


VIEW: APPS.AMS_LEAD_MAPPING_V

Object Details
Object Name: AMS_LEAD_MAPPING_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_LEAD_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
IMPORT_LIST_HEADER_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
LOAD_STATUS VARCHAR2 (30)
IMPORT_SUCCESSFUL_FLAG VARCHAR2 (1) Yes
OBJECT_VERSION_NUMBER NUMBER (9)
SOURCE_SYSTEM VARCHAR2 (2000)
IMP_LIST_HEADER_NUMBER VARCHAR2 (2000)
LEAD_NOTE VARCHAR2 (4000)
PROMOTION_CODE VARCHAR2 (2000)
CUSTOMER_NAME VARCHAR2 (4000)
SIC_CODE VARCHAR2 (2000)
ANALYSIS_FY VARCHAR2 (2000)
CUSTOMER_CATEGORY_CODE VARCHAR2 (2000)
FISCAL_YEAREND_MONTH VARCHAR2 (2000)
NUM_OF_EMPLOYEES VARCHAR2 (2000)
POTENTIAL_REVENUE_CURR_FY VARCHAR2 (2000)
POTENTIAL_REVENUE_NEXT_FY VARCHAR2 (2000)
CUSTOMER_RANK VARCHAR2 (2000)
TAX_REFERENCE VARCHAR2 (2000)
YEAR_ESTABLISHED VARCHAR2 (2000)
ADDR_DO_NOT_MAIL_FLAG VARCHAR2 (2000)
URL VARCHAR2 (4000)
CONT_DO_NOT_MAIL_FLAG VARCHAR2 (2000)
COUNTRY VARCHAR2 (4000)
ADDRESS1 VARCHAR2 (4000)
ADDRESS2 VARCHAR2 (4000)
ADDRESS3 VARCHAR2 (4000)
ADDRESS4 VARCHAR2 (4000)
CITY VARCHAR2 (2000)
POSTAL_CODE VARCHAR2 (2000)
STATE VARCHAR2 (2000)
PROVINCE VARCHAR2 (2000)
COUNTY VARCHAR2 (2000)
EMAIL_ADDRESS VARCHAR2 (2000)
SEX_CODE VARCHAR2 (2000)
SALUTATION VARCHAR2 (2000)
LAST_NAME VARCHAR2 (2000)
TITLE VARCHAR2 (2000)
FIRST_NAME VARCHAR2 (2000)
JOB_TITLE VARCHAR2 (2000)
PHONE_NUMBER VARCHAR2 (2000)
PHONE_STATUS VARCHAR2 (2000)
PHONE_TYPE VARCHAR2 (2000)
AREA_CODE VARCHAR2 (2000)
EXTENSION VARCHAR2 (2000)
MIDDLE_INITIAL VARCHAR2 (2000)
JOB_TITLE_CODE VARCHAR2 (2000)
MAIL_STOP VARCHAR2 (2000)
FAX_NUMBER VARCHAR2 (2000)
FAX_AREA_CODE VARCHAR2 (2000)
DO_NOT_EMAIL_FLAG VARCHAR2 (2000)
DO_NOT_FAX_FLAG VARCHAR2 (2000)
DO_NOT_PHONE_FLAG VARCHAR2 (2000)
CONTACT_ROLE_CODE VARCHAR2 (2000)
CHANNEL_CODE VARCHAR2 (2000)
BUDGET_AMOUNT VARCHAR2 (2000)
BUDGET_STATUS_CODE VARCHAR2 (2000)
CURRENCY_CODE VARCHAR2 (2000)
DECISION_TIMEFRAME_CODE VARCHAR2 (2000)
CLOSE_REASON VARCHAR2 (2000)
PARENT_PROJECT VARCHAR2 (2000)
DESCRIPTION VARCHAR2 (2000)
VEHICLE_RESPONSE_CODE VARCHAR2 (2000)
INTEREST_TYPE_ID_1 VARCHAR2 (2000)
PRIMARY_INTEREST_CODE_ID_1 VARCHAR2 (2000)
SECONDARY_INTEREST_CODE_ID_1 VARCHAR2 (2000)
INVENTORY_ITEM_ID_1 VARCHAR2 (2000)
ORGANIZATION_ID_1 VARCHAR2 (2000)
UOM_CODE_1 VARCHAR2 (2000)
QUANTITY_1 VARCHAR2 (2000)
BUDGET_AMOUNT_1 VARCHAR2 (2000)
SOURCE_PROMOTION_ID_1 VARCHAR2 (2000)
OFFER_ID_1 VARCHAR2 (2000)
INTEREST_TYPE_ID_2 VARCHAR2 (2000)
PRIMARY_INTEREST_CODE_ID_2 VARCHAR2 (2000)
SECONDARY_INTEREST_CODE_ID_2 VARCHAR2 (2000)
INVENTORY_ITEM_ID_2 VARCHAR2 (2000)
ORGANIZATION_ID_2 VARCHAR2 (2000)
UOM_CODE_2 VARCHAR2 (2000)
QUANTITY_2 VARCHAR2 (2000)
BUDGET_AMOUNT_2 VARCHAR2 (2000)
SOURCE_PROMOTION_ID_2 VARCHAR2 (2000)
OFFER_ID_2 VARCHAR2 (2000)
INTEREST_TYPE_ID_3 VARCHAR2 (2000)
PRIMARY_INTEREST_CODE_ID_3 VARCHAR2 (2000)
SECONDARY_INTEREST_CODE_ID_3 VARCHAR2 (2000)
INVENTORY_ITEM_ID_3 VARCHAR2 (2000)
ORGANIZATION_ID_3 VARCHAR2 (2000)
UOM_CODE_3 VARCHAR2 (2000)
QUANTITY_3 VARCHAR2 (2000)
BUDGET_AMOUNT_3 VARCHAR2 (2000)
SOURCE_PROMOTION_ID_3 VARCHAR2 (2000)
OFFER_ID_3 VARCHAR2 (2000)
INTEREST_TYPE_ID_4 VARCHAR2 (2000)
PRIMARY_INTEREST_CODE_ID_4 VARCHAR2 (2000)
SECONDARY_INTEREST_CODE_ID_4 VARCHAR2 (2000)
INVENTORY_ITEM_ID_4 VARCHAR2 (2000)
ORGANIZATION_ID_4 VARCHAR2 (2000)
UOM_CODE_4 VARCHAR2 (2000)
QUANTITY_4 VARCHAR2 (2000)
BUDGET_AMOUNT_4 VARCHAR2 (2000)
SOURCE_PROMOTION_ID_4 VARCHAR2 (2000)
OFFER_ID_4 VARCHAR2 (2000)
INTEREST_TYPE_ID_5 VARCHAR2 (2000)
PRIMARY_INTEREST_CODE_ID_5 VARCHAR2 (2000)
SECONDARY_INTEREST_CODE_ID_5 VARCHAR2 (2000)
INVENTORY_ITEM_ID_5 VARCHAR2 (2000)
ORGANIZATION_ID_5 VARCHAR2 (2000)
UOM_CODE_5 VARCHAR2 (2000)
QUANTITY_5 VARCHAR2 (2000)
BUDGET_AMOUNT_5 VARCHAR2 (2000)
SOURCE_PROMOTION_ID_5 VARCHAR2 (2000)
OFFER_ID_5 VARCHAR2 (2000)
ORIG_SYSTEM_REFERENCE VARCHAR2 (2000)
ORIG_SYSTEM_CODE VARCHAR2 (2000)
URGENT_FLAG VARCHAR2 (2000)
ACCEPT_FLAG VARCHAR2 (2000)
ASSIGN_DATE VARCHAR2 (2000)
ASSIGN_SALES_GROUP_ID VARCHAR2 (2000)
ASSIGN_TO_PERSON_ID VARCHAR2 (2000)
ASSIGN_TO_SALESFORCE_ID VARCHAR2 (2000)
AUTO_ASSIGNMENT_TYPE VARCHAR2 (2000)
DELETED_FLAG VARCHAR2 (2000)
IMPORT_FLAG VARCHAR2 (2000)
KEEP_FLAG VARCHAR2 (2000)
PRM_ASSIGNMENT_TYPE VARCHAR2 (2000)
QUALIFIED_FLAG VARCHAR2 (2000)
REJECT_REASON_CODE VARCHAR2 (2000)
SCORECARD_ID VARCHAR2 (2000)
PRIMARY_CONTACT_FLAG VARCHAR2 (2000)
ADDRESS_EFFECTIVE_DATE VARCHAR2 (2000)
ADDRESS_LINES_PHONETIC VARCHAR2 (2000)
ADDRESS_STYLE VARCHAR2 (2000)
CONTENT_SOURCE_TYPE VARCHAR2 (2000)
LOC_DESCRIPTION VARCHAR2 (2000)
LOC_HIERARCHY_ID VARCHAR2 (2000)
FA_LOCATION_ID VARCHAR2 (2000)
FLOOR VARCHAR2 (2000)
HOUSE_NUMBER VARCHAR2 (2000)
LANGUAGE VARCHAR2 (2000)
LOCATION_DIRECTIONS VARCHAR2 (2000)
PO_BOX_NUMBER VARCHAR2 (2000)
LOCATION_POSITION VARCHAR2 (2000)
POSTAL_PLUS4_CODE VARCHAR2 (2000)
SALES_TAX_GEOCODE VARCHAR2 (2000)
SALES_TAX_INSIDE_CITY_LIMITS VARCHAR2 (2000)
SHORT_DESCRIPTION VARCHAR2 (2000)
STREET VARCHAR2 (2000)
STREET_NUMBER VARCHAR2 (2000)
STREET_SUFFIX VARCHAR2 (2000)
SUITE VARCHAR2 (2000)
TIME_ZONE VARCHAR2 (2000)
LOC_VALIDATED_FLAG VARCHAR2 (2000)
DUNS_NUMBER VARCHAR2 (2000)
GROUP_TYPE VARCHAR2 (2000)
GSA_INDICATOR_FLAG VARCHAR2 (2000)
HQ_BRANCH_IND VARCHAR2 (2000)
JGZZ_FISCAL_CODE VARCHAR2 (2000)
KNOWN_AS VARCHAR2 (2000)
KNOWN_AS2 VARCHAR2 (2000)
KNOWN_AS3 VARCHAR2 (2000)
KNOWN_AS4 VARCHAR2 (2000)
KNOWN_AS5 VARCHAR2 (2000)
LANGUAGE_NAME VARCHAR2 (2000)
LAST_ORDERED_DATE VARCHAR2 (2000)
MISSION_STATEMENT VARCHAR2 (2000)
ORGANIZATION_NAME_PHONETIC VARCHAR2 (2000)
PARTY_NUMBER VARCHAR2 (2000)
PERSON_FIRST_NAME_PHONETIC VARCHAR2 (2000)
PERSON_IDEN_TYPE VARCHAR2 (2000)
PERSON_IDENTIFIER VARCHAR2 (2000)
PERSON_LAST_NAME_PHONETIC VARCHAR2 (2000)
PERSON_NAME_SUFFIX VARCHAR2 (2000)
PERSON_PREVIOUS_LAST_NAME VARCHAR2 (2000)
PARTY_REFERENCE_USE_FLAG VARCHAR2 (2000)
SIC_CODE_TYPE VARCHAR2 (2000)
TAX_NAME VARCHAR2 (2000)
TOTAL_NUM_OF_ORDERS VARCHAR2 (2000)
TOTAL_ORDERED_AMOUNT VARCHAR2 (2000)
PARTIES_VALIDATED_FLAG VARCHAR2 (2000)
PS_USES_COMMENTS VARCHAR2 (2000)
PRIMARY_PER_TYPE VARCHAR2 (2000)
SITE_USE_TYPE VARCHAR2 (2000)
ADDRESSEE VARCHAR2 (2000)
MAILSTOP VARCHAR2 (2000)
PARTY_SITE_NAME VARCHAR2 (2000)
PARTY_SITE_NUMBER VARCHAR2 (2000)
ORG_CNT_COMMENTS VARCHAR2 (2000)
CONTACT_NUMBER VARCHAR2 (2000)
DECISION_MAKER_FLAG VARCHAR2 (2000)
DEPARTMENT VARCHAR2 (2000)
DEPARTMENT_CODE VARCHAR2 (2000)
RANK VARCHAR2 (2000)
PROMOTION_ID VARCHAR2 (2000)
ROLE_LEVEL VARCHAR2 (2000)
PRIMARY_CONTACT_PER_ROLE_TYPE VARCHAR2 (2000)
CNT_PNT_CONTENT_SOURCE_TYPE VARCHAR2 (2000)
PHONE_COUNTRY_CODE VARCHAR2 (2000)
FAX_COUNTRY_CODE VARCHAR2 (2000)
PHONE_CALLING_CALENDAR VARCHAR2 (2000)
CNT_PNT_TIME_ZONE VARCHAR2 (2000)
RAW_PHONE_NUMBER VARCHAR2 (2000)
EMAIL_FORMAT VARCHAR2 (2000)
FAX_EXTENSION VARCHAR2 (2000)
ORG_CNT_TITLE VARCHAR2 (2000)
OFFER_ID VARCHAR2 (2000)
REQUEST_ID VARCHAR2 (2000)
PROGRAM_APPLICATION_ID VARCHAR2 (2000)
PROGRAM_ID VARCHAR2 (2000)
PROGRAM_UPDATE_DATE VARCHAR2 (2000)
LOAD_ERROR_MESSAGE VARCHAR2 (2000)
PHONE_ID VARCHAR2 (2000)
CONTACT_PARTY_ID VARCHAR2 (2000)
SECURITY_GROUP_ID VARCHAR2 (2000)
NET_WORTH VARCHAR2 (2000)
LEAD_NUMBER VARCHAR2 (2000)
PRM_SALES_LEAD_TYPE VARCHAR2 (2000)
PRM_EXEC_SPONSOR_FLAG VARCHAR2 (2000)
PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2 (2000)
INCUMBENT_PARTNER_PARTY_ID VARCHAR2 (2000)
INCUMBENT_PARTNER_RESOURCE_ID VARCHAR2 (2000)
PRM_IND_CLASSIFICATION_CODE VARCHAR2 (2000)
PARTY_TYPE VARCHAR2 (2000)
PARTY_ID VARCHAR2 (2000)
PARTY_SITE_ID VARCHAR2 (2000)
LOCATION_ID VARCHAR2 (2000)
REL_PARTY_ID VARCHAR2 (2000)
SALES_LEAD_ID VARCHAR2 (2000)
CUSTOMER_KEY VARCHAR2 (2000)
ADDRESS_KEY VARCHAR2 (2000)
CONTACT_KEY VARCHAR2 (2000)
NEW_PARTY_FLAG VARCHAR2 (2000)
NEW_LOC_FLAG VARCHAR2 (2000)
NEW_PS_FLAG VARCHAR2 (2000)
NEW_REL_FLAG VARCHAR2 (2000)
NEW_CON_FLAG VARCHAR2 (2000)
LEAD_RANK_ID VARCHAR2 (2000)
MARKETING_SCORE VARCHAR2 (2000)
LEAD_DATE VARCHAR2 (2000)
Stores the lead date.
PERSON_INITIALS VARCHAR2 (2000)
CATEGORY_ID_1 VARCHAR2 (2000)
CATEGORY_ID_2 VARCHAR2 (2000)
CATEGORY_ID_3 VARCHAR2 (2000)
CATEGORY_ID_4 VARCHAR2 (2000)
CATEGORY_ID_5 VARCHAR2 (2000)
SALES_METHODOLOGY_ID VARCHAR2 (2000)
DUNS_NUMBER_C VARCHAR2 (2000)
SOURCE_PRIMARY_REFERENCE VARCHAR2 (2000)
SOURCE_SECONDARY_REFERENCE VARCHAR2 (2000)
NOTE_TYPE VARCHAR2 (2000)
BATCH_ID NUMBER

Stores the batch_id for the record.
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)
AMS_COL252 VARCHAR2 (4000)
AMS_COL253 VARCHAR2 (4000)
AMS_COL254 VARCHAR2 (4000)
AMS_COL255 VARCHAR2 (4000)
AMS_COL256 VARCHAR2 (4000)
AMS_COL257 VARCHAR2 (4000)
AMS_COL258 VARCHAR2 (4000)
AMS_COL259 VARCHAR2 (4000)
AMS_COL260 VARCHAR2 (4000)
AMS_COL261 VARCHAR2 (4000)
AMS_COL262 VARCHAR2 (4000)
AMS_COL263 VARCHAR2 (4000)
AMS_COL264 VARCHAR2 (4000)
AMS_COL265 VARCHAR2 (4000)
AMS_COL266 VARCHAR2 (4000)
AMS_COL267 VARCHAR2 (4000)
AMS_COL268 VARCHAR2 (4000)
AMS_COL269 VARCHAR2 (4000)
AMS_COL270 VARCHAR2 (4000)
AMS_COL271 VARCHAR2 (4000)
AMS_COL272 VARCHAR2 (4000)
AMS_COL273 VARCHAR2 (4000)
AMS_COL274 VARCHAR2 (4000)
AMS_COL275 VARCHAR2 (4000)
AMS_COL276 VARCHAR2 (4000)
AMS_COL277 VARCHAR2 (4000)
AMS_COL278 VARCHAR2 (4000)
AMS_COL279 VARCHAR2 (4000)
AMS_COL280 VARCHAR2 (4000)
AMS_COL281 VARCHAR2 (4000)
AMS_COL282 VARCHAR2 (4000)
AMS_COL283 VARCHAR2 (4000)
AMS_COL284 VARCHAR2 (4000)
AMS_COL285 VARCHAR2 (4000)
AMS_COL286 VARCHAR2 (4000)
AMS_COL287 VARCHAR2 (4000)
AMS_COL288 VARCHAR2 (4000)
AMS_COL289 VARCHAR2 (4000)
AMS_COL290 VARCHAR2 (4000)
AMS_COL291 VARCHAR2 (4000)
AMS_COL292 VARCHAR2 (4000)
AMS_COL293 VARCHAR2 (4000)
AMS_COL294 VARCHAR2 (4000)
AMS_COL295 VARCHAR2 (4000)
AMS_COL296 VARCHAR2 (4000)
AMS_COL297 VARCHAR2 (4000)
AMS_COL298 VARCHAR2 (4000)
AMS_COL299 VARCHAR2 (4000)
AMS_COL300 VARCHAR2 (4000)
AMS_COL301 VARCHAR2 (4000)
AMS_COL302 VARCHAR2 (4000)
AMS_COL303 VARCHAR2 (4000)
AMS_COL304 VARCHAR2 (4000)
AMS_COL305 VARCHAR2 (4000)
AMS_COL306 VARCHAR2 (4000)
AMS_COL307 VARCHAR2 (4000)
AMS_COL308 VARCHAR2 (4000)
AMS_COL309 VARCHAR2 (4000)
AMS_COL310 VARCHAR2 (4000)
AMS_COL311 VARCHAR2 (4000)
AMS_COL312 VARCHAR2 (4000)
AMS_COL313 VARCHAR2 (4000)
AMS_COL314 VARCHAR2 (4000)
AMS_COL315 VARCHAR2 (4000)
AMS_COL316 VARCHAR2 (4000)
AMS_COL317 VARCHAR2 (4000)
AMS_COL318 VARCHAR2 (4000)
AMS_COL319 VARCHAR2 (4000)
AMS_COL320 VARCHAR2 (4000)
AMS_COL321 VARCHAR2 (4000)
AMS_COL322 VARCHAR2 (4000)
AMS_COL323 VARCHAR2 (4000)
AMS_COL324 VARCHAR2 (4000)
AMS_COL325 VARCHAR2 (4000)
AMS_COL326 VARCHAR2 (4000)
AMS_COL327 VARCHAR2 (4000)
AMS_COL328 VARCHAR2 (4000)
AMS_COL329 VARCHAR2 (4000)
AMS_COL330 VARCHAR2 (4000)
AMS_COL331 VARCHAR2 (4000)
AMS_COL332 VARCHAR2 (4000)
AMS_COL333 VARCHAR2 (4000)
AMS_COL334 VARCHAR2 (4000)
AMS_COL335 VARCHAR2 (4000)
AMS_COL336 VARCHAR2 (4000)
AMS_COL337 VARCHAR2 (4000)
AMS_COL338 VARCHAR2 (4000)
AMS_COL339 VARCHAR2 (4000)
AMS_COL340 VARCHAR2 (4000)
AMS_COL341 VARCHAR2 (4000)
AMS_COL342 VARCHAR2 (4000)
AMS_COL343 VARCHAR2 (4000)
AMS_COL344 VARCHAR2 (4000)
AMS_COL345 VARCHAR2 (4000)
AMS_COL346 VARCHAR2 (4000)
AMS_COL347 VARCHAR2 (4000)
AMS_COL348 VARCHAR2 (4000)
AMS_COL349 VARCHAR2 (4000)
AMS_COL350 VARCHAR2 (4000)
AMS_COL351 VARCHAR2 (4000)
AMS_COL352 VARCHAR2 (4000)
AMS_COL353 VARCHAR2 (4000)
AMS_COL354 VARCHAR2 (4000)
AMS_COL355 VARCHAR2 (4000)
AMS_COL356 VARCHAR2 (4000)
AMS_COL357 VARCHAR2 (4000)
AMS_COL358 VARCHAR2 (4000)
AMS_COL359 VARCHAR2 (4000)
AMS_COL360 VARCHAR2 (4000)
AMS_COL361 VARCHAR2 (4000)
AMS_COL362 VARCHAR2 (4000)
AMS_COL363 VARCHAR2 (4000)
AMS_COL364 VARCHAR2 (4000)
AMS_COL365 VARCHAR2 (4000)
AMS_COL366 VARCHAR2 (4000)
AMS_COL367 VARCHAR2 (4000)
AMS_COL368 VARCHAR2 (4000)
AMS_COL369 VARCHAR2 (4000)
AMS_COL370 VARCHAR2 (4000)
AMS_COL371 VARCHAR2 (4000)
AMS_COL372 VARCHAR2 (4000)
AMS_COL373 VARCHAR2 (4000)
AMS_COL374 VARCHAR2 (4000)
AMS_COL375 VARCHAR2 (4000)
AMS_COL376 VARCHAR2 (4000)
AMS_COL377 VARCHAR2 (4000)
AMS_COL378 VARCHAR2 (4000)
AMS_COL379 VARCHAR2 (4000)
AMS_COL380 VARCHAR2 (4000)
AMS_COL381 VARCHAR2 (4000)
AMS_COL382 VARCHAR2 (4000)
AMS_COL383 VARCHAR2 (4000)
AMS_COL384 VARCHAR2 (4000)
AMS_COL385 VARCHAR2 (4000)
AMS_COL386 VARCHAR2 (4000)
AMS_COL387 VARCHAR2 (4000)
AMS_COL388 VARCHAR2 (4000)
AMS_COL389 VARCHAR2 (4000)
AMS_COL390 VARCHAR2 (4000)
AMS_COL391 VARCHAR2 (4000)
AMS_COL392 VARCHAR2 (4000)
AMS_COL393 VARCHAR2 (4000)
AMS_COL394 VARCHAR2 (4000)
AMS_COL395 VARCHAR2 (4000)
AMS_COL396 VARCHAR2 (4000)
AMS_COL397 VARCHAR2 (4000)
AMS_COL398 VARCHAR2 (4000)
AMS_COL399 VARCHAR2 (4000)
AMS_COL400 VARCHAR2 (4000)
AMS_COL401 VARCHAR2 (4000)
AMS_COL402 VARCHAR2 (4000)
AMS_COL403 VARCHAR2 (4000)
AMS_COL404 VARCHAR2 (4000)
AMS_COL405 VARCHAR2 (4000)
AMS_COL406 VARCHAR2 (4000)
AMS_COL407 VARCHAR2 (4000)
AMS_COL408 VARCHAR2 (4000)
AMS_COL409 VARCHAR2 (4000)
AMS_COL410 VARCHAR2 (4000)
AMS_COL411 VARCHAR2 (4000)
AMS_COL412 VARCHAR2 (4000)
AMS_COL413 VARCHAR2 (4000)
AMS_COL414 VARCHAR2 (4000)
AMS_COL415 VARCHAR2 (4000)
AMS_COL416 VARCHAR2 (4000)
AMS_COL417 VARCHAR2 (4000)
AMS_COL418 VARCHAR2 (4000)
AMS_COL419 VARCHAR2 (4000)
AMS_COL420 VARCHAR2 (4000)
AMS_COL421 VARCHAR2 (4000)
AMS_COL422 VARCHAR2 (4000)
AMS_COL423 VARCHAR2 (4000)
AMS_COL424 VARCHAR2 (4000)
AMS_COL425 VARCHAR2 (4000)
AMS_COL426 VARCHAR2 (4000)
AMS_COL427 VARCHAR2 (4000)
AMS_COL428 VARCHAR2 (4000)
AMS_COL429 VARCHAR2 (4000)
AMS_COL430 VARCHAR2 (4000)
AMS_COL431 VARCHAR2 (4000)
AMS_COL432 VARCHAR2 (4000)
AMS_COL433 VARCHAR2 (4000)
AMS_COL434 VARCHAR2 (4000)
AMS_COL435 VARCHAR2 (4000)
AMS_COL436 VARCHAR2 (4000)
Query Text

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


SELECT IMPORT_SOURCE_LINE_ID
,      IMPORT_LIST_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LOAD_STATUS
,      IMPORT_SUCCESSFUL_FLAG
,      OBJECT_VERSION_NUMBER
,      SOURCE_SYSTEM
,      IMP_LIST_HEADER_NUMBER
,      LEAD_NOTE
,      PROMOTION_CODE
,      CUSTOMER_NAME
,      SIC_CODE
,      ANALYSIS_FY
,      CUSTOMER_CATEGORY_CODE
,      FISCAL_YEAREND_MONTH
,      NUM_OF_EMPLOYEES
,      POTENTIAL_REVENUE_CURR_FY
,      POTENTIAL_REVENUE_NEXT_FY
,      CUSTOMER_RANK
,      TAX_REFERENCE
,      YEAR_ESTABLISHED
,      ADDR_DO_NOT_MAIL_FLAG
,      URL
,      CONT_DO_NOT_MAIL_FLAG
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      EMAIL_ADDRESS
,      SEX_CODE
,      SALUTATION
,      LAST_NAME
,      TITLE
,      FIRST_NAME
,      JOB_TITLE
,      PHONE_NUMBER
,      PHONE_STATUS
,      PHONE_TYPE
,      AREA_CODE
,      EXTENSION
,      MIDDLE_INITIAL
,      JOB_TITLE_CODE
,      MAIL_STOP
,      FAX_NUMBER
,      FAX_AREA_CODE
,      DO_NOT_EMAIL_FLAG
,      DO_NOT_FAX_FLAG
,      DO_NOT_PHONE_FLAG
,      CONTACT_ROLE_CODE
,      CHANNEL_CODE
,      BUDGET_AMOUNT
,      BUDGET_STATUS_CODE
,      CURRENCY_CODE
,      DECISION_TIMEFRAME_CODE
,      CLOSE_REASON
,      PARENT_PROJECT
,      DESCRIPTION
,      VEHICLE_RESPONSE_CODE
,      INTEREST_TYPE_ID_1
,      PRIMARY_INTEREST_CODE_ID_1
,      SECONDARY_INTEREST_CODE_ID_1
,      INVENTORY_ITEM_ID_1
,      ORGANIZATION_ID_1
,      UOM_CODE_1
,      QUANTITY_1
,      BUDGET_AMOUNT_1
,      SOURCE_PROMOTION_ID_1
,      OFFER_ID_1
,      INTEREST_TYPE_ID_2
,      PRIMARY_INTEREST_CODE_ID_2
,      SECONDARY_INTEREST_CODE_ID_2
,      INVENTORY_ITEM_ID_2
,      ORGANIZATION_ID_2
,      UOM_CODE_2
,      QUANTITY_2
,      BUDGET_AMOUNT_2
,      SOURCE_PROMOTION_ID_2
,      OFFER_ID_2
,      INTEREST_TYPE_ID_3
,      PRIMARY_INTEREST_CODE_ID_3
,      SECONDARY_INTEREST_CODE_ID_3
,      INVENTORY_ITEM_ID_3
,      ORGANIZATION_ID_3
,      UOM_CODE_3
,      QUANTITY_3
,      BUDGET_AMOUNT_3
,      SOURCE_PROMOTION_ID_3
,      OFFER_ID_3
,      INTEREST_TYPE_ID_4
,      PRIMARY_INTEREST_CODE_ID_4
,      SECONDARY_INTEREST_CODE_ID_4
,      INVENTORY_ITEM_ID_4
,      ORGANIZATION_ID_4
,      UOM_CODE_4
,      QUANTITY_4
,      BUDGET_AMOUNT_4
,      SOURCE_PROMOTION_ID_4
,      OFFER_ID_4
,      INTEREST_TYPE_ID_5
,      PRIMARY_INTEREST_CODE_ID_5
,      SECONDARY_INTEREST_CODE_ID_5
,      INVENTORY_ITEM_ID_5
,      ORGANIZATION_ID_5
,      UOM_CODE_5
,      QUANTITY_5
,      BUDGET_AMOUNT_5
,      SOURCE_PROMOTION_ID_5
,      OFFER_ID_5
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_CODE
,      URGENT_FLAG
,      ACCEPT_FLAG
,      ASSIGN_DATE
,      ASSIGN_SALES_GROUP_ID
,      ASSIGN_TO_PERSON_ID
,      ASSIGN_TO_SALESFORCE_ID
,      AUTO_ASSIGNMENT_TYPE
,      DELETED_FLAG
,      IMPORT_FLAG
,      KEEP_FLAG
,      PRM_ASSIGNMENT_TYPE
,      QUALIFIED_FLAG
,      REJECT_REASON_CODE
,      SCORECARD_ID
,      PRIMARY_CONTACT_FLAG
,      ADDRESS_EFFECTIVE_DATE
,      ADDRESS_LINES_PHONETIC
,      ADDRESS_STYLE
,      CONTENT_SOURCE_TYPE
,      LOC_DESCRIPTION
,      LOC_HIERARCHY_ID
,      FA_LOCATION_ID
,      FLOOR
,      HOUSE_NUMBER
,      LANGUAGE
,      LOCATION_DIRECTIONS
,      PO_BOX_NUMBER
,      LOCATION_POSITION
,      POSTAL_PLUS4_CODE
,      SALES_TAX_GEOCODE
,      SALES_TAX_INSIDE_CITY_LIMITS
,      SHORT_DESCRIPTION
,      STREET
,      STREET_NUMBER
,      STREET_SUFFIX
,      SUITE
,      TIME_ZONE
,      LOC_VALIDATED_FLAG
,      DUNS_NUMBER
,      GROUP_TYPE
,      GSA_INDICATOR_FLAG
,      HQ_BRANCH_IND
,      JGZZ_FISCAL_CODE
,      KNOWN_AS
,      KNOWN_AS2
,      KNOWN_AS3
,      KNOWN_AS4
,      KNOWN_AS5
,      LANGUAGE_NAME
,      LAST_ORDERED_DATE
,      MISSION_STATEMENT
,      ORGANIZATION_NAME_PHONETIC
,      PARTY_NUMBER
,      PERSON_FIRST_NAME_PHONETIC
,      PERSON_IDEN_TYPE
,      PERSON_IDENTIFIER
,      PERSON_LAST_NAME_PHONETIC
,      PERSON_NAME_SUFFIX
,      PERSON_PREVIOUS_LAST_NAME
,      PARTY_REFERENCE_USE_FLAG
,      SIC_CODE_TYPE
,      TAX_NAME
,      TOTAL_NUM_OF_ORDERS
,      TOTAL_ORDERED_AMOUNT
,      PARTIES_VALIDATED_FLAG
,      PS_USES_COMMENTS
,      PRIMARY_PER_TYPE
,      SITE_USE_TYPE
,      ADDRESSEE
,      MAILSTOP
,      PARTY_SITE_NAME
,      PARTY_SITE_NUMBER
,      ORG_CNT_COMMENTS
,      CONTACT_NUMBER
,      DECISION_MAKER_FLAG
,      DEPARTMENT
,      DEPARTMENT_CODE
,      RANK
,      PROMOTION_ID
,      ROLE_LEVEL
,      PRIMARY_CONTACT_PER_ROLE_TYPE
,      CNT_PNT_CONTENT_SOURCE_TYPE
,      PHONE_COUNTRY_CODE
,      FAX_COUNTRY_CODE
,      PHONE_CALLING_CALENDAR
,      CNT_PNT_TIME_ZONE
,      RAW_PHONE_NUMBER
,      EMAIL_FORMAT
,      FAX_EXTENSION
,      ORG_CNT_TITLE
,      OFFER_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LOAD_ERROR_MESSAGE
,      PHONE_ID
,      CONTACT_PARTY_ID
,      SECURITY_GROUP_ID
,      NET_WORTH
,      LEAD_NUMBER
,      PRM_SALES_LEAD_TYPE
,      PRM_EXEC_SPONSOR_FLAG
,      PRM_PRJ_LEAD_IN_PLACE_FLAG
,      INCUMBENT_PARTNER_PARTY_ID
,      INCUMBENT_PARTNER_RESOURCE_ID
,      PRM_IND_CLASSIFICATION_CODE
,      PARTY_TYPE
,      PARTY_ID
,      PARTY_SITE_ID
,      LOCATION_ID
,      REL_PARTY_ID
,      SALES_LEAD_ID
,      CUSTOMER_KEY
,      ADDRESS_KEY
,      CONTACT_KEY
,      NEW_PARTY_FLAG
,      NEW_LOC_FLAG
,      NEW_PS_FLAG
,      NEW_REL_FLAG
,      NEW_CON_FLAG
,      LEAD_RANK_ID
,      MARKETING_SCORE
,      LEAD_DATE
,      PERSON_INITIALS
,      CATEGORY_ID_1
,      CATEGORY_ID_2
,      CATEGORY_ID_3
,      CATEGORY_ID_4
,      CATEGORY_ID_5
,      SALES_METHODOLOGY_ID
,      DUNS_NUMBER_C
,      SOURCE_PRIMARY_REFERENCE
,      SOURCE_SECONDARY_REFERENCE
,      NOTE_TYPE
,      BATCH_ID
,      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
,      AMS_COL401
,      AMS_COL402
,      AMS_COL403
,      AMS_COL404
,      AMS_COL405
,      AMS_COL406
,      AMS_COL407
,      AMS_COL408
,      AMS_COL409
,      AMS_COL410
,      AMS_COL411
,      AMS_COL412
,      AMS_COL413
,      AMS_COL414
,      AMS_COL415
,      AMS_COL416
,      AMS_COL417
,      AMS_COL418
,      AMS_COL419
,      AMS_COL420
,      AMS_COL421
,      AMS_COL422
,      AMS_COL423
,      AMS_COL424
,      AMS_COL425
,      AMS_COL426
,      AMS_COL427
,      AMS_COL428
,      AMS_COL429
,      AMS_COL430
,      AMS_COL431
,      AMS_COL432
,      AMS_COL433
,      AMS_COL434
,      AMS_COL435
,      AMS_COL436
FROM APPS.AMS_LEAD_MAPPING_V;

Dependencies

[top of page]

APPS.AMS_LEAD_MAPPING_V references the following:

SchemaAPPS
SynonymAMS_IMP_SOURCE_LINES
APPS.AMS_LEAD_MAPPING_V is referenced by following:

SchemaAPPS
Package BodyAMS_IMPORTCLIENT_PVT - show dependent code
Package BodyAMS_LISTIMPORT_PVT - show dependent code