View: FA_ASSET_HIERARCHY_PURPOSE_V

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

View Text

SELECT AHP.ROWID
, AHP.ASSET_HIERARCHY_PURPOSE_ID
, AHP.NAME
, AHP.PURPOSE_TYPE
, AHP.BOOK_TYPE_CODE
, AHP.DEFAULT_RULE_SET_ID
, RS.NAME
, AHP.CREATED_BY
, AHP.CREATION_DATE
, AHP.LAST_UPDATED_BY
, AHP.LAST_UPDATE_DATE
, AHP.LAST_UPDATE_LOGIN
, AHP.DESCRIPTION
, AHP.MANDATORY_ASSET_FLAG
, AHP.RULE_SET_LEVEL
, AHP.PERMISSIBLE_LEVELS
FROM FA_ASSET_HIERARCHY_PURPOSE AHP
, FA_HIERARCHY_RULE_SET RS
WHERE AHP.DEFAULT_RULE_SET_ID = RS.HIERARCHY_RULE_SET_ID(+)

Columns