View: FA_HIERARCHY_DISTRIBUTIONS_V

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

View Text

SELECT /*+ INDEX (FA_ASSET_HIERARCHY FA_ASSET_HIERARCHY_U1) */ DD.ROWID
, AH.ASSET_HIERARCHY_PURPOSE_ID
, HV.ASSET_HIERARCHY_ID
, DD.DISTRIBUTION_ID
, DD.DIST_SET_ID
, DD.BOOK_TYPE_CODE
, DD.DISTRIBUTION_LINE_PERCENTAGE
, DD.CODE_COMBINATION_ID
, DD.LOCATION_ID
, DD.ASSIGNED_TO
, FE.EMPLOYEE_NUMBER
, FE.NAME
, HV.CREATED_BY
, HV.CREATION_DATE
, HV.LAST_UPDATED_BY
, HV.LAST_UPDATE_DATE
, HV.LAST_UPDATE_LOGIN
FROM FA_ASSET_HIERARCHY_VALUES HV
, FA_ASSET_HIERARCHY AH
, FA_EMPLOYEES FE
, FA_HIERARCHY_DISTRIBUTIONS DD
WHERE AH.ASSET_HIERARCHY_ID = HV.ASSET_HIERARCHY_ID
AND AH.ASSET_ID IS NULL
AND FA_CUA_HIERARCHY_PKG.GET_GLOBAL_LEVEL_NUMBER <> 0
AND HV.DIST_SET_ID = DD.DIST_SET_ID(+)
AND DD.ASSIGNED_TO = FE.EMPLOYEE_ID(+) UNION ALL SELECT /*+ INDEX (FA_ASSET_HIERARCHY FA_ASSET_HIERARCHY_U1) */ AH.ROWID
, AH.ASSET_HIERARCHY_PURPOSE_ID
, AH.ASSET_HIERARCHY_ID
, FDH.DISTRIBUTION_ID
, -1
, AHP.BOOK_TYPE_CODE
, FDH.UNITS_ASSIGNED
, FDH.CODE_COMBINATION_ID
, FDH.LOCATION_ID
, FDH.ASSIGNED_TO
, FE.EMPLOYEE_NUMBER
, FE.NAME
, AH.CREATED_BY
, AH.CREATION_DATE
, AH.LAST_UPDATED_BY
, AH.LAST_UPDATE_DATE
, AH.LAST_UPDATE_LOGIN
FROM FA_ASSET_HIERARCHY AH
, FA_DISTRIBUTION_HISTORY FDH
, FA_EMPLOYEES FE
, FA_ASSET_HIERARCHY_PURPOSE AHP
WHERE AH.ASSET_ID IS NOT NULL
AND FA_CUA_HIERARCHY_PKG.GET_GLOBAL_LEVEL_NUMBER = 0
AND AH.ASSET_ID = FDH.ASSET_ID
AND FDH.DATE_INEFFECTIVE IS NULL
AND AH.ASSET_HIERARCHY_PURPOSE_ID = AHP.ASSET_HIERARCHY_PURPOSE_ID
AND AHP.BOOK_TYPE_CODE = FDH.BOOK_TYPE_CODE
AND FDH.ASSIGNED_TO = FE.EMPLOYEE_ID(+)

Columns