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: PA.PA_PWP_CUSTOMER_SUMM_ALL#

Object Details

Object Name:	PA_PWP_CUSTOMER_SUMM_ALL#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORG_ID	NUMBER	(15)	Yes
PROJECT_ID	NUMBER	(15)	Yes
DRAFT_INVOICE_NUM	NUMBER	(15)	Yes
RA_INVOICE_NUMBER	VARCHAR2	(20)
DRAFT_INVOICE_NUM_CREDITED	NUMBER	(15)
CUSTOMER_ID	NUMBER	(15)
CUSTOMER_NAME	VARCHAR2	(360)
CUSTOMER_NUMBER	VARCHAR2	(30)
SYSTEM_REFERENCE	NUMBER	(15)
TRANSFER_STATUS_CODE	VARCHAR2	(1)	Yes
INVOICE_DATE	DATE
INVOICE_STATUS	VARCHAR2	(80)
INVOICE_CLASS	VARCHAR2	(80)
AGREEMENT_NUM	VARCHAR2	(50)
LAST_RA_INVOICE_NUMBER	NUMBER
BILL_THROUGH_DATE	DATE
PROJFUNC_INVTRANS_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_INVTRANS_RATE_DATE	DATE
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
INV_CURRENCY_CODE	VARCHAR2	(15)
PFC_BILL_AMOUNT	NUMBER
PFC_CP_BILL_AMOUNT	NUMBER
PFC_RECIEPT_AMOUNT	NUMBER
PFC_CP_RECIEPT_AMOUNT	NUMBER
PFC_OUTSTANDING_AMOUNT	NUMBER
PFC_ADJUSTMENT_AMOUNT	NUMBER
PFC_TAX_AMOUNT	NUMBER
PFC_LINE_AMOUNT	NUMBER
PC_BILL_AMOUNT	NUMBER
PC_CP_BILL_AMOUNT	NUMBER
PC_RECIEPT_AMOUNT	NUMBER
PC_CP_RECIEPT_AMOUNT	NUMBER
PC_OUTSTANDING_AMOUNT	NUMBER
PC_ADJUSTMENT_AMOUNT	NUMBER
PC_TAX_AMOUNT	NUMBER
PC_LINE_AMOUNT	NUMBER
INV_BILL_AMOUNT	NUMBER
INV_CP_BILL_AMOUNT	NUMBER
INV_RECIEPT_AMOUNT	NUMBER
INV_CP_RECIEPT_AMOUNT	NUMBER
INV_OUTSTANDING_AMOUNT	NUMBER
INV_ADJUSTMENT_AMOUNT	NUMBER
INV_TAX_AMOUNT	NUMBER
INV_LINE_AMOUNT	NUMBER
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
APPROVED_DATE	DATE
GL_DATE	DATE
RELEASED_DATE	DATE
BILL_TO_CUST_NUMBER	VARCHAR2	(30)
BILL_TO_CUST_NAME	VARCHAR2	(100)
SHIP_TO_CUST_NUMBER	VARCHAR2	(30)
SHIP_TO_CUST_NAME	VARCHAR2	(100)
BILL_TO_ADDRESS	VARCHAR2	(400)
SHIP_TO_ADDRESS	VARCHAR2	(400)

Query Text

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


SELECT ORG_ID
,      PROJECT_ID
,      DRAFT_INVOICE_NUM
,      RA_INVOICE_NUMBER
,      DRAFT_INVOICE_NUM_CREDITED
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      SYSTEM_REFERENCE
,      TRANSFER_STATUS_CODE
,      INVOICE_DATE
,      INVOICE_STATUS
,      INVOICE_CLASS
,      AGREEMENT_NUM
,      LAST_RA_INVOICE_NUMBER
,      BILL_THROUGH_DATE
,      PROJFUNC_INVTRANS_RATE_TYPE
,      PROJFUNC_INVTRANS_RATE_DATE
,      PROJFUNC_CURRENCY_CODE
,      PROJECT_CURRENCY_CODE
,      INV_CURRENCY_CODE
,      PFC_BILL_AMOUNT
,      PFC_CP_BILL_AMOUNT
,      PFC_RECIEPT_AMOUNT
,      PFC_CP_RECIEPT_AMOUNT
,      PFC_OUTSTANDING_AMOUNT
,      PFC_ADJUSTMENT_AMOUNT
,      PFC_TAX_AMOUNT
,      PFC_LINE_AMOUNT
,      PC_BILL_AMOUNT
,      PC_CP_BILL_AMOUNT
,      PC_RECIEPT_AMOUNT
,      PC_CP_RECIEPT_AMOUNT
,      PC_OUTSTANDING_AMOUNT
,      PC_ADJUSTMENT_AMOUNT
,      PC_TAX_AMOUNT
,      PC_LINE_AMOUNT
,      INV_BILL_AMOUNT
,      INV_CP_BILL_AMOUNT
,      INV_RECIEPT_AMOUNT
,      INV_CP_RECIEPT_AMOUNT
,      INV_OUTSTANDING_AMOUNT
,      INV_ADJUSTMENT_AMOUNT
,      INV_TAX_AMOUNT
,      INV_LINE_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      APPROVED_DATE
,      GL_DATE
,      RELEASED_DATE
,      BILL_TO_CUST_NUMBER
,      BILL_TO_CUST_NAME
,      SHIP_TO_CUST_NUMBER
,      SHIP_TO_CUST_NAME
,      BILL_TO_ADDRESS
,      SHIP_TO_ADDRESS
FROM PA.PA_PWP_CUSTOMER_SUMM_ALL#;

Dependencies

[top of page]

PA.PA_PWP_CUSTOMER_SUMM_ALL# references the following:

PA: PA_PWP_CUSTOMER_SUMM_ALL

PA.PA_PWP_CUSTOMER_SUMM_ALL# is referenced by following:

APPS: PA_PWP_CUSTOMER_SUMM; PA_PWP_CUSTOMER_SUMM_ALL