View: FA_MASS_EXTERNAL_TRANSFERS_V

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

View Text

SELECT EXT.ROWID
, EXT.MASS_EXTERNAL_TRANSFER_ID
, EXT.BATCH_NAME
, EXT.TRANSACTION_STATUS
, EXT.FROM_ASSET_ID
, AD1.ASSET_NUMBER FROM_ASSET_NUMBER
, EXT.TO_ASSET_ID
, AD2.ASSET_NUMBER TO_ASSET_NUMBER
, EXT.TRANSACTION_TYPE
, EXT.EXTERNAL_REFERENCE_NUM
, EXT.BOOK_TYPE_CODE
, EXT.TRANSACTION_DATE_ENTERED
, EXT.FROM_DISTRIBUTION_ID
, EXT.TO_LOCATION_ID
, EXT.TO_GL_CCID
, EXT.TO_EMPLOYEE_ID
, PX2.FULL_NAME TO_EMPLOYEE_NAME
, PX2.EMPLOYEE_NUMBER TO_EMPLOYEE_NUMBER
, EXT.DESCRIPTION
, EXT.TRANSFER_UNITS
, EXT.TRANSFER_AMOUNT
, EXT.SOURCE_LINE_ID
, BK.COST
, AH.UNITS
, EXT.CREATED_BY
, EXT.CREATION_DATE
, EXT.LAST_UPDATED_BY
, EXT.LAST_UPDATE_DATE
, EXT.LAST_UPDATE_LOGIN
FROM FA_MASS_EXTERNAL_TRANSFERS EXT
, FA_ADDITIONS AD1
, FA_ADDITIONS AD2
, FA_BOOKS BK
, FA_ASSET_HISTORY AH
, FA_DISTRIBUTION_HISTORY DH
, PER_PEOPLE_X PX2
, PER_PERIODS_OF_SERVICE PS2
WHERE EXT.FROM_ASSET_ID = AD1.ASSET_ID
AND EXT.TO_ASSET_ID = AD2.ASSET_ID (+)
AND EXT.FROM_ASSET_ID = BK.ASSET_ID
AND EXT.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND BK.DATE_INEFFECTIVE IS NULL
AND EXT.FROM_ASSET_ID = AH.ASSET_ID
AND AH.DATE_INEFFECTIVE IS NULL
AND DH.DISTRIBUTION_ID (+) = EXT.FROM_DISTRIBUTION_ID
AND EXT.TO_EMPLOYEE_ID = PX2.PERSON_ID (+)
AND PX2.PERSON_ID = PS2.PERSON_ID (+)

Columns