View: PA_PROJECT_CUSTOMERS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJECT_CUSTOMERS_V

View Text

SELECT PC1.ROWID
, PC1.PROJECT_ID
, PC1.CUSTOMER_ID
, CV1.CUSTOMER_NAME
, CV1.CUSTOMER_NUMBER
, CV1.STATUS
, PC1.LAST_UPDATE_DATE
, PC1.LAST_UPDATED_BY
, PC1.CREATION_DATE
, PC1.CREATED_BY
, PC1.LAST_UPDATE_LOGIN
, PC1.PROJECT_RELATIONSHIP_CODE
, CRV1.PROJECT_RELATIONSHIP_M
, PC1.CUSTOMER_BILL_SPLIT
, PC1.BILL_TO_ADDRESS_ID
, BA_LOC.ADDRESS1
, BA_LOC.ADDRESS2
, BA_LOC.ADDRESS3
, BA_LOC.ADDRESS4 || DECODE(BA_LOC.ADDRESS4
, NULL
, NULL
, '
, ')||BA_LOC.CITY|| '
, '||NVL(BA_LOC.STATE
, BA_LOC.PROVINCE)||' '||BA_LOC.POSTAL_CODE||'
, '||BA_LOC.COUNTY
, PC1.SHIP_TO_ADDRESS_ID
, SA_LOC.ADDRESS1
, SA_LOC.ADDRESS2
, SA_LOC.ADDRESS3
, SA_LOC.ADDRESS4 || DECODE(SA_LOC.ADDRESS4
, NULL
, NULL
, '
, ')||SA_LOC.CITY|| '
, '||NVL(SA_LOC.STATE
, SA_LOC.PROVINCE)||' '||SA_LOC.POSTAL_CODE||'
, '||SA_LOC.COUNTY
, PC1.INV_CURRENCY_CODE
, PC1.INV_RATE_TYPE
, PC1.INV_RATE_DATE
, PC1.INV_EXCHANGE_RATE
, PC1.ALLOW_INV_USER_RATE_TYPE_FLAG
, PC1.BILL_ANOTHER_PROJECT_FLAG
, PC1.RECEIVER_TASK_ID
, PPA.SEGMENT1
, PT.TASK_NUMBER
, PC1.RECORD_VERSION_NUMBER
, CV1.PARTY_ID
, CV1.PARTY_TYPE
, PC1.PROJECT_PARTY_ID
, PC1.BILL_TO_CUSTOMER_ID
, PC1.SHIP_TO_CUSTOMER_ID
, PC1.DEFAULT_TOP_TASK_CUST_FLAG
FROM PA_CUSTOMER_RELATIONSHIPS_V CRV1
, HZ_CUST_ACCT_SITES SA_ACCT_SITE
, HZ_PARTY_SITES SA_PARTY_SITE
, HZ_LOCATIONS SA_LOC
, HZ_LOCATIONS BA_LOC
, HZ_PARTY_SITES BA_PARTY_SITE
, HZ_CUST_ACCT_SITES BA_ACCT_SITE
, PA_CUSTOMERS_V CV1
, PA_PROJECT_CUSTOMERS PC1
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
WHERE PC1.CUSTOMER_ID = CV1.CUSTOMER_ID
AND PC1.BILL_TO_ADDRESS_ID = BA_ACCT_SITE.CUST_ACCT_SITE_ID(+)
AND BA_ACCT_SITE.PARTY_SITE_ID = BA_PARTY_SITE.PARTY_SITE_ID(+)
AND BA_PARTY_SITE.LOCATION_ID = BA_LOC.LOCATION_ID(+)
AND PC1.SHIP_TO_ADDRESS_ID = SA_ACCT_SITE.CUST_ACCT_SITE_ID(+)
AND SA_ACCT_SITE.PARTY_SITE_ID = SA_PARTY_SITE.PARTY_SITE_ID (+)
AND SA_PARTY_SITE.LOCATION_ID = SA_LOC.LOCATION_ID(+)
AND PC1.PROJECT_RELATIONSHIP_CODE = CRV1.PROJECT_RELATIONSHIP_CODE
AND PC1.PROJECT_ID = PPA.PROJECT_ID
AND PC1.RECEIVER_TASK_ID = PT.TASK_ID (+)

Columns