VIEW: APPS.AMW_LATEST_REV_ORG_V

Source

View Text - Preformatted

SELECT ap_tl.DISPLAY_NAME, ap_tl.DESCRIPTION, a.CONTROL_COUNT, a.RISK_COUNT, a.PROCESS_ORGANIZATION_ID, a.PROCESS_ID, a.STANDARD_PROCESS_FLAG, a.RISK_CATEGORY, a.APPROVAL_STATUS, a.CERTIFICATION_STATUS, a.LAST_AUDIT_STATUS, a.ORGANIZATION_ID, a.LAST_CERTIFICATION_DATE, a.LAST_AUDIT_DATE, a.NEXT_AUDIT_DATE, a.PROCESS_CATEGORY_CODE, a.SIGNIFICANT_PROCESS_FLAG, a.END_DATE, a.PROCESS_CODE, a.REVISION_NUMBER, a.PROCESS_ORG_REV_ID, a.START_DATE, a.APPROVAL_DATE, a.APPROVAL_END_DATE, a.DELETION_DATE, a.PROCESS_TYPE, a.CONTROL_ACTIVITY_TYPE, a.RL_PROCESS_REV_ID, a.STANDARD_VARIATION, a.PROCESS_CATEGORY from amw_process_organization a, amw_process_names_tl ap_tl WHERE a.end_date is null and ap_tl.process_rev_id = a.rl_process_rev_id and ap_tl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT AP_TL.DISPLAY_NAME
, AP_TL.DESCRIPTION
, A.CONTROL_COUNT
, A.RISK_COUNT
, A.PROCESS_ORGANIZATION_ID
, A.PROCESS_ID
, A.STANDARD_PROCESS_FLAG
, A.RISK_CATEGORY
, A.APPROVAL_STATUS
, A.CERTIFICATION_STATUS
, A.LAST_AUDIT_STATUS
, A.ORGANIZATION_ID
, A.LAST_CERTIFICATION_DATE
, A.LAST_AUDIT_DATE
, A.NEXT_AUDIT_DATE
, A.PROCESS_CATEGORY_CODE
, A.SIGNIFICANT_PROCESS_FLAG
, A.END_DATE
, A.PROCESS_CODE
, A.REVISION_NUMBER
, A.PROCESS_ORG_REV_ID
, A.START_DATE
, A.APPROVAL_DATE
, A.APPROVAL_END_DATE
, A.DELETION_DATE
, A.PROCESS_TYPE
, A.CONTROL_ACTIVITY_TYPE
, A.RL_PROCESS_REV_ID
, A.STANDARD_VARIATION
, A.PROCESS_CATEGORY
FROM AMW_PROCESS_ORGANIZATION A
, AMW_PROCESS_NAMES_TL AP_TL
WHERE A.END_DATE IS NULL
AND AP_TL.PROCESS_REV_ID = A.RL_PROCESS_REV_ID
AND AP_TL.LANGUAGE = USERENV('LANG')