[Home] [Help] [Dependency Information]
Object Name: | PA_PROJECT_CUSTOMERS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
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) |
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#;
|
|
|