View: XLE_LEGALAUTH_V

Product:	XLE - Legal Entity Configurator
Description:
Implementation/DBA Data:	APPS.XLE_LEGALAUTH_V

View Text

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'