eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_ALL_ORG_V

Source

View Text - Preformatted


SELECT DISTINCT org.ORGANIZATION_ID ORGANIZATION_ID, pa_expenditures_utils.GetOrgTlName(org.ORGANIZATION_ID) NAME, bg.name BUSINESS_GROUP_NAME FROM pa_all_organizations org, per_business_groups bg, hr_all_organization_units haou WHERE org.INACTIVE_DATE IS NULL AND org.PA_ORG_USE_TYPE in ('EXPENDITURES', 'PROJECTS') AND org.organization_id = haou.organization_id AND haou.business_group_id = bg.business_group_id AND ( ( PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND fnd_profile.value('PER_BUSINESS_GROUP_ID') = haou.BUSINESS_GROUP_ID) OR PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y')

View Text - HTML Formatted

SELECT DISTINCT ORG.ORGANIZATION_ID ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(ORG.ORGANIZATION_ID) NAME
, BG.NAME BUSINESS_GROUP_NAME
FROM PA_ALL_ORGANIZATIONS ORG
, PER_BUSINESS_GROUPS BG
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE ORG.INACTIVE_DATE IS NULL
AND ORG.PA_ORG_USE_TYPE IN ('EXPENDITURES'
, 'PROJECTS')
AND ORG.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND HAOU.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID
AND ( ( PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'N'
AND FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') = HAOU.BUSINESS_GROUP_ID) OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'Y')