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: ViewAMS.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:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_PARTIES

APPS.AMS_ORG_ACCT_ROLES_V is not referenced by any database object