VIEW: APPS.AHL_APPROVAL_RULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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