[Home] [Help] [Dependency Information]
Object Name: | CSC_CUST_ACCOUNTS_ROLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_CUST_ACCOUNTS_ROLES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Identification of a Row | |
PARTY_ID | NUMBER | (15) | Yes | Party id of Principal Owner of the Account |
CUST_ACCOUNT_ID | NUMBER | (15) | Yes | Cust Account Id (Primary Key) of HZ_CUST_ACCOUNTS |
CUST_ACCT_SITE_ID | NUMBER | (15) | Primary Key of HZ_CUST_ACCT_SITES_ALL | |
CUST_ACCOUNT_ROLE_ID | NUMBER | (15) | Yes | Cust Account Role Id (Primary Key) of HZ_CUST_ACCOUNT_ROLES |
PARTY_SITE_ID | NUMBER | (15) | Site Id of a customer | |
PARTY_NAME | VARCHAR2 | (301) | Name of a customer | |
ROLE_TYPE | VARCHAR2 | (30) | Yes | Type of a Role |
ROLE_TYPE_DESCRIPTION | VARCHAR2 | (80) | Yes | Description of a role type |
STATUS | VARCHAR2 | (1) | State of a current role | |
ROLE_STATUS_DESCRIPTION | VARCHAR2 | (80) | Yes | Description of a role status |
PRIMARY_FLAG | VARCHAR2 | (1) | Primary Flag | |
FIRST_NAME | VARCHAR2 | (150) | First Name of Contact | |
LAST_NAME | VARCHAR2 | (150) | Last Name of Contact | |
MIDDLE_NAME | VARCHAR2 | (60) | Middle Name of Contact | |
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 | |
PROVINCE | VARCHAR2 | (60) | Province | |
COUNTY | VARCHAR2 | (60) | County | |
COUNTRY | VARCHAR2 | (60) | Country Code | |
COUNTRY_NAME | VARCHAR2 | (80) | Country Name | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Last Updated By |
CREATION_DATE | DATE | Yes | Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Who Column | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Category | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PARTY_ID
, CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID
, CUST_ACCOUNT_ROLE_ID
, PARTY_SITE_ID
, PARTY_NAME
, ROLE_TYPE
, ROLE_TYPE_DESCRIPTION
, STATUS
, ROLE_STATUS_DESCRIPTION
, PRIMARY_FLAG
, FIRST_NAME
, LAST_NAME
, MIDDLE_NAME
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, COUNTRY
, COUNTRY_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
FROM APPS.CSC_CUST_ACCOUNTS_ROLES_V;
APPS.CSC_CUST_ACCOUNTS_ROLES_V is not referenced by any database object
|
|
|