[Home] [Help] [Dependency Information]
Object Name: | PA_PWP_CUSTOMER_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | Project Id |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer name | |
CUSTOMER_NUMBER | NUMBER | (15) | 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 |
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;
APPS.PA_PWP_CUSTOMER_SUMMARY_V is not referenced by any database object
|
|
|