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]

VIEW: JTF.CAC_SYNC_CONTACT_MAPPINGS#

Object Details

Object Name:	CAC_SYNC_CONTACT_MAPPINGS#
Object Type:	VIEW
Owner:	JTF
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SYNC_CONTACT_MAPPING_ID	NUMBER	(15)	Yes
CONTACT_PARTY_ID	NUMBER	(15)	Yes
ORG_PARTY_ID	NUMBER	(15)	Yes
PERSON_PARTY_ID	NUMBER	(15)	Yes
PARTY_SITE_ID	NUMBER	(15)
WORK_CONTACT_POINT_ID	NUMBER	(15)
HOME_CONTACT_POINT_ID	NUMBER	(15)
FAX_CONTACT_POINT_ID	NUMBER	(15)
CELL_CONTACT_POINT_ID	NUMBER	(15)
PAGER_CONTACT_POINT_ID	NUMBER	(15)
EMAIL_CONTACT_POINT_ID	NUMBER	(15)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

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


SELECT SYNC_CONTACT_MAPPING_ID
,      CONTACT_PARTY_ID
,      ORG_PARTY_ID
,      PERSON_PARTY_ID
,      PARTY_SITE_ID
,      WORK_CONTACT_POINT_ID
,      HOME_CONTACT_POINT_ID
,      FAX_CONTACT_POINT_ID
,      CELL_CONTACT_POINT_ID
,      PAGER_CONTACT_POINT_ID
,      EMAIL_CONTACT_POINT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM JTF.CAC_SYNC_CONTACT_MAPPINGS#;

Dependencies

[top of page]

JTF.CAC_SYNC_CONTACT_MAPPINGS# references the following:

JTF: CAC_SYNC_CONTACT_MAPPINGS

JTF.CAC_SYNC_CONTACT_MAPPINGS# is referenced by following:

APPS: CAC_SYNC_CONTACT_MAPPINGS