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

Object Details

Object Name:	PA_PWP_CUSTOMER_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PWP_CUSTOMER_SUMMARY_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Project Id
CUSTOMER_NAME	VARCHAR2	(360)		Customer name
CUSTOMER_NUMBER	VARCHAR2	(30)		Customer number
LAST_INVOICE_NUMBER	NUMBER			Last invoice number of the customer in this project
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		Project functional currency code
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project currency code
PFC_BILL_AMOUNT	NUMBER			Project functional invoice amount
PFC_CP_BILL_AMOUNT	NUMBER
PFC_RECIEPT_AMOUNT	NUMBER			Receipt amount in project functional currency
PFC_CP_RECIEPT_AMOUNT	NUMBER			Current period receipt amount in project functional currency
PFC_OUTSTANDING_AMOUNT	NUMBER			Outstanding amount in project functional currency
PFC_ADJUSTMENT_AMOUNT	NUMBER			Adjustment amount in project functional currency
PC_BILL_AMOUNT	NUMBER			Invoice amount in project currency
PC_CP_BILL_AMOUNT	NUMBER			Current period invoice amount in project currency
PC_RECIEPT_AMOUNT	NUMBER			Reciept amount in project currency
PC_CP_RECIEPT_AMOUNT	NUMBER			Current period reciept amount in project currency
PC_OUTSTANDING_AMOUNT	NUMBER			Outstanding amount in project currency
PC_ADJUSTMENT_AMOUNT	NUMBER			Adjustment amount in project currency

Query Text

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


SELECT PROJECT_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      LAST_INVOICE_NUMBER
,      PROJFUNC_CURRENCY_CODE
,      PROJECT_CURRENCY_CODE
,      PFC_BILL_AMOUNT
,      PFC_CP_BILL_AMOUNT
,      PFC_RECIEPT_AMOUNT
,      PFC_CP_RECIEPT_AMOUNT
,      PFC_OUTSTANDING_AMOUNT
,      PFC_ADJUSTMENT_AMOUNT
,      PC_BILL_AMOUNT
,      PC_CP_BILL_AMOUNT
,      PC_RECIEPT_AMOUNT
,      PC_CP_RECIEPT_AMOUNT
,      PC_OUTSTANDING_AMOUNT
,      PC_ADJUSTMENT_AMOUNT
FROM APPS.PA_PWP_CUSTOMER_SUMMARY_V;

Dependencies

[top of page]

APPS.PA_PWP_CUSTOMER_SUMMARY_V references the following:

APPS: PA_PWP_CUSTOMER_SUMM

APPS.PA_PWP_CUSTOMER_SUMMARY_V is not referenced by any database object