[Home] [Help]
View: PMI_HZ_PARTY_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
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
Name |
PARTY_ID |
PARTY_NUMBER |
PARTY_NAME |
PARTY_TYPE |
PARTY_CITY |
PARTY_STATE |
PARTY_COUNTRY |
LOCATION_ID |
SITE_USE_ID |
PARTY_SITE_NUMBER |
PARTY_SITE_NAME |
PARTY_SITE_CITY |
PARTY_SITE_STATE |
PARTY_SITE_COUNTRY |