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

POZ_SUPP_REQUESTS

ProcurementUsed in 1 subject areas18 reporting columns

Procurement Suppliers (POZ).

Likely primary key: SUPP_REQUEST_ID (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

ColumnKeyIn reportsDescription (inferred)
ACTION_BY_PERSON_IDIdentifier for the action by person.
ACTION_DATEAction date.
CHANGED_ADDRESSES_FLAGIndicator (Y/N) for the changed addresses.
CHANGED_BANK_ACCOUNTS_FLAGIndicator (Y/N) for the changed bank accounts.
CHANGED_BUS_CLASS_DETAILS_FLAGIndicator (Y/N) for the changed bus class details.
CHANGED_CONTACTS_FLAGIndicator (Y/N) for the changed contacts.
CHANGED_ORG_DETAILS_FLAGIndicator (Y/N) for the changed organization details.
CHANGED_PAYMENT_METHOD_FLAGIndicator (Y/N) for the changed payment method.
CHANGED_PROD_SERV_FLAGIndicator (Y/N) for the changed prod serv.
CHANGED_SITES_FLAGIndicator (Y/N) for the changed sites.
CHANGED_TAX_DETAILS_FLAGIndicator (Y/N) for the changed tax details.
CHANGED_USER_ACCOUNT_FLAGIndicator (Y/N) for the changed user account.
CHANGE_DESCRIPTIONDescription of the change.
CHANGE_REQ_NUMBERChange req number.
CHANGE_REQ_SUBMISSION_DATEChange req submission date.
REQUEST_SOURCE_CODECode identifying the request source.
REQUEST_STATUS_CODECode identifying the request status.
SUPP_REQUEST_IDPK?Identifier for the supplier request.

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_SUPP_REQUESTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us