View: FA_DISTRIBUTION_HISTORY_V

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

View Text

SELECT DH.ROWID ROW_ID
, DH.DISTRIBUTION_ID
, DH.BOOK_TYPE_CODE
, DH.ASSET_ID
, DH.UNITS_ASSIGNED
, DH.DATE_EFFECTIVE
, DH.CODE_COMBINATION_ID
, DH.LOCATION_ID
, DH.TRANSACTION_HEADER_ID_IN
, DH.LAST_UPDATE_DATE
, DH.LAST_UPDATED_BY
, DH.DATE_INEFFECTIVE
, DH.ASSIGNED_TO
, DH.TRANSACTION_HEADER_ID_OUT
, DH.TRANSACTION_UNITS
, DH.RETIREMENT_ID
, DH.LAST_UPDATE_LOGIN
, P.EMPLOYEE_NUMBER ASSIGNED_TO_NUMBER
, P.FULL_NAME ASSIGNED_TO_NAME
FROM PER_PEOPLE_X P
, PER_PERIODS_OF_SERVICE S
, FA_DISTRIBUTION_HISTORY DH
WHERE DH.ASSIGNED_TO = P.PERSON_ID (+)
AND P.PERSON_ID = S.PERSON_ID (+)

Columns