VIEW: APPS.AST_PARTY_LOCATIONS_V

Source

View Text - Preformatted

SELECT SITE.ROWID , SITE.PARTY_ID , PARTY.PARTY_NUMBER , PARTY.PARTY_NAME , PARTY.PARTY_TYPE , LOC.LOCATION_ID , SITE.PARTY_SITE_ID , USE.PARTY_SITE_USE_ID , SITE.STATUS, USE.SITE_USE_TYPE , LKUP.MEANING, LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.CITY , LOC.STATE , LOC.PROVINCE , LOC.POSTAL_CODE , LOC.COUNTY , LOC.COUNTRY , FND.TERRITORY_SHORT_NAME, SITE.IDENTIFYING_ADDRESS_FLAG , LOC.LAST_UPDATE_DATE , SITE.LAST_UPDATE_DATE , USE.LAST_UPDATE_DATE FROM HZ_PARTY_SITES SITE, HZ_LOCATIONS LOC, HZ_PARTY_SITE_USES USE, HZ_PARTIES PARTY, FND_TERRITORIES_VL FND, AR_LOOKUPS LKUP WHERE SITE.LOCATION_ID = LOC.LOCATION_ID AND PARTY.PARTY_ID = SITE.PARTY_ID AND SITE.PARTY_SITE_ID = USE.PARTY_SITE_ID(+) AND LOC.COUNTRY = FND.TERRITORY_CODE(+) AND USE.SITE_USE_TYPE = LKUP.LOOKUP_CODE(+) AND LKUP.LOOKUP_TYPE(+) = 'PARTY_SITE_USE_CODE'

View Text - HTML Formatted

SELECT SITE.ROWID
, SITE.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, PARTY.PARTY_TYPE
, LOC.LOCATION_ID
, SITE.PARTY_SITE_ID
, USE.PARTY_SITE_USE_ID
, SITE.STATUS
, USE.SITE_USE_TYPE
, LKUP.MEANING
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, LOC.COUNTY
, LOC.COUNTRY
, FND.TERRITORY_SHORT_NAME
, SITE.IDENTIFYING_ADDRESS_FLAG
, LOC.LAST_UPDATE_DATE
, SITE.LAST_UPDATE_DATE
, USE.LAST_UPDATE_DATE
FROM HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, HZ_PARTY_SITE_USES USE
, HZ_PARTIES PARTY
, FND_TERRITORIES_VL FND
, AR_LOOKUPS LKUP
WHERE SITE.LOCATION_ID = LOC.LOCATION_ID
AND PARTY.PARTY_ID = SITE.PARTY_ID
AND SITE.PARTY_SITE_ID = USE.PARTY_SITE_ID(+)
AND LOC.COUNTRY = FND.TERRITORY_CODE(+)
AND USE.SITE_USE_TYPE = LKUP.LOOKUP_CODE(+)
AND LKUP.LOOKUP_TYPE(+) = 'PARTY_SITE_USE_CODE'