GMS_SPONSORS_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
SPONSOR_ID PARTY_ID PARTY_NAME LOC_NUMBER CUST_ACCT_ID VERSION_TYPE

Query

SQL_Statement
SELECT a.sponsor_id, hzp.party_id, hzp.party_name, nvl(a.loc_number, b.loc_number) as loc_number, nvl(a.related_sponsor_acct_id,a.sponsor_acct_id) as cust_acct_id, 'C' as version_type FROM gms_sponsors_vl a, gms_sponsors_vl b, hz_parties hzp WHERE a.party_id = hzp.party_id AND a.bill_to_sponsor = b.sponsor_id(+)