VIEW: APPS.FA_HR_BATCH_DIST_NEW_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)