VIEW: APPS.ORG_ACCESS_VIEW

Source

View Text - Preformatted

SELECT hou.organization_id, r.responsibility_id, r.application_id resp_application_id, mp.organization_code, hout.name organization_name, hou.business_group_id, gsob.set_of_books_id, gsob.chart_of_accounts_id, hoi1.org_information2 inventory_enabled_flag FROM hr_all_organization_units hou, hr_all_organization_units_tl hout, hr_organization_information hoi1, hr_organization_information hoi2, mtl_parameters mp, gl_sets_of_books gsob, fnd_responsibility r WHERE hou.organization_id = hoi1.organization_id AND hou.organization_id = hoi2.organization_id AND hou.organization_id = mp.organization_id AND hoi1.org_information1 = 'INV' AND hoi1.org_information2 = 'Y' AND (hoi1.org_information_context || '') = 'CLASS' AND (hoi2.org_information_context || '') = 'Accounting Information' AND TO_NUMBER(DECODE(trim(translate(hoi2.org_information1,'0123456789','          ')), NULL, hoi2.org_information1, '-99999')) = gsob.set_of_books_id AND NVL(hou.date_to, SYSDATE+1) >= Sysdate AND Decode(hr_security.view_all ,'Y' , 'TRUE', hr_security.show_record('HR_ALL_ORGANIZATION_UNITS',hout.organization_id))='TRUE' AND Decode(hr_general.get_xbg_profile,'Y', hou.business_group_id , hr_general.get_business_group_id) = hou.business_group_id AND hou.organization_id = hout.organization_id AND hout.LANGUAGE = USERENV('LANG') AND (EXISTS (SELECT NULL FROM org_access a1 WHERE a1.organization_id = hou.organization_id AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE AND a1.resp_application_id = r.application_id AND a1.responsibility_id = r.responsibility_id) OR NOT EXISTS (SELECT NULL FROM org_access a2 WHERE a2.organization_id = hou.organization_id AND NVL(a2.disable_date, SYSDATE+1) >=SYSDATE))

View Text - HTML Formatted

SELECT HOU.ORGANIZATION_ID
, R.RESPONSIBILITY_ID
, R.APPLICATION_ID RESP_APPLICATION_ID
, MP.ORGANIZATION_CODE
, HOUT.NAME ORGANIZATION_NAME
, HOU.BUSINESS_GROUP_ID
, GSOB.SET_OF_BOOKS_ID
, GSOB.CHART_OF_ACCOUNTS_ID
, HOI1.ORG_INFORMATION2 INVENTORY_ENABLED_FLAG
FROM HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, MTL_PARAMETERS MP
, GL_SETS_OF_BOOKS GSOB
, FND_RESPONSIBILITY R
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND (HOI2.ORG_INFORMATION_CONTEXT || '') = 'ACCOUNTING INFORMATION'
AND TO_NUMBER(DECODE(TRIM(TRANSLATE(HOI2.ORG_INFORMATION1
, '0123456789'
, ' '))
, NULL
, HOI2.ORG_INFORMATION1
, '-99999')) = GSOB.SET_OF_BOOKS_ID
AND NVL(HOU.DATE_TO
, SYSDATE+1) >= SYSDATE
AND DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HOUT.ORGANIZATION_ID))='TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, HOU.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = HOU.BUSINESS_GROUP_ID
AND HOU.ORGANIZATION_ID = HOUT.ORGANIZATION_ID
AND HOUT.LANGUAGE = USERENV('LANG')
AND (EXISTS (SELECT NULL
FROM ORG_ACCESS A1
WHERE A1.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND NVL(A1.DISABLE_DATE
, SYSDATE+1) >= SYSDATE
AND A1.RESP_APPLICATION_ID = R.APPLICATION_ID
AND A1.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID) OR NOT EXISTS (SELECT NULL
FROM ORG_ACCESS A2
WHERE A2.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND NVL(A2.DISABLE_DATE
, SYSDATE+1) >=SYSDATE))