DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKE_PROJECT_CUSTOMERS_V

Object Details
Object Name: OKE_PROJECT_CUSTOMERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_PROJECT_CUSTOMERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database generated row identifier
PROJECT_ID NUMBER (15) Yes System generated project unique identifier
CUSTOMER_ID NUMBER (15) Yes Customer unique identifier
CUSTOMER_NAME VARCHAR2 (360) Yes Customer name
CUSTOMER_NUMBER VARCHAR2 (30) Yes Customer number
CUSTOMER_STATUS VARCHAR2 (1)
Customer status
PARTY_ID NUMBER (15) Yes Party unique identifier for this customer
PROJECT_RELATIONSHIP_CODE VARCHAR2 (30) Yes Internal code for the type of customer relationship that the customer has on the project
PROJECT_RELATIONSHIP_M VARCHAR2 (80) Yes Displayed name for the type of customer relationship that the customer has on the project
CUSTOMER_BILL_SPLIT NUMBER (7)
The percentage of the total project revenue and invoice that the customer is charged
Query Text

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


SELECT ROW_ID
,      PROJECT_ID
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_STATUS
,      PARTY_ID
,      PROJECT_RELATIONSHIP_CODE
,      PROJECT_RELATIONSHIP_M
,      CUSTOMER_BILL_SPLIT
FROM APPS.OKE_PROJECT_CUSTOMERS_V;

Dependencies

[top of page]

APPS.OKE_PROJECT_CUSTOMERS_V references the following:

SchemaAPPS
ViewPA_CUSTOMERS_V
ViewPA_CUSTOMER_RELATIONSHIPS_V
SynonymPA_PROJECT_CUSTOMERS

APPS.OKE_PROJECT_CUSTOMERS_V is not referenced by any database object