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

TABLE: JTF.JTA_SYNC_CONTACT_MAPPING

Object Details
Object Name: JTA_SYNC_CONTACT_MAPPING
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTA_SYNC_CONTACT_MAPPING
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTA_SYNC_CONTACT_MAPPING_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSYNC_CONTACT_ID
JTA_SYNC_CONTACT_MAPPING_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnCONTACT_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
SYNC_CONTACT_ID NUMBER
Yes Sync contact unique identifier
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Future used
CATEGORY VARCHAR2 (255) Yes Object Category
RESOURCE_ID NUMBER
Yes Resource Id
CONTACT_PARTY_ID NUMBER
Yes Party Id
CONTACT_PARTY_OVN NUMBER
Yes Object Version Number for the contact party
CONTACT_PARTY_OPERATION VARCHAR2 (30) Yes DML Operation - NEW, UPDATE, DELETE
PERSON_PARTY_ID NUMBER

Person Party Id
PERSON_PARTY_OVN NUMBER

Object Version Number for Person Party
ORGANIZATION_PARTY_ID NUMBER

Organization Party Id
ORGANIZATION_PARTY_OVN NUMBER

Object Version Number for Organization Party
BUSINESS_PARTY_LOCATION_ID NUMBER

BUSINESS_PARTY_LOCATION_OVN NUMBER

BUSINESS_PARTY_SITE_ID NUMBER

Business Party Site Id
BUSINESS_PARTY_SITE_OVN NUMBER

Object Version Number for Business Party Site
HOME_PARTY_LOCATION_ID NUMBER

HOME_PARTY_LOCATION_OVN NUMBER

HOME_PARTY_SITE_ID NUMBER

Home Party Site Id
HOME_PARTY_SITE_OVN NUMBER

Object Version Number for Home Party Site
BUSINESS_EMAIL_CP_ID NUMBER

Email Contact Point ID for Business
BUSINESS_EMAIL_CP_OVN NUMBER

Object Version Number for Business Email
HOME_EMAIL_CP_ID NUMBER

Email Contact Point ID for Home
HOME_EMAIL_CP_OVN NUMBER

Object Version Number for Home Email
PRIMARY_PHONE_CP_ID NUMBER

Primary Phone Contact Point ID
PRIMARY_PHONE_CP_OVN NUMBER

Object Version Number for primary phone
BUSINESS_PHONE_CP_ID NUMBER

Business Phone Contact Point ID
BUSINESS_PHONE_CP_OVN NUMBER

Object Versin Number for business phone
BUSINESS_PHONE_CONT_CP_ID NUMBER

BUSINESS_PHONE_CONT_CP_OVN NUMBER

HOME_BUSINESS_PHONE_CP_ID NUMBER

Home business phone ID
HOME_BUSINESS_PHONE_CP_OVN NUMBER

Object Versin Number for home business phone
HOME_PHONE_CP_ID NUMBER

Home Phone Contact Point ID
HOME_PHONE_CP_OVN NUMBER

Object Version Number for Home Phone
MOBILE_PHONE_CP_ID NUMBER

Mobile Phone Contact Point ID
MOBILE_PHONE_CP_OVN NUMBER

Object Version Number for Mobile Phone Contact Point
OTHER_PHONE_CP_ID NUMBER

Other Phone Contact Point ID
OTHER_PHONE_CP_OVN NUMBER

Object Version Number for Other Phone Contact Point
BUSINESS_FAX_CP_ID NUMBER

Business Fax Contact Point ID
BUSINESS_FAX_CP_OVN NUMBER

Object Version Number for Business Fax
HOME_FAX_CP_ID NUMBER

Home Fax Contact Point ID
HOME_FAX_CP_OVN NUMBER

Object Version Number for Home Fax Contact Point
BUSINESS_PAGER_CP_ID NUMBER

Business Pager Contact Point ID
BUSINESS_PAGER_CP_OVN NUMBER

Object Version Number for Business Pager
NOTE_ID NUMBER

Note ID
NOTE_OVN NUMBER

Object Version Number for Note
CONTACT_RELATIONSHIP_ID NUMBER

CONTACT_RELATIONSHIP_OVN NUMBER

Query Text

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


SELECT SYNC_CONTACT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      CATEGORY
,      RESOURCE_ID
,      CONTACT_PARTY_ID
,      CONTACT_PARTY_OVN
,      CONTACT_PARTY_OPERATION
,      PERSON_PARTY_ID
,      PERSON_PARTY_OVN
,      ORGANIZATION_PARTY_ID
,      ORGANIZATION_PARTY_OVN
,      BUSINESS_PARTY_LOCATION_ID
,      BUSINESS_PARTY_LOCATION_OVN
,      BUSINESS_PARTY_SITE_ID
,      BUSINESS_PARTY_SITE_OVN
,      HOME_PARTY_LOCATION_ID
,      HOME_PARTY_LOCATION_OVN
,      HOME_PARTY_SITE_ID
,      HOME_PARTY_SITE_OVN
,      BUSINESS_EMAIL_CP_ID
,      BUSINESS_EMAIL_CP_OVN
,      HOME_EMAIL_CP_ID
,      HOME_EMAIL_CP_OVN
,      PRIMARY_PHONE_CP_ID
,      PRIMARY_PHONE_CP_OVN
,      BUSINESS_PHONE_CP_ID
,      BUSINESS_PHONE_CP_OVN
,      BUSINESS_PHONE_CONT_CP_ID
,      BUSINESS_PHONE_CONT_CP_OVN
,      HOME_BUSINESS_PHONE_CP_ID
,      HOME_BUSINESS_PHONE_CP_OVN
,      HOME_PHONE_CP_ID
,      HOME_PHONE_CP_OVN
,      MOBILE_PHONE_CP_ID
,      MOBILE_PHONE_CP_OVN
,      OTHER_PHONE_CP_ID
,      OTHER_PHONE_CP_OVN
,      BUSINESS_FAX_CP_ID
,      BUSINESS_FAX_CP_OVN
,      HOME_FAX_CP_ID
,      HOME_FAX_CP_OVN
,      BUSINESS_PAGER_CP_ID
,      BUSINESS_PAGER_CP_OVN
,      NOTE_ID
,      NOTE_OVN
,      CONTACT_RELATIONSHIP_ID
,      CONTACT_RELATIONSHIP_OVN
FROM JTF.JTA_SYNC_CONTACT_MAPPING;

Dependencies

[top of page]

JTF.JTA_SYNC_CONTACT_MAPPING does not reference any database object

JTF.JTA_SYNC_CONTACT_MAPPING is referenced by following:

SchemaAPPS
SynonymJTA_SYNC_CONTACT_MAPPING