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.AMS_PERSON_ACCT_ROLES_V

Object Details

Object Name:	AMS_PERSON_ACCT_ROLES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_PERSON_ACCT_ROLES_V
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUST_ACCOUNT_ROLE_ID	NUMBER	(15)	Yes	Unique identifier for the role played by the party in the customer account
PARTY_ID	NUMBER	(15)	Yes	Foreign key to the HZ_PARTIES table
CUST_ACCOUNT_ID	NUMBER	(15)	Yes	Foreign key to the HZ_CUST_ACCOUNTS table
BEGIN_DATE	DATE			Date that the party's role in the account begins
END_DATE	DATE			Date that the party's role in the account ends
CUST_ACCT_SITE_ID	NUMBER	(15)		Customer account site identifier. Foreign key to the HZ_CUST_ACCT_SITES_ALL table
ROLE_TYPE	VARCHAR2	(30)	Yes	Lookup for type of role a party performs.
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.
CURRENT_ROLE_STATE	VARCHAR2	(30)		The status of a role that the customer or party has assumed.
CURRENT_ROLE_STATE_EFFECTIVE	DATE			The date that the current role state became effective. This can be a future date.
SOURCE_CODE	VARCHAR2	(150)		Promotion that was used to make the party a customer
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		Site use identifier from foreign system

Query Text

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


SELECT CUST_ACCOUNT_ROLE_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      BEGIN_DATE
,      END_DATE
,      CUST_ACCT_SITE_ID
,      ROLE_TYPE
,      PRIMARY_FLAG
,      CURRENT_ROLE_STATE
,      CURRENT_ROLE_STATE_EFFECTIVE
,      SOURCE_CODE
,      ORIG_SYSTEM_REFERENCE
FROM APPS.AMS_PERSON_ACCT_ROLES_V;

Dependencies

[top of page]

APPS.AMS_PERSON_ACCT_ROLES_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_PARTIES

APPS.AMS_PERSON_ACCT_ROLES_V is not referenced by any database object