DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_PROJECT_CUSTOMERS#

Object Details
Object Name: PA_PROJECT_CUSTOMERS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes
CUSTOMER_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
PROJECT_RELATIONSHIP_CODE VARCHAR2 (30) Yes
CUSTOMER_BILL_SPLIT NUMBER (7)
BILL_TO_ADDRESS_ID NUMBER (15)
SHIP_TO_ADDRESS_ID NUMBER (15)
INV_CURRENCY_CODE VARCHAR2 (15) Yes
INV_RATE_TYPE VARCHAR2 (30)
INV_RATE_DATE DATE

INV_EXCHANGE_RATE NUMBER

ALLOW_INV_USER_RATE_TYPE_FLAG VARCHAR2 (1)
BILL_ANOTHER_PROJECT_FLAG VARCHAR2 (1)
RECEIVER_TASK_ID NUMBER

RECORD_VERSION_NUMBER NUMBER (15)
PROJECT_PARTY_ID NUMBER (15)
RETENTION_LEVEL_CODE VARCHAR2 (30)
BILL_TO_CUSTOMER_ID NUMBER (15) Yes
SHIP_TO_CUSTOMER_ID NUMBER (15) Yes
DEFAULT_TOP_TASK_CUST_FLAG VARCHAR2 (1)
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# references the following:

SchemaPA
TablePA_PROJECT_CUSTOMERS
PA.PA_PROJECT_CUSTOMERS# is referenced by following:

SchemaAPPS
TriggerPA_PJI_PROJ_CUST_T1
TriggerPA_PJI_PROJ_CUST_T2
TriggerPA_PJI_PROJ_CUST_T3
SynonymPA_PROJECT_CUSTOMERS