What is the primary key of CSE_ASSETS_HIST?

not marked in the source dictionary

Where is CSE_ASSETS_HIST used in reporting?

It appears in 2 OTBI subject areas.

Oracle Fusion · Data dictionary

SharedUsed in 2 subject areas26 reporting columns

history / audit log.

Primary key: not yet catalogued for CSE_ASSETS_HIST, reference Oracle Tables & Views guide.

Column	In reports	Description (inferred)
ACTIVE_END_DATE	●	Active end date.
ASSET_ID	●	Identifier for the asset.
ASSET_NUMBER	●	Asset number.
COMPETITOR_ASSET_FLAG	●	Indicator (Y/N) for the competitor asset.
CURRENT_LOCATION_CONTEXT	●	Current location context.
CURRENT_LOCATION_ID	●	Identifier for the current location.
CUSTOMER_ASSET_END_DATE	●	Customer asset end date.
CUSTOMER_ASSET_START_DATE	●	Customer asset start date.
CUSTOMER_ID	●	Identifier for the customer.
DFLT_WO_SUB_TYPE	●	Type of dflt wo sub.
DFLT_WO_TYPE	●	Type of dflt wo.
INVENTORY_LOCATOR_ID	●	Identifier for the inventory locator.
IOT_ENABLED_FLAG	●	Indicator (Y/N) for the iot enabled.
LOCATION_ORGANIZATION_ID	●	Identifier for the location organization.
LOT_NUMBER	●	Lot number.
MAINTAINABLE_FLAG	●	Indicator (Y/N) for the maintainable.
NEW_WO_ALLOWED_FLAG	●	Indicator (Y/N) for the new wo allowed.
QUANTITY	●	Quantity.
SALES_ORDER_NUMBER	●	Sales order number.
SECONDARY_QUANTITY	●	Secondary quantity.
SECONDARY_UOM_CODE	●	Code identifying the secondary unit of measure.
SERIAL_NUMBER	●	Serial number.
SHIPMENT_DATE	●	Shipment date.
SUBINVENTORY_CODE	●	Code identifying the subinventory.
TRANSACTED_ASSET_ID	●	Identifier for the transacted asset.
UOM_CODE	●	Code identifying the unit of measure.

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

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

Problems that run through this table