VIEW: APPS.FAFV_ASSET_ASSIGNS

Source

View Text - Preformatted

SELECT DH.DISTRIBUTION_ID , DH.UNITS_ASSIGNED , DH.TRANSACTION_UNITS , DH.BOOK_TYPE_CODE , DH.ASSET_ID , DH.CODE_COMBINATION_ID , '_KF:SQLGL:GL#:GCC' , DH.LOCATION_ID , DH.ASSIGNED_TO , EM.NAME , DH.LAST_UPDATE_DATE , DH.LAST_UPDATED_BY , EM.EMPLOYEE_NUMBER FROM FA_DISTRIBUTION_HISTORY DH, FA_EMPLOYEES EM, GL_CODE_COMBINATIONS GCC WHERE DH.TRANSACTION_HEADER_ID_OUT IS NULL AND DH.DATE_INEFFECTIVE IS NULL AND DH.ASSIGNED_TO = EM.EMPLOYEE_ID(+) AND DH.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY

View Text - HTML Formatted

SELECT DH.DISTRIBUTION_ID
, DH.UNITS_ASSIGNED
, DH.TRANSACTION_UNITS
, DH.BOOK_TYPE_CODE
, DH.ASSET_ID
, DH.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, DH.LOCATION_ID
, DH.ASSIGNED_TO
, EM.NAME
, DH.LAST_UPDATE_DATE
, DH.LAST_UPDATED_BY
, EM.EMPLOYEE_NUMBER
FROM FA_DISTRIBUTION_HISTORY DH
, FA_EMPLOYEES EM
, GL_CODE_COMBINATIONS GCC
WHERE DH.TRANSACTION_HEADER_ID_OUT IS NULL
AND DH.DATE_INEFFECTIVE IS NULL
AND DH.ASSIGNED_TO = EM.EMPLOYEE_ID(+)
AND DH.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY