View: FA_HR_BATCH_DIST_NEW_V

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

View Text

SELECT BD.BATCH_ID
, BD.ATTRIBUTE_NAME
, BD.ASSET_ID
, BD.ATTRIBUTE_OLD_ID
, BD.ATTRIBUTE_NEW_ID
, HD.DISTRIBUTION_ID
, HD.DIST_SET_ID
, BD.BOOK_TYPE_CODE
, HD.DISTRIBUTION_LINE_PERCENTAGE
, HD.CODE_COMBINATION_ID
, FA_CUA_ASSET_WB_APIS_PKG.GET_ACCOUNT_CODE_NAME(HD.CODE_COMBINATION_ID)
, HD.LOCATION_ID
, FA_CUA_ASSET_WB_APIS_PKG.GET_LOCATION_NAME(HD.LOCATION_ID)
, HD.ASSIGNED_TO
, FE.EMPLOYEE_NUMBER
, FE.NAME
FROM FA_MASS_UPDATE_BATCH_DETAILS BD
, FA_HIERARCHY_DISTRIBUTIONS HD
, FA_EMPLOYEES FE
WHERE TO_NUMBER(BD.ATTRIBUTE_NEW_ID) = HD.DIST_SET_ID
AND BD.BOOK_TYPE_CODE = HD.BOOK_TYPE_CODE
AND BD.ATTRIBUTE_NAME = 'DISTRIBUTION'
AND HD.ASSIGNED_TO = FE.EMPLOYEE_ID(+)

Columns