1. Tables and Views for Financials
  2. XLE_LEGALAUTH_V

XLE_LEGALAUTH_V

Details

  • Schema: FUSION

  • Object owner: XLE

  • Object type: VIEW

Columns

Name

LEGALAUTH_ID

AUTHORITY_NAME

ADDRESS_STYLE

ADDRESS1

ADDRESS2

ADDRESS3

ADDRESS4

CITY

STATE

POSTAL_CODE

COUNTRY

PARTY_ID

PARTY_SITE_ID

LEGISLATIVE_CATEGORY_CODE

Query

SQL_Statement

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_party_usg_assignments hpu,

hz_parties hp,

hz_party_sites hps,

hz_locations hl,

hz_code_assignments hca2

WHERE hpu.party_usage_code = 'LEGAL_AUTHORITY'

AND hpu.party_id = hp.party_id

AND hp.party_type = 'ORGANIZATION'

AND hp.party_id = hop.party_id

AND TRUNC(SYSDATE) BETWEEN hop.effective_start_date AND hop.effective_end_date

AND hp.party_id = hps.party_id

AND hps.status = 'A'

AND TRUNC(SYSDATE) BETWEEN hps.start_date_active AND hps.end_date_active

AND hps.location_id = hl.location_id

AND hca2.owner_table_id(+) = hp.party_id

AND hca2.class_category(+)= 'LEGISLATIVE_CATEGORY'