VIEW: APPS.AHL_APPROVAL_RULES_VL

Source

View Text - Preformatted

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, HOU.NAME OPERATING_NAME FROM AHL_APPROVAL_RULES_B AARB, AHL_APPROVAL_RULES_TL AART, HR_ALL_ORGANIZATION_UNITS_TL HOU WHERE AARB.APPROVAL_RULE_ID = AART.APPROVAL_RULE_ID AND AART.LANGUAGE = USERENV('LANG') AND HOU.LANGUAGE(+) = USERENV('LANG') AND HOU.ORGANIZATION_ID(+) = AARB.OPERATING_UNIT_ID

View Text - HTML Formatted

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
, HOU.NAME OPERATING_NAME
FROM AHL_APPROVAL_RULES_B AARB
, AHL_APPROVAL_RULES_TL AART
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE AARB.APPROVAL_RULE_ID = AART.APPROVAL_RULE_ID
AND AART.LANGUAGE = USERENV('LANG')
AND HOU.LANGUAGE(+) = USERENV('LANG')
AND HOU.ORGANIZATION_ID(+) = AARB.OPERATING_UNIT_ID