POZ_SUPPLIER_REGISTRATIONS

ProcurementUsed in 2 subject areas24 reporting columns

Procurement Suppliers (POZ).

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

Columns

Column	In reports	Description (inferred)
APPROVED_DATE	●	Approved date.
BUSINESS_RELATIONSHIP_CODE	●	Code identifying the business relationship.
CORPORATE_WEBSITE	●	Corporate website.
DENIED_PARTY_FLAG	●	Indicator (Y/N) for the denied party.
DUNS_NUMBER	●	Duns number.
INCOME_TAX_ID_FLAG	●	Indicator (Y/N) for the income tax id.
JUSTIFICATION	●	Justification.
NOTE_TO_APPROVER	●	Note to approver.
ORGANIZATION_TYPE	●	Type of organization.
REGISTRATION_STATUS	●	Status of the registration.
REGISTRATION_TYPE	●	Type of registration.
REJECT_COMMENTS	●	Reject comments.
REJECT_REASON_CODE	●	Code identifying the reject reason.
REQUESTED_DATE	●	Requested date.
REQUESTER_EMAIL_ADDRESS	●	Requester email address.
REQUESTER_FIRST_NAME	●	Name of the requester first.
REQUESTER_LAST_NAME	●	Name of the requester last.
REQUEST_NUMBER	●	Request number.
REQUEST_REASON_CODE	●	Code identifying the request reason.
SUPPLIER_CREATION_STATUS	●	Status of the supplier creation.
SUPPLIER_NAME	●	Name of the supplier.
SUPPLIER_REG_ID	●	Identifier for the supplier reg.
TAX_REG_NUMBER_FLAG	●	Indicator (Y/N) for the tax reg number.
VENDOR_TYPE_LOOKUP_CODE	●	Lookup code for the vendor type.

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

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_REGISTRATIONS?

We ship parameterized SQL, BICC config, and dbt models you own.