View: FA_QUICK_DISTRIBUTIONS_V

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FA_QUICK_DISTRIBUTIONS_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
, EMP.EMPLOYEE_NUMBER ASSIGNED_TO_NUMBER
, EMP.FULL_NAME ASSIGNED_TO_NAME
FROM FA_DISTRIBUTION_HISTORY DH
, PER_PEOPLE_F EMP
, PER_PERIODS_OF_SERVICE POS
WHERE DH.ASSIGNED_TO = EMP.PERSON_ID(+)
AND TRUNC(SYSDATE) > EMP.EFFECTIVE_START_DATE(+)
AND TRUNC(SYSDATE) < EMP.EFFECTIVE_END_DATE(+)
AND EMP.PERSON_ID = POS.PERSON_ID(+)

Columns