[Home] [Help] [Dependency Information]
Object Name: | PAFV_CUSTOMER_CONTACTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PAFV_CUSTOMER_CONTACTS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A Business Intelligence System view
This shows information about customer representatives involved with projects.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | Unique identifier for Project |
PROJECT_NAME | VARCHAR2 | (30) | Yes | Project Name |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | Project Number |
CUSTOMER_ID | NUMBER | (15) | Yes | Unique identifier for Customer |
CUSTOMER_NAME | VARCHAR2 | (360) | Yes | Customer Name |
CONTACT_ID | NUMBER | (15) | Yes | Unique identifier for Contact |
CONTACT_NAME | VARCHAR2 | (301) | Contact Name | |
PROJECT_CONTACT_TYPE_CODE | VARCHAR2 | (30) | Yes | Project Contact Type Code |
_LA:PROJECT CONTACT TYPE | CHAR | (73) | Project Contact Type | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
CREATION_DATE | DATE | Yes | Standard WHO column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NAME
, PROJECT_NUMBER
, CUSTOMER_ID
, CUSTOMER_NAME
, CONTACT_ID
, CONTACT_NAME
, PROJECT_CONTACT_TYPE_CODE
, _LA:PROJECT CONTACT TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM APPS.PAFV_CUSTOMER_CONTACTS;
APPS.PAFV_CUSTOMER_CONTACTS is not referenced by any database object
|
|
|