VIEW: APPS.FA_MASS_EXTERNAL_TRANSFERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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