[Home] [Help]
View: FAFV_ASSET_ASSIGNS
View Text
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
Columns
Name |
DISTRIBUTION_ID |
UNITS_ASSIGNED |
TRANSACTION_UNITS |
BOOK_TYPE_CODE |
ASSET_ID |
CODE_COMBINATION_ID |
"_KF:EXPENSE_ACCOUNT" |
LOCATION_ID |
ASSIGNED_TO |
NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
EMPLOYEE_NUMBER |