VIEW: APPS.PAFV_CUSTOMERS

Source

View Text - Preformatted

SELECT ppa.project_id , ppa.name,ppa.segment1 , ppc.customer_id , hz_p.party_name, '_LA:project_relationship_code:PA_LOOKUPS:CUSTOMER PROJECT RELATIONSHIP:MEANING' , ppc.customer_bill_split , ppc.bill_to_address_id , ra1.address1 , ra1.address2 , ra1.address3 , ra1.address4 , ra1.city , ra1.state , ra1.postal_code , ppc.ship_to_address_id , ra2.address1 , ra2.address2 , ra2.address3 , ra2.address4 , ra2.city , ra2.state , ra2.postal_code , ppc.LAST_UPDATE_DATE , ppc.LAST_UPDATED_BY , ppc.CREATION_DATE , ppc.CREATED_BY FROM pa_project_customers ppc , hz_cust_accounts hz_c, hz_parties hz_p, pa_projects_all ppa , hz_locations ra1, hz_cust_acct_sites_all hz_s, hz_party_sites hz_ps, hz_locations ra2, hz_cust_acct_sites_all hz_s2, hz_party_sites hz_ps2 WHERE ppc.project_id = ppa.project_id AND hz_c.cust_account_id = ppc.customer_id AND hz_c.party_id = hz_p.party_id and ppc.ship_to_address_id = hz_s.cust_acct_site_id (+) and hz_ps.party_site_id(+) = hz_s.party_site_id and ra1.location_id(+) = hz_ps.location_id and ppc.bill_to_address_id = hz_s2.cust_acct_site_id (+) and hz_ps2.party_site_id(+) = hz_s2.party_site_id and ra2.location_id(+) = hz_ps2.location_id and '_SEC:ppa.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPC.CUSTOMER_ID
, HZ_P.PARTY_NAME
, '_LA:PROJECT_RELATIONSHIP_CODE:PA_LOOKUPS:CUSTOMER PROJECT RELATIONSHIP:MEANING'
, PPC.CUSTOMER_BILL_SPLIT
, PPC.BILL_TO_ADDRESS_ID
, RA1.ADDRESS1
, RA1.ADDRESS2
, RA1.ADDRESS3
, RA1.ADDRESS4
, RA1.CITY
, RA1.STATE
, RA1.POSTAL_CODE
, PPC.SHIP_TO_ADDRESS_ID
, RA2.ADDRESS1
, RA2.ADDRESS2
, RA2.ADDRESS3
, RA2.ADDRESS4
, RA2.CITY
, RA2.STATE
, RA2.POSTAL_CODE
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.CREATION_DATE
, PPC.CREATED_BY
FROM PA_PROJECT_CUSTOMERS PPC
, HZ_CUST_ACCOUNTS HZ_C
, HZ_PARTIES HZ_P
, PA_PROJECTS_ALL PPA
, HZ_LOCATIONS RA1
, HZ_CUST_ACCT_SITES_ALL HZ_S
, HZ_PARTY_SITES HZ_PS
, HZ_LOCATIONS RA2
, HZ_CUST_ACCT_SITES_ALL HZ_S2
, HZ_PARTY_SITES HZ_PS2
WHERE PPC.PROJECT_ID = PPA.PROJECT_ID
AND HZ_C.CUST_ACCOUNT_ID = PPC.CUSTOMER_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_ID
AND PPC.SHIP_TO_ADDRESS_ID = HZ_S.CUST_ACCT_SITE_ID (+)
AND HZ_PS.PARTY_SITE_ID(+) = HZ_S.PARTY_SITE_ID
AND RA1.LOCATION_ID(+) = HZ_PS.LOCATION_ID
AND PPC.BILL_TO_ADDRESS_ID = HZ_S2.CUST_ACCT_SITE_ID (+)
AND HZ_PS2.PARTY_SITE_ID(+) = HZ_S2.PARTY_SITE_ID
AND RA2.LOCATION_ID(+) = HZ_PS2.LOCATION_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY