[Home] [Help] [Dependency Information]
Object Name: | AMS_LEAD_MAPPING_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_LEAD_MAPPING_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
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;
|
|
|