VIEW: APPS.XLE_LEGALAUTH_V

Source

View Text - Preformatted

SELECT hop.party_id LEGALAUTH_ID,
		hop.organization_name AUTHORITY_NAME,
		hl.address_style,
		hl.ADDRESS1,
		hl.ADDRESS2,
       hl.ADDRESS3,
       hl.ADDRESS4,
       hl.CITY,
	   hl.STATE,
       hl.POSTAL_CODE  	   POSTAL_CODE,
       hl.country COUNTRY,
       hp.party_id,
       hps.party_site_id,
       hca2.class_code LEGISLATIVE_CATEGORY_CODE
FROM   hz_organization_profiles hop,
       hz_code_assignments hca,
       hz_parties hp,
       hz_party_sites hps,
       hz_locations hl,
       hz_code_assignments hca2
WHERE  hca.owner_table_name = 'HZ_PARTIES'
AND    hca.class_category = 'BUSINESS_FUNCTION'
AND    hca.class_code = 'LEGAL_AUTHORITY'
AND    hca.owner_table_id = hp.party_id
AND    hp.party_type = 'ORGANIZATION'
AND    hp.party_id = hop.party_id
AND    hp.party_id = hps.party_id
AND    hps.status = 'A'
AND    hps.location_id = hl.location_id
AND    hca2.owner_table_id(+) = hp.party_id
AND    hca2.class_category(+)= 'LEGISLATIVE_CATEGORY'
   

View Text - HTML Formatted

SELECT HOP.PARTY_ID LEGALAUTH_ID
, HOP.ORGANIZATION_NAME AUTHORITY_NAME
, HL.ADDRESS_STYLE
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.CITY
, HL.STATE
, HL.POSTAL_CODE POSTAL_CODE
, HL.COUNTRY COUNTRY
, HP.PARTY_ID
, HPS.PARTY_SITE_ID
, HCA2.CLASS_CODE LEGISLATIVE_CATEGORY_CODE FROM HZ_ORGANIZATION_PROFILES HOP
, HZ_CODE_ASSIGNMENTS HCA
, HZ_PARTIES HP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, HZ_CODE_ASSIGNMENTS HCA2 WHERE HCA.OWNER_TABLE_NAME = 'HZ_PARTIES' AND HCA.CLASS_CATEGORY = 'BUSINESS_FUNCTION' AND HCA.CLASS_CODE = 'LEGAL_AUTHORITY' AND HCA.OWNER_TABLE_ID = HP.PARTY_ID AND HP.PARTY_TYPE = 'ORGANIZATION' AND HP.PARTY_ID = HOP.PARTY_ID AND HP.PARTY_ID = HPS.PARTY_ID AND HPS.STATUS = 'A' AND HPS.LOCATION_ID = HL.LOCATION_ID AND HCA2.OWNER_TABLE_ID(+) = HP.PARTY_ID AND HCA2.CLASS_CATEGORY(+)= 'LEGISLATIVE_CATEGORY'