What is the primary key of CST_OPEN_PO_AMOUNTS_OTBI_V?

not marked in the source dictionary

Where is CST_OPEN_PO_AMOUNTS_OTBI_V used in reporting?

It appears in 1 OTBI subject areas.

Oracle Fusion · Data dictionary

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.

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.

Problems that run through this table