[Home] [Help]
View: AMW_AUDIT_UNITS_V
Product: | AMW - Internal Controls Manager |
Description: | This view returns information about Audit Units |
Implementation/DBA Data: |
APPS.AMW_AUDIT_UNITS_V
|
View Text
SELECT O.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, O.ORGANIZATION_ID ORGANIZATION_ID
, OTL.NAME NAME
, O.DATE_FROM DATE_FROM
, O.DATE_TO DATE_TO
, O3.ORG_INFORMATION2 LOB_CODE
, (SELECT FFVVL2.DESCRIPTION
FROM FND_FLEX_VALUES_VL FFVVL2
WHERE FFVVL2.FLEX_VALUE_SET_ID = O3.ORG_INFORMATION4
AND FFVVL2.FLEX_VALUE = O3.ORG_INFORMATION2) LOB_DESCRIPTION
, O3.ORG_INFORMATION1 COMPANY_CODE
, (SELECT FFVVL1.DESCRIPTION
FROM FND_FLEX_VALUES_VL FFVVL1
WHERE FFVVL1.FLEX_VALUE_SET_ID = O3.ORG_INFORMATION3
AND FFVVL1.FLEX_VALUE = O3.ORG_INFORMATION1) COMPANY
, O3.ORG_INFORMATION3 SUBSIDIARY_VALUESET
, O3.ORG_INFORMATION4 LOB_VALUESET
, O.LOCATION_ID LOCATION_ID
, HRLKP.MEANING ORG_TYPE
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
, HR_LOOKUPS HRLKP
WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID (+)
AND O2.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O3.ORG_INFORMATION_CONTEXT(+) = 'AMW_AUDIT_UNIT'
AND O2.ORG_INFORMATION1 = 'AMW_AUDIT_UNIT'
AND O2.ORG_INFORMATION2 = 'Y'
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')
AND HRLKP.LOOKUP_TYPE(+) = 'ORG_TYPE'
AND HRLKP.LOOKUP_CODE(+) = O.TYPE
Columns
Name |
BUSINESS_GROUP_ID |
ORGANIZATION_ID |
NAME |
DATE_FROM |
DATE_TO |
LOB_CODE |
LOB_DESCRIPTION |
COMPANY_CODE |
COMPANY |
SUBSIDIARY_VALUESET |
LOB_VALUESET |
LOCATION_ID |
ORG_TYPE |