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_PARTY_ACCOUNTS_V

Object Details

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

View Type

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

JTF_PARTY_ACCOUNTS_V stores information about customes. If a party becomes a customer, information about the customer account and the account role is stored in this view. You can establish multiple customer relationships with a single party, so each party can have multiple customer account records. Each account can have multiple roles defined against it.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
PARTY_ID	NUMBER	(15)	Yes	Identifier of the party who has become a customer. FK to HZ_PARTIES
PARTY_NUMBER	VARCHAR2	(30)	Yes	Party number of the party who has become a customer
PARTY_NAME	VARCHAR2	(360)	Yes	Name of the party who has become a customer
PARTY_TYPE	VARCHAR2	(30)	Yes	Party type. Organization or Person or Group or Party Relationship
PRIMARY_FLAG	VARCHAR2	(1)		Indicates if this party occupies the primary role for this account. Y for a party in the primary role for this account, N for all other parties.
ROLE	VARCHAR2	(30)		Role played by the party in the customer account
CUST_ACCOUNT_ID	NUMBER	(15)	Yes	FK to HZ_CUST_ACCOUNTS_ALL
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes	Account Number
ACCOUNT_NAME	VARCHAR2	(240)		Account Name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.

Query Text

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


SELECT ROW_ID
,      PARTY_ID
,      PARTY_NUMBER
,      PARTY_NAME
,      PARTY_TYPE
,      PRIMARY_FLAG
,      ROLE
,      CUST_ACCOUNT_ID
,      ACCOUNT_NUMBER
,      ACCOUNT_NAME
,      LAST_UPDATE_DATE
FROM APPS.JTF_PARTY_ACCOUNTS_V;

Dependencies

[top of page]

APPS.JTF_PARTY_ACCOUNTS_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_PARTIES

APPS.JTF_PARTY_ACCOUNTS_V is not referenced by any database object