eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AMS.AMS_PARTY_SOURCES

Object Details

Object Name:	AMS_PARTY_SOURCES
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_PARTY_SOURCES
Subobject Name:
Status:	VALID

AMS_PARTY_SOURCES stores the PARTY_ID, identifiers for the imported list, recorded details on the party originating from the external source and the mapping template used while import(used to interpret the details for the party as recorded in the imports table).
An outbound marketing target list can be based on a list purchased from external vendors, parties contacted through such list are recorded as customer or contacts in the HZ tables once they accept the promotional offer. CRM applications need to record the source of such a newly added party information in HZ table, this is recorded in the table AMS_PARTY_SOURCES in the AMS schema.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_PARTY_SOURCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_SOURCES_ID
AMS_PARTY_SOURCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
AMS_PARTY_SOURCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IMPORT_LIST_HEADER_ID
AMS_PARTY_SOURCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IMPORT_SOURCE_LINE_ID
AMS_PARTY_SOURCES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_SOURCE_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_SOURCES_ID	NUMBER		Yes	Unique Identifier.
PARTY_ID	NUMBER		Yes	Reference key to the Apps party entity.
IMPORT_SOURCE_LINE_ID	NUMBER		Yes	Reference key to the imported record which was used to populate the current record.
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard WHO Column
IMPORT_LIST_HEADER_ID	NUMBER		Yes	Reference key to the corresponding import header.
LIST_SOURCE_TYPE_ID	NUMBER		Yes	FK to reference list column mapping.
USED_FLAG	VARCHAR2	(1)	Yes	Used for indicating whether a targeted customer responded.
OVERLAY_FLAG	VARCHAR2	(1)	Yes	Used to indicate whether a customer record exists in HZ_PARTIES.
OVERLAY_DATE	DATE			Used to record the date which a record overlay was done -- the OVERLAY_FLAG was set to 'Y'.
COL1	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL2	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL3	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL4	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL5	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL6	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL7	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL8	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL9	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL10	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL11	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL12	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL13	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL14	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL15	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL16	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL17	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL18	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL19	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL20	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL21	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL22	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL23	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL24	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL25	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL26	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL27	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL28	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL29	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL30	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL31	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL32	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL33	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL34	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL35	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL36	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL37	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL38	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL39	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL40	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL41	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL42	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL43	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL44	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL45	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL46	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL47	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL48	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL49	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL50	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL51	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL52	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL53	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL54	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL55	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL56	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL57	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL58	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL59	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL60	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL61	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL62	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL63	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL64	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL65	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL66	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL67	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL68	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL69	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL70	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL71	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL72	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL73	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL74	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL75	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL76	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL77	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL78	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL79	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL80	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL81	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL82	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL83	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL84	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL85	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL86	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL87	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL88	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL89	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL90	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL91	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL92	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL93	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL94	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL95	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL96	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL97	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL98	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL99	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL100	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL101	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL102	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL103	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL104	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL105	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL106	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL107	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL108	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL109	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL110	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL111	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL112	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL113	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL114	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL115	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL116	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL117	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL118	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL119	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL120	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL121	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL122	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL123	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL124	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL125	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL126	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL127	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL128	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL129	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL130	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL131	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL132	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL133	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL134	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL135	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL136	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL137	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL138	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL139	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL140	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL141	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL142	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL143	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL144	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL145	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL146	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL147	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL148	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL149	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL150	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL151	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL152	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL153	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL154	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL155	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL156	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL157	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL158	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL159	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL160	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL161	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL162	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL163	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL164	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL165	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL166	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL167	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL168	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL169	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL170	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL171	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL172	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL173	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL174	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL175	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL176	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL177	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL178	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL179	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL180	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL181	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL182	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL183	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL184	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL185	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL186	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL187	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL188	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL189	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL190	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL191	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL192	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL193	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL194	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL195	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL196	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL197	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL198	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL199	VARCHAR2	(150)		Generic column used as containers for imported data. Maximum size is 150 characters.
COL200	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL201	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL202	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL203	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL204	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL205	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL206	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL207	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL208	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL209	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL210	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL211	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL212	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL213	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL214	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL215	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL216	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL217	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL218	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL219	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL220	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL221	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL222	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL223	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL224	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL225	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL226	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL227	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL228	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL229	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL230	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL231	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL232	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL233	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL234	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL235	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL236	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL237	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL238	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL239	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL240	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL241	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL242	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL243	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL244	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL245	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL246	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL247	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL248	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL249	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
COL250	VARCHAR2	(4000)		Generic column used as containers for imported data. Maximum size is 4000 characters.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER			Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.

Query Text

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


SELECT PARTY_SOURCES_ID
,      PARTY_ID
,      IMPORT_SOURCE_LINE_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      IMPORT_LIST_HEADER_ID
,      LIST_SOURCE_TYPE_ID
,      USED_FLAG
,      OVERLAY_FLAG
,      OVERLAY_DATE
,      COL1
,      COL2
,      COL3
,      COL4
,      COL5
,      COL6
,      COL7
,      COL8
,      COL9
,      COL10
,      COL11
,      COL12
,      COL13
,      COL14
,      COL15
,      COL16
,      COL17
,      COL18
,      COL19
,      COL20
,      COL21
,      COL22
,      COL23
,      COL24
,      COL25
,      COL26
,      COL27
,      COL28
,      COL29
,      COL30
,      COL31
,      COL32
,      COL33
,      COL34
,      COL35
,      COL36
,      COL37
,      COL38
,      COL39
,      COL40
,      COL41
,      COL42
,      COL43
,      COL44
,      COL45
,      COL46
,      COL47
,      COL48
,      COL49
,      COL50
,      COL51
,      COL52
,      COL53
,      COL54
,      COL55
,      COL56
,      COL57
,      COL58
,      COL59
,      COL60
,      COL61
,      COL62
,      COL63
,      COL64
,      COL65
,      COL66
,      COL67
,      COL68
,      COL69
,      COL70
,      COL71
,      COL72
,      COL73
,      COL74
,      COL75
,      COL76
,      COL77
,      COL78
,      COL79
,      COL80
,      COL81
,      COL82
,      COL83
,      COL84
,      COL85
,      COL86
,      COL87
,      COL88
,      COL89
,      COL90
,      COL91
,      COL92
,      COL93
,      COL94
,      COL95
,      COL96
,      COL97
,      COL98
,      COL99
,      COL100
,      COL101
,      COL102
,      COL103
,      COL104
,      COL105
,      COL106
,      COL107
,      COL108
,      COL109
,      COL110
,      COL111
,      COL112
,      COL113
,      COL114
,      COL115
,      COL116
,      COL117
,      COL118
,      COL119
,      COL120
,      COL121
,      COL122
,      COL123
,      COL124
,      COL125
,      COL126
,      COL127
,      COL128
,      COL129
,      COL130
,      COL131
,      COL132
,      COL133
,      COL134
,      COL135
,      COL136
,      COL137
,      COL138
,      COL139
,      COL140
,      COL141
,      COL142
,      COL143
,      COL144
,      COL145
,      COL146
,      COL147
,      COL148
,      COL149
,      COL150
,      COL151
,      COL152
,      COL153
,      COL154
,      COL155
,      COL156
,      COL157
,      COL158
,      COL159
,      COL160
,      COL161
,      COL162
,      COL163
,      COL164
,      COL165
,      COL166
,      COL167
,      COL168
,      COL169
,      COL170
,      COL171
,      COL172
,      COL173
,      COL174
,      COL175
,      COL176
,      COL177
,      COL178
,      COL179
,      COL180
,      COL181
,      COL182
,      COL183
,      COL184
,      COL185
,      COL186
,      COL187
,      COL188
,      COL189
,      COL190
,      COL191
,      COL192
,      COL193
,      COL194
,      COL195
,      COL196
,      COL197
,      COL198
,      COL199
,      COL200
,      COL201
,      COL202
,      COL203
,      COL204
,      COL205
,      COL206
,      COL207
,      COL208
,      COL209
,      COL210
,      COL211
,      COL212
,      COL213
,      COL214
,      COL215
,      COL216
,      COL217
,      COL218
,      COL219
,      COL220
,      COL221
,      COL222
,      COL223
,      COL224
,      COL225
,      COL226
,      COL227
,      COL228
,      COL229
,      COL230
,      COL231
,      COL232
,      COL233
,      COL234
,      COL235
,      COL236
,      COL237
,      COL238
,      COL239
,      COL240
,      COL241
,      COL242
,      COL243
,      COL244
,      COL245
,      COL246
,      COL247
,      COL248
,      COL249
,      COL250
,      SECURITY_GROUP_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM AMS.AMS_PARTY_SOURCES;

Dependencies

[top of page]

AMS.AMS_PARTY_SOURCES does not reference any database object

AMS.AMS_PARTY_SOURCES is referenced by following:

APPS: AMS_PARTY_SOURCES