VIEW: APPS.PA_PROJECT_CUSTOMERS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)