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	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.

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

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