VIEW: APPS.FA_QUICK_DISTRIBUTIONS_V

Source

View Text - Preformatted

SELECT DH.ROWID ROW_ID , DH.DISTRIBUTION_ID , DH.BOOK_TYPE_CODE , DH.ASSET_ID , DH.UNITS_ASSIGNED , DH.DATE_EFFECTIVE , DH.CODE_COMBINATION_ID , DH.LOCATION_ID , DH.TRANSACTION_HEADER_ID_IN , DH.LAST_UPDATE_DATE , DH.LAST_UPDATED_BY , DH.DATE_INEFFECTIVE , DH.ASSIGNED_TO , DH.TRANSACTION_HEADER_ID_OUT , DH.TRANSACTION_UNITS , DH.RETIREMENT_ID , DH.LAST_UPDATE_LOGIN , EMP.EMPLOYEE_NUMBER ASSIGNED_TO_NUMBER , EMP.FULL_NAME ASSIGNED_TO_NAME FROM FA_DISTRIBUTION_HISTORY DH, PER_PEOPLE_F EMP, PER_PERIODS_OF_SERVICE POS WHERE DH.ASSIGNED_TO = EMP.PERSON_ID(+) AND TRUNC(SYSDATE) > EMP.EFFECTIVE_START_DATE(+) AND TRUNC(SYSDATE) < EMP.EFFECTIVE_END_DATE(+) AND EMP.PERSON_ID = POS.PERSON_ID(+)

View Text - HTML Formatted

SELECT DH.ROWID ROW_ID
, DH.DISTRIBUTION_ID
, DH.BOOK_TYPE_CODE
, DH.ASSET_ID
, DH.UNITS_ASSIGNED
, DH.DATE_EFFECTIVE
, DH.CODE_COMBINATION_ID
, DH.LOCATION_ID
, DH.TRANSACTION_HEADER_ID_IN
, DH.LAST_UPDATE_DATE
, DH.LAST_UPDATED_BY
, DH.DATE_INEFFECTIVE
, DH.ASSIGNED_TO
, DH.TRANSACTION_HEADER_ID_OUT
, DH.TRANSACTION_UNITS
, DH.RETIREMENT_ID
, DH.LAST_UPDATE_LOGIN
, EMP.EMPLOYEE_NUMBER ASSIGNED_TO_NUMBER
, EMP.FULL_NAME ASSIGNED_TO_NAME
FROM FA_DISTRIBUTION_HISTORY DH
, PER_PEOPLE_F EMP
, PER_PERIODS_OF_SERVICE POS
WHERE DH.ASSIGNED_TO = EMP.PERSON_ID(+)
AND TRUNC(SYSDATE) > EMP.EFFECTIVE_START_DATE(+)
AND TRUNC(SYSDATE) < EMP.EFFECTIVE_END_DATE(+)
AND EMP.PERSON_ID = POS.PERSON_ID(+)