機械翻訳について

ZCQ_SYNC_LOCATION_VIEW

詳細

  • スキーマ: FUSION

  • オブジェクト所有者: ZCQ

  • オブジェクト・タイプ: VIEW

列

名前

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

問合せ

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'