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: APPS.JTF_TASK_PARTY_CONTACTS_V

Object Details

Object Name:	JTF_TASK_PARTY_CONTACTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_TASK_PARTY_CONTACTS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View all contacts, using hz_relationship table as the driving table. The view expose data for subject and object party. Please note that the view does not join with hz_org_contacts.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SUBJECT_PARTY_ID	NUMBER	(15)	Yes	Subject Party Id
SUBJECT_PARTY_NUMBER	VARCHAR2	(30)	Yes	Subject Party Number
SUBJECT_PARTY_NAME	VARCHAR2	(360)	Yes	Subject Party Name
VALIDATED_FLAG	VARCHAR2	(1)		Validated Flag
PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(30)		Person Pre Name Adjunct
PERSON_FIRST_NAME	VARCHAR2	(150)		Person First Name
PERSON_MIDDLE_NAME	VARCHAR2	(60)		Person Middle Name
PERSON_LAST_NAME	VARCHAR2	(150)		Person Last Name
PERSON_NAME_SUFFIX	VARCHAR2	(30)		Person Name Suffix
PERSON_TITLE	VARCHAR2	(60)		Person Title
PERSON_ACADEMIC_TITLE	VARCHAR2	(30)		Person Academic Title
PERSON_PREVIOUS_LAST_NAME	VARCHAR2	(150)		Person Previous Last Name
KNOWN_AS	VARCHAR2	(240)		Known As
PERSON_IDEN_TYPE	VARCHAR2	(30)		Person Iden Type
PERSON_IDENTIFIER	VARCHAR2	(60)		Person Identifier
JGZZ_FISCAL_CODE	VARCHAR2	(20)		JGZZ Fiscal Code
TAX_NAME	VARCHAR2	(60)		Tax Name
TAX_REFERENCE	VARCHAR2	(50)		Tax Reference
START_DATE	DATE		Yes	Start Date
END_DATE	DATE			End Date
SUBJECT_ID	NUMBER	(15)	Yes	Subject Id
PARTY_RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	Party Relationship Type
PARTY_RELATIONSHIP_ID	NUMBER	(15)	Yes	Party Relationship Id
PARTY_ID	NUMBER	(15)		Party Id
OBJECT_PARTY_ID	NUMBER	(15)	Yes	Object Party Id
RELATIONSHIP_EMAIL_ADDRESS	VARCHAR2	(2000)		Relationship Email Address
STATUS	VARCHAR2	(1)	Yes	Status of Contact Person
ADDRESS1	VARCHAR2	(240)		Address1
ADDRESS2	VARCHAR2	(240)		Address2
ADDRESS3	VARCHAR2	(240)		Address3
ADDRESS4	VARCHAR2	(240)		Address4
CITY	VARCHAR2	(60)		City
POSTAL_CODE	VARCHAR2	(60)		Postal Code
STATE	VARCHAR2	(60)		State
COUNTRY	VARCHAR2	(60)		Country
PHONE_COUNTRY_CODE	VARCHAR2	(10)		Phone Country Code
PHONE_AREA_CODE	VARCHAR2	(10)		Phone Area Code
PHONE_NUMBER	VARCHAR2	(40)		Phone Number
PHONE_EXTENSION	VARCHAR2	(20)		Phone Extension
JOB_TITLE	VARCHAR2	(100)		This is contact job title

Query Text

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


SELECT SUBJECT_PARTY_ID
,      SUBJECT_PARTY_NUMBER
,      SUBJECT_PARTY_NAME
,      VALIDATED_FLAG
,      PERSON_PRE_NAME_ADJUNCT
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PREVIOUS_LAST_NAME
,      KNOWN_AS
,      PERSON_IDEN_TYPE
,      PERSON_IDENTIFIER
,      JGZZ_FISCAL_CODE
,      TAX_NAME
,      TAX_REFERENCE
,      START_DATE
,      END_DATE
,      SUBJECT_ID
,      PARTY_RELATIONSHIP_TYPE
,      PARTY_RELATIONSHIP_ID
,      PARTY_ID
,      OBJECT_PARTY_ID
,      RELATIONSHIP_EMAIL_ADDRESS
,      STATUS
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      COUNTRY
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      JOB_TITLE
FROM APPS.JTF_TASK_PARTY_CONTACTS_V;

Dependencies

[top of page]

APPS.JTF_TASK_PARTY_CONTACTS_V references the following:

APPS: HZ_CODE_ASSIGNMENTS; HZ_CONTACT_POINTS; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_RELATIONSHIPS; HZ_RELATIONSHIP_TYPES

APPS.JTF_TASK_PARTY_CONTACTS_V is not referenced by any database object