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]

TABLE: PA.PA_PROJECT_CUSTOMERS

Object Details

Object Name:	PA_PROJECT_CUSTOMERS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PROJECT_CUSTOMERS
Subobject Name:
Status:	VALID

PA_PROJECT_CUSTOMERS stores customers associated with
a project.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJECT_CUSTOMERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID CUSTOMER_ID
PA_PROJECT_CUSTOMERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIVER_TASK_ID
PA_PROJECT_CUSTOMERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
PA_PROJECT_CUSTOMERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_PARTY_ID
PA_PROJECT_CUSTOMERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_TO_CUSTOMER_ID BILL_TO_ADDRESS_ID
PA_PROJECT_CUSTOMERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_TO_CUSTOMER_ID SHIP_TO_ADDRESS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which the customer is entered
CUSTOMER_ID	NUMBER	(15)	Yes	The identifier of the customer that is involved with the project
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
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
PROJECT_RELATIONSHIP_CODE	VARCHAR2	(30)	Yes	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
BILL_TO_ADDRESS_ID	NUMBER	(15)		The identifier of the customer address to which invoices are sent
SHIP_TO_ADDRESS_ID	NUMBER	(15)		The identifier of the customer address that is the project customer's default work site for the project
INV_CURRENCY_CODE	VARCHAR2	(15)	Yes	Default invoice currency code for the draft invoices generated for this project customer.
INV_RATE_TYPE	VARCHAR2	(30)		Default invoice currency exchange rate type for the draft invoices generated for this project customer.
INV_RATE_DATE	DATE			Default invoice currency rate exchange date for the draft invoices generated for this project customer.
INV_EXCHANGE_RATE	NUMBER			Default invoice currency exchange rate for the draft invoices generated for this project customer.
ALLOW_INV_USER_RATE_TYPE_FLAG	VARCHAR2	(1)		Flag that indicates whether customer invoices could be recalculated in User Exchange Rate Type.
BILL_ANOTHER_PROJECT_FLAG	VARCHAR2	(1)		Flag that indicates that the project customer is internal.
RECEIVER_TASK_ID	NUMBER			Task identifier for the receiver task that is linked to the internal project customer.
RECORD_VERSION_NUMBER	NUMBER	(15)		Stores locking sequence number
PROJECT_PARTY_ID	NUMBER	(15)		System generated number that uniquely identifies the project party.
RETENTION_LEVEL_CODE	VARCHAR2	(30)		Indicates the level the of the retention setup.
BILL_TO_CUSTOMER_ID	NUMBER	(15)	Yes	The identifier of the customer id to which invoices are sent.
SHIP_TO_CUSTOMER_ID	NUMBER	(15)	Yes	The identifier of the customer id that is the project customer's default work site for the project.
DEFAULT_TOP_TASK_CUST_FLAG	VARCHAR2	(1)		Indicates whether the Customer is Default Top Task Customer.

Query Text

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


SELECT PROJECT_ID
,      CUSTOMER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROJECT_RELATIONSHIP_CODE
,      CUSTOMER_BILL_SPLIT
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      INV_CURRENCY_CODE
,      INV_RATE_TYPE
,      INV_RATE_DATE
,      INV_EXCHANGE_RATE
,      ALLOW_INV_USER_RATE_TYPE_FLAG
,      BILL_ANOTHER_PROJECT_FLAG
,      RECEIVER_TASK_ID
,      RECORD_VERSION_NUMBER
,      PROJECT_PARTY_ID
,      RETENTION_LEVEL_CODE
,      BILL_TO_CUSTOMER_ID
,      SHIP_TO_CUSTOMER_ID
,      DEFAULT_TOP_TASK_CUST_FLAG
FROM PA.PA_PROJECT_CUSTOMERS;

Dependencies

[top of page]

PA.PA_PROJECT_CUSTOMERS does not reference any database object

PA.PA_PROJECT_CUSTOMERS is referenced by following:

PA: PA_PROJECT_CUSTOMERS#