VIEW: PA.PA_PROJECT_CUSTOMERS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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