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.PAFV_CUSTOMERS

Object Details

Object Name:	PAFV_CUSTOMERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PAFV_CUSTOMERS
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
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the project from which the costs are collected , summarized , and transferred from Oracle Projects.
PROJECT_NAME	VARCHAR2	(30)	Yes	Project Name
PROJECT_NUMBER	VARCHAR2	(25)	Yes	Project Number
CUSTOMER_ID	NUMBER	(15)	Yes	Unique identifier for this customer.
CUSTOMER_NAME	VARCHAR2	(360)	Yes	Customer name.
_LA:PROJECT_CUST_RELATION	CHAR	(78)		Project Cust Relation
CUSTOMER_BILL_SPLIT	NUMBER	(7)		The percentage of the total project revenue and invoice that the customer is charged.
BILL_TO_ADDRESS_ID	NUMBER	(15)		Unique identifier for Bill To Address
SHIP_ADDRESS1	VARCHAR2	(240)		Ship Address1
SHIP_ADDRESS2	VARCHAR2	(240)		Ship Address2
SHIP_ADDRESS3	VARCHAR2	(240)		Ship Address3
SHIP_ADDRESS4	VARCHAR2	(240)		Ship Address4
SHIP_CITY	VARCHAR2	(60)		Ship City
SHIP_STATE	VARCHAR2	(60)		Ship State
SHIP_POSTAL_CODE	VARCHAR2	(60)		Ship Postal Code
SHIP_TO_ADDRESS_ID	NUMBER	(15)		Unique identifier for Ship To Address
BILL_ADDRESS1	VARCHAR2	(240)		Bill Address1
BILL_ADDRESS2	VARCHAR2	(240)		Bill Address2
BILL_ADDRESS3	VARCHAR2	(240)		Bill Address3
BILL_ADDRESS4	VARCHAR2	(240)		Bill Address4
BILL_CITY	VARCHAR2	(60)		Bill City
BILL_STATE	VARCHAR2	(60)		Bill State
BILL_POSTAL_CODE	VARCHAR2	(60)		Bill Postal Code
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.

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      _LA:PROJECT_CUST_RELATION
,      CUSTOMER_BILL_SPLIT
,      BILL_TO_ADDRESS_ID
,      SHIP_ADDRESS1
,      SHIP_ADDRESS2
,      SHIP_ADDRESS3
,      SHIP_ADDRESS4
,      SHIP_CITY
,      SHIP_STATE
,      SHIP_POSTAL_CODE
,      SHIP_TO_ADDRESS_ID
,      BILL_ADDRESS1
,      BILL_ADDRESS2
,      BILL_ADDRESS3
,      BILL_ADDRESS4
,      BILL_CITY
,      BILL_STATE
,      BILL_POSTAL_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.PAFV_CUSTOMERS;

Dependencies

[top of page]

APPS.PAFV_CUSTOMERS references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; PA_PROJECTS_ALL; PA_PROJECT_CUSTOMERS

APPS.PAFV_CUSTOMERS is not referenced by any database object