ZCQ_IMP_ORG_ADDRESS_VIEW
Details
-
Schema: FUSION
-
Object owner: ZCQ
-
Object type: VIEW
Columns
Name |
---|
ORGINTERFACEIDENTIFIER BATCHID ORGANIZATIONIDENTIFIER REGISTRYIDENTIFIER ORGANIZATIONNAME ORGANIZATIONTYPE DUNSNUMBER YEARINCORPORATED YEARESTABLISHED STOCKSYMBOL TAXREGISTRATIONNUMBER LOCATIONIDENTIFIER PARTYSITEID ADDRESSLINE1 ADDRESSLINE2 ADDRESSLINE3 ADDRESSLINE4 PHONETICADDRESSLINES CITY COUNTY COUNTRYSUBENTITY PROVINCE COUNTRY POSTALCODE POSTALCODEEXT ADDRESS PARTYIDENTIFIERID PERSONALIDENTIFICATION PHONECONTACTPOINTID PHONENUMBER PHONEEXTENSION PHONELINETYPE CUSTOMATTRIBUTE1 CUSTOMATTRIBUTE2 CUSTOMATTRIBUTE3 CUSTOMATTRIBUTE4 CUSTOMATTRIBUTE5 CUSTOMATTRIBUTE6 CUSTOMATTRIBUTE7 CUSTOMATTRIBUTE8 CUSTOMATTRIBUTE9 CUSTOMATTRIBUTE10 |
Query
SQL_Statement |
---|
select p.PARTY_T_ID OrgInterfaceIdentifier, p.BATCH_ID BatchID, p.PARTY_ID OrganizationIdentifier ,p.PARTY_NUMBER RegistryIdentifier, p.Organization_Name OrganizationName, p.ORGANIZATION_TYPE OrganizationType, p.DUNS_NUMBER_C DUNSNumber, p.INCORP_YEAR YearIncorporated, p.YEAR_ESTABLISHED YearEstablished, p.STOCK_SYMBOL StockSymbol, p.JGZZ_FISCAL_CODE TaxRegistrationNumber, loc.LOCATION_ID LocationIdentifier, ps.PARTY_SITE_ID PartySiteID, loc.ADDRESS1 AddressLine1, loc.ADDRESS2 AddressLine2, loc.ADDRESS3 AddressLine3,loc.ADDRESS4 AddressLine4, loc.ADDRESS_LINES_PHONETIC PhoneticAddressLines, loc.CITY City,loc.COUNTY County,loc.STATE CountrySubEntity,loc.PROVINCE Province,loc.COUNTRY Country,loc.POSTAL_CODE PostalCode, loc.POSTAL_PLUS4_CODE PostalCodeExt, (loc.Address1||' '||loc.Address2||' '||loc.Address3||' '||loc.Address4) Address, adi.PARTY_IDENTIFIER_ID PartyIdentifierID,adi.PARTY_IDENTIFIER_VALUE PersonalIdentification, ct.CONTACT_POINT_ID PhoneContactPointID, ct.RAW_PHONE_NUMBER PhoneNumber,ct.PHONE_EXTENSION PhoneExtension,ct.PHONE_LINE_TYPE PhoneLineType, p.ATTRIBUTE1 CustomAttribute1,p.ATTRIBUTE2 CustomAttribute2,p.ATTRIBUTE3 CustomAttribute3, p.ATTRIBUTE4 CustomAttribute4, p.ATTRIBUTE5 CustomAttribute5,p.ATTRIBUTE6 CustomAttribute6, p.ATTRIBUTE7 CustomAttribute7,p.ATTRIBUTE8 CustomAttribute8,p.ATTRIBUTE9 CustomAttribute9, p.ATTRIBUTE10 CustomAttribute10 from HZ_IMP_PARTIES_T p, HZ_IMP_PARTYSITES_T ps, HZ_IMP_LOCATIONS_T loc, HZ_IMP_CONTACTPTS_T ct, HZ_IMP_ADDTNLPARTYIDS_T adi where p.party_type = 'ORGANIZATION' and p.party_id = ps.party_id and p.batch_id = ps.batch_id and ps.location_id = loc.location_id and ps.batch_id = loc.batch_id and p.party_id = ct.party_ID(+) and p.batch_id = ct.batch_id(+) and ct.CONTACT_POINT_TYPE(+) = 'PHONE' and ct.OVERALL_PRIMARY_FLAG(+) = 'Y' and ct.party_site_id(+) is null and ct.relationship_id(+) is null and p.party_id = adi.party_id(+) and p.batch_id = adi.batch_id(+) |