View: AHL_APPROVAL_RULES_V

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_V

View Text

SELECT AARVL.ROW_ID
, AARVL.APPROVAL_RULE_ID
, AARVL.OBJECT_VERSION_NUMBER
, AARVL.APPROVAL_OBJECT_CODE
, APROBJ.MEANING "APPROVAL_OBJECT_NAME"
, AARVL.APPLICATION_USG_CODE
, APPUSG.MEANING "APPLICATION_USG"
, AARVL.APPROVAL_PRIORITY_CODE
, PRIOTYP.MEANING "APPROVAL_PRIORITY_NAME"
, AARVL.APPROVAL_TYPE_CODE
, APRTYP.MEANING "APPROVAL_TYPE_NAME"
, AARVL.OPERATING_UNIT_ID
, AARVL.OPERATING_NAME
, AARVL.STATUS_CODE
, STATYP.MEANING "STATUS_NAME"
, AARVL.ACTIVE_START_DATE
, AARVL.ACTIVE_END_DATE
, AARVL.APPROVAL_RULE_NAME
, AARVL.DESCRIPTION
FROM AHL_APPROVAL_RULES_VL AARVL
, FND_LOOKUP_VALUES_VL APROBJ
, FND_LOOKUP_VALUES_VL APPUSG
, FND_LOOKUP_VALUES_VL PRIOTYP
, FND_LOOKUP_VALUES_VL APRTYP
, FND_LOOKUP_VALUES_VL STATYP
WHERE APROBJ.LOOKUP_TYPE(+) = 'AHL_APPR_OBJECT_TYPE'AND APROBJ.LOOKUP_CODE(+) = AARVL.APPROVAL_OBJECT_CODE
AND PRIOTYP.LOOKUP_TYPE(+) = 'AHL_APPR_PRIORITY_TYPE'
AND PRIOTYP.LOOKUP_CODE (+)= AARVL.APPROVAL_PRIORITY_CODE
AND APRTYP.LOOKUP_TYPE(+) = 'AHL_APPROVAL_TYPE'
AND APRTYP.LOOKUP_CODE(+) = AARVL.APPROVAL_TYPE_CODE
AND STATYP.LOOKUP_TYPE(+) = 'AHL_APPR_STATUS_TYPE'
AND STATYP.LOOKUP_CODE(+) = AARVL.STATUS_CODE
AND APPUSG.LOOKUP_TYPE(+) = 'AHL_APPLICATION_USAGE_CODE'
AND APPUSG.LOOKUP_CODE(+) = AARVL.APPLICATION_USG_CODE

Columns