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

POZ_ADDRESS_REQUESTS

ProcurementUsed in 1 subject areas19 reporting columns

Procurement Suppliers (POZ).

Primary key: not yet catalogued for POZ_ADDRESS_REQUESTS, reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
ADDRESS_LINE1Address line1.
ADDRESS_LINE2Address line2.
ADDRESS_LINE3Address line3.
ADDRESS_LINE4Address line4.
CITYCity.
COUNTYCounty.
EMAIL_ADDRESSEmail address.
FAX_AREA_CODECode identifying the fax area.
FAX_COUNTRY_CODECode identifying the fax country.
FAX_NUMBERFax number.
PARTY_SITE_NAMEName of the party site.
PAY_FLAGIndicator (Y/N) for the pay.
PHONE_AREA_CODECode identifying the phone area.
PHONE_COUNTRY_CODECode identifying the phone country.
PHONE_NUMBERPhone number.
POSTAL_CODECode identifying the postal.
PUR_FLAGIndicator (Y/N) for the pur.
RFQ_FLAGIndicator (Y/N) for the rfq.
STATEState.

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_ADDRESS_REQUESTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
Payables does not tie · Three-way match does not tie · The export ceiling