Oracle Fusion · Data dictionary
PO_LINE_TYPES_B
ProcurementUsed in 11 subject areas3 reporting columns
Purchasing (PO), type / category reference.
Likely primary key: LINE_TYPE_CODE (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): LINE_TYPE_CODE → OKC_LINE_TYPES_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| INACTIVE_DATE | ● | Inactive date. | |
| LINE_TYPE_CODE | PK? | ● | Code identifying the line type. |
| PURCHASE_BASIS | ● | Purchase basis. |
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.
- Budgetary Control - Transactions Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Manufacturing - Purchased Item Usage Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Agreements Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Sourcing - Supplier Awards Real Time
- Sourcing - Supplier Negotiations Real Time
- Sourcing - Supplier Responses Real Time
Need the extract + dbt staging for PO_LINE_TYPES_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table