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_ORG_ACCT_ROLES_V

Object Details

Object Name:	AMS_ORG_ACCT_ROLES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_ORG_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	Party Identifier
CUST_ACCOUNT_ID	NUMBER	(15)	Yes	Customer Account Identifier
BEGIN_DATE	DATE			Date that the party's role in the account begins
END_DATE	DATE			The date that the role is no longer related to the account.
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

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
FROM APPS.AMS_ORG_ACCT_ROLES_V;

Dependencies

[top of page]

APPS.AMS_ORG_ACCT_ROLES_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_PARTIES

APPS.AMS_ORG_ACCT_ROLES_V is not referenced by any database object