Analytics Catalog/Data dictionary/POZ_SUPPLIER_ADDRESS_V
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

POZ_SUPPLIER_ADDRESS_V

ProcurementUsed in 13 subject areas95 reporting columns

Procurement Suppliers (POZ) — denormalized view.

Primary key: not yet catalogued for POZ_SUPPLIER_ADDRESS_V — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
ADDRESS1●Address1.
ADDRESS2●Address2.
ADDRESS3●Address3.
ADDRESS4●Address4.
ADDRESSEE●Addressee.
ADDRESS_LINES_PHONETIC●Address lines phonetic.
ADDRESS_PURPOSE_ORDERING●Address purpose ordering.
ADDRESS_PURPOSE_REMIT_TO●Address purpose remit to.
ADDRESS_PURPOSE_RFQ_OR_BIDDING●Address purpose rfq or bidding.
ADDR_ELEMENT_ATTRIBUTE1●Addr element attribute1.
ADDR_ELEMENT_ATTRIBUTE2●Addr element attribute2.
ADDR_ELEMENT_ATTRIBUTE3●Addr element attribute3.
ADDR_ELEMENT_ATTRIBUTE4●Addr element attribute4.
ADDR_ELEMENT_ATTRIBUTE5●Addr element attribute5.
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE21●Descriptive flexfield segment.
ATTRIBUTE22●Descriptive flexfield segment.
ATTRIBUTE23●Descriptive flexfield segment.
ATTRIBUTE24●Descriptive flexfield segment.
ATTRIBUTE25●Descriptive flexfield segment.
ATTRIBUTE26●Descriptive flexfield segment.
ATTRIBUTE27●Descriptive flexfield segment.
ATTRIBUTE28●Descriptive flexfield segment.
ATTRIBUTE29●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE30●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE11●Descriptive flexfield segment.
ATTRIBUTE_DATE12●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
BUILDING●Building.
CITY●City.
COUNTY●County.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
EMAIL_ADDRESS●Email address.
FAX_COUNTRY_CODE●Code identifying the fax country.
FAX_PHONE_AREA_CODE●Code identifying the fax phone area.
FAX_PHONE_NUMBER●Fax phone number.
FLOOR_NUMBER●Floor number.
GLOBAL_LOCATION_NUMBER●Global location number.
INACTIVE_DATE●Inactive date.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATE●Date and time the row was last updated (the incremental-extract key).
LOCATION_LANGUAGE●Location language.
PARTY_SITE_ID●Identifier for the party site.
PARTY_SITE_NAME●Name of the party site.
PHONE_AREA_CODE●Code identifying the phone area.
PHONE_COUNTRY_CODE●Code identifying the phone country.
PHONE_EXTENSION●Phone extension.
PHONE_NUMBER●Phone number.
POSTAL_CODE●Code identifying the postal.
POSTAL_PLUS4_CODE●Code identifying the postal plus4.
PROVINCE●Province.
STATE●State.
STATUS●Status.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for POZ_SUPPLIER_ADDRESS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us