View: FA_DISTRIBUTION_HIST_WEB_V

Product:	OFA - Assets
Description:	Historical distribution information
Implementation/DBA Data:	APPS.FA_DISTRIBUTION_HIST_WEB_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
, P.EMPLOYEE_NUMBER
, P.FULL_NAME
, GLCC.CONCATENATED_SEGMENTS ACCT_CONC_SEGMENTS
, LOC.CONCATENATED_SEGMENTS LOC_CONC_SEGMENTS
, GLCC.CONCATENATED_SEGMENTS ACCOUNTING_CONCATENATED
, LOC.CONCATENATED_SEGMENTS LOCATION_CONCATENATED
FROM PER_PEOPLE_X P
, PER_PERIODS_OF_SERVICE S
, FA_SYSTEM_CONTROLS SC
, FA_LOCATIONS_KFV LOC
, FA_BOOK_CONTROLS BC
, GL_CODE_COMBINATIONS_KFV GLCC
, FA_DISTRIBUTION_HISTORY DH
WHERE DH.ASSIGNED_TO = P.PERSON_ID (+)
AND P.PERSON_ID = S.PERSON_ID (+)
AND GLCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID
AND GLCC.CHART_OF_ACCOUNTS_ID = BC.ACCOUNTING_FLEX_STRUCTURE
AND BC.BOOK_TYPE_CODE = DH.BOOK_TYPE_CODE
AND LOC.LOCATION_ID = DH.LOCATION_ID
AND DH.DATE_INEFFECTIVE IS NULL

Columns