View: FABV_ASSET_ASSIGNS

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FABV_ASSET_ASSIGNS

View Text

SELECT DISTRIBUTION_ID
, UNITS_ASSIGNED
, TRANSACTION_UNITS
, BOOK_TYPE_CODE
, ASSET_ID
, CODE_COMBINATION_ID
, LOCATION_ID
, ASSIGNED_TO
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM FA_DISTRIBUTION_HISTORY
WHERE TRANSACTION_HEADER_ID_OUT IS NULL
AND DATE_INEFFECTIVE IS NULL WITH READ ONLY

Columns