Oracle Fusion · Data dictionary
CST_OPEN_PO_AMOUNTS_OTBI_V
CostingUsed in 1 subject areas25 reporting columns
Cost Management (CST), denormalized view.
Primary key: not yet catalogued for CST_OPEN_PO_AMOUNTS_OTBI_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| APPROVED_DATE | ● | Approved date. | |
| APPROVED_FLAG | ● | Indicator (Y/N) for the approved. | |
| COMMENTS | ● | Comments. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DISTRIBUTION_NUM | ● | Distribution number. | |
| DOCUMENT_STATUS | ● | Status of the document. | |
| LINE_NUM | ● | Line number. | |
| OPEN_PO_AMOUNT_COST_CURR_UOM | ● | Open purchase order amount cost currency unit of measure. | |
| OPEN_PO_AMOUNT_PO_CURR | ● | Open purchase order amount purchase order currency. | |
| PO_CURRENCY_CODE | ● | Currency code for the purchase order. | |
| PO_FUNCTIONAL_CURRENCY | ● | Purchase order functional currency. | |
| PO_NUMBER | ● | Purchase order number. | |
| PO_UOM_CODE | ● | Code identifying the purchase order unit of measure. | |
| QUANTITY | ● | Quantity. | |
| QUANTITY_CANCELLED | ● | Quantity cancelled. | |
| QUANTITY_DELIVERED | ● | Quantity delivered. | |
| QUANTITY_OPEN_COST_UOM | ● | Quantity open cost unit of measure. | |
| QUANTITY_OPEN_PO_UOM | ● | Quantity open purchase order unit of measure. | |
| QUANTITY_ORDERED | ● | Quantity ordered. | |
| RATE | ● | Rate. | |
| RATE_DATE | ● | Rate date. | |
| RATE_TYPE | ● | Type of rate. | |
| TYPE_LOOKUP_CODE | ● | Lookup code for the type. | |
| UNIT_PRICE | ● | Unit price. | |
| VENDOR_ORDER_NUM | ● | Vendor order number. |
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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for CST_OPEN_PO_AMOUNTS_OTBI_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table