View: FAFV_ASSET_ASSIGNS

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

View Text

SELECT DH.DISTRIBUTION_ID
, DH.UNITS_ASSIGNED
, DH.TRANSACTION_UNITS
, DH.BOOK_TYPE_CODE
, DH.ASSET_ID
, DH.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, DH.LOCATION_ID
, DH.ASSIGNED_TO
, EM.NAME
, DH.LAST_UPDATE_DATE
, DH.LAST_UPDATED_BY
, EM.EMPLOYEE_NUMBER
FROM FA_DISTRIBUTION_HISTORY DH
, FA_EMPLOYEES EM
, GL_CODE_COMBINATIONS GCC
WHERE DH.TRANSACTION_HEADER_ID_OUT IS NULL
AND DH.DATE_INEFFECTIVE IS NULL
AND DH.ASSIGNED_TO = EM.EMPLOYEE_ID(+)
AND DH.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY

Columns