View: PMI_HZ_PARTY_V

Product:	PMI - Process Manufacturing Intelligence
Description:	This view resolevs all HZ relation from cust size uses to parties and gets required data for sales details view
Implementation/DBA Data:	APPS.PMI_HZ_PARTY_V

View Text

SELECT PRTY.PARTY_ID
, PRTY.PARTY_NUMBER
, PRTY.PARTY_NAME
, PRTY.PARTY_TYPE
, PRTY.CITY
, PRTY.STATE
, PRTY.COUNTRY
, PS.LOCATION_ID
, SU.SITE_USE_ID
, PS.PARTY_SITE_NUMBER
, PS.PARTY_SITE_NAME
, LOC.CITY
, LOC.STATE
, LOC.COUNTRY
FROM HZ_PARTIES PRTY
, HZ_PARTY_SITES PS
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL CA
, HZ_CUST_SITE_USES_ALL SU
WHERE SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
AND PRTY.PARTY_ID = PS.PARTY_ID
AND PS.LOCATION_ID = LOC.LOCATION_ID

Columns