View: AHL_APPROVAL_RULES_VL

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view stores the query relates to approval rules information
Implementation/DBA Data:	APPS.AHL_APPROVAL_RULES_VL

View Text

SELECT AARB.ROWID ROW_ID
, AARB.APPROVAL_RULE_ID
, AARB.OBJECT_VERSION_NUMBER
, AARB.APPROVAL_OBJECT_CODE
, AARB.APPROVAL_PRIORITY_CODE
, AARB.APPLICATION_USG_CODE
, AARB.APPROVAL_TYPE_CODE
, AARB.OPERATING_UNIT_ID
, AARB.STATUS_CODE
, AARB.SEEDED_FLAG
, AARB.ACTIVE_START_DATE
, AARB.ACTIVE_END_DATE
, AART.APPROVAL_RULE_NAME
, AART.DESCRIPTION
, AART.LANGUAGE
, AARB.LAST_UPDATE_DATE
, AARB.LAST_UPDATED_BY
, AARB.CREATION_DATE
, AARB.CREATED_BY
, AARB.LAST_UPDATE_LOGIN
, AARB.SECURITY_GROUP_ID
, AARB.ATTRIBUTE_CATEGORY
, AARB.ATTRIBUTE1
, AARB.ATTRIBUTE2
, AARB.ATTRIBUTE3
, AARB.ATTRIBUTE4
, AARB.ATTRIBUTE5
, AARB.ATTRIBUTE6
, AARB.ATTRIBUTE7
, AARB.ATTRIBUTE8
, AARB.ATTRIBUTE9
, AARB.ATTRIBUTE10
, AARB.ATTRIBUTE11
, AARB.ATTRIBUTE12
, AARB.ATTRIBUTE13
, AARB.ATTRIBUTE14
, AARB.ATTRIBUTE15
, DECODE(AARB.OPERATING_UNIT_ID
, NULL
, ''
, HOU.NAME) OPERATING_NAME
FROM AHL_APPROVAL_RULES_B AARB
, AHL_APPROVAL_RULES_TL AART
, HR_OPERATING_UNITS HOU
WHERE AARB.APPROVAL_RULE_ID = AART.APPROVAL_RULE_ID
AND AART.LANGUAGE = USERENV('LANG')
AND (AARB.OPERATING_UNIT_ID IS NULL OR AARB.OPERATING_UNIT_ID = HOU.ORGANIZATION_ID)

Columns