ZCQ_SYNC_LOCATION_VIEW

Details

• Schema: FUSION

• Object owner: ZCQ

• Object type: VIEW

Columns

Name

LOCATIONIDENTIFIER HOUSETYPE ADDRESS ADDRESSLINE1 ADDRESSLINE2 ADDRESSLINE3 ADDRESSLINE4 PHONETICADDRESSLINES CITY COUNTY COUNTRYSUBENTITY PROVINCE COUNTRY POSTALCODE POSTALCODEEXT POSITION ADDRESSEXPIRATIONDATE ADDRESSEFFECTIVEDATE LOCATIONLANGUAGE CUSTOMATTRIBUTE1 CUSTOMATTRIBUTE2 CUSTOMATTRIBUTE3 CUSTOMATTRIBUTE4 CUSTOMATTRIBUTE5 CUSTOMATTRIBUTE6 CUSTOMATTRIBUTE7 CUSTOMATTRIBUTE8 CUSTOMATTRIBUTE9 CUSTOMATTRIBUTE10 LAST_UPDATE_DATE STATUS IDT_NAME ENTITY_TYPE_CODE OPERATION

Query

SQL_Statement

select LOCATION_ID LocationIdentifier,HOUSE_TYPE HouseType, (Address1||' '||Address2||' '||Address3||' '||Address4) Address, ADDRESS1 AddressLine1,ADDRESS2 AddressLine2, ADDRESS3 AddressLine3,ADDRESS4 AddressLine4,ADDRESS_LINES_PHONETIC PhoneticAddressLines, CITY City,COUNTY County,STATE CountrySubEntity,PROVINCE Province,COUNTRY Country,POSTAL_CODE PostalCode, POSTAL_PLUS4_CODE PostalCodeExt,POSITION Position, ADDRESS_EXPIRATION_DATE AddressExpirationDate,ADDRESS_EFFECTIVE_DATE AddressEffectiveDate, LOCATION_LANGUAGE LocationLanguage, ATTRIBUTE1 CustomAttribute1,ATTRIBUTE2 CustomAttribute2,ATTRIBUTE3 CustomAttribute3, ATTRIBUTE4 CustomAttribute4, ATTRIBUTE5 CustomAttribute5, ATTRIBUTE6 CustomAttribute6, ATTRIBUTE7 CustomAttribute7, ATTRIBUTE8 CustomAttribute8, ATTRIBUTE9 CustomAttribute9, ATTRIBUTE10 CustomAttribute10, LAST_UPDATE_DATE, STATUS_FLAG STATUS, sync.idt_name, sync.entity_type_code, decode(nvl(status_flag,'A'),'A','ADD','DELETE') operation from zcq_sync_ids sync, hz_locations loc where sync.entity_id = loc.location_id and sync.entity_type_code = 'LOCATION'