Oracle Fusion · Data dictionary
POZ_BUSINESS_CLASSIFICATIONS_V
ProcurementUsed in 6 subject areas15 reporting columns
Procurement Suppliers (POZ), denormalized view.
Primary key: not yet catalogued for POZ_BUSINESS_CLASSIFICATIONS_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CERTIFICATE_NUMBER | ● | Certificate number. | |
| CERTIFYING_AGENCY | ● | Certifying agency. | |
| CLASSIFICATION_ID | ● | Identifier for the classification. | |
| CONFIRMED_ON | ● | Confirmed on. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DISPLAYED_FIELD | ● | Displayed field. | |
| EXPIRATION_DATE | ● | Expiration date. | |
| EXT_ATTR_1 | ● | Ext attribute 1. | |
| LOOKUP_CODE | ● | Code identifying the lookup. | |
| NOTES | ● | Notes. | |
| OTHER_CERTIFYING_AGENCY | ● | Other certifying agency. | |
| START_DATE | ● | Start date. | |
| STATUS | ● | Status. | |
| SUBCLASS | ● | Subclass. | |
| SUPPLIER_NAME | ● | Name of the supplier. |
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.
- Supplier - Supplier Real Time
- Supplier Import - Supplier Real Time
- Supplier Qualification - Qualifications and Assessments Real Time
- Supplier Qualification - Question Responses Real Time
- Supplier Qualification - Supplier Eligibility History Real Time
- Supplier Qualification - Supplier Eligibility Real Time
Need the extract + dbt staging for POZ_BUSINESS_CLASSIFICATIONS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table