VIEW: APPS.PA_R_EXPENDITURE_ORGS_V

Source

View Text - Preformatted

SELECT distinct hrorg.organization_id , hrorg.business_group_id , hrorg.name , hrorg.date_from , hrorg.date_to from hr_organization_units hrorg, pa_all_organizations paorg, hr_organization_information org_info WHERE paorg.organization_id = hrorg.organization_id and hrorg.organization_id = org_info.organization_id and org_info.org_information_context = 'Exp Organization Defaults' and paorg.pa_org_use_type = 'EXPENDITURES' and paorg.inactive_date is null and (paorg.organization_id,paorg.org_id) = ( select org1.organization_id, org1.org_id from pa_all_organizations org1 where org1.pa_org_use_type = 'EXPENDITURES' and org1.inactive_date is null and org1.organization_id = paorg.organization_id and rownum = 1 )

View Text - HTML Formatted

SELECT DISTINCT HRORG.ORGANIZATION_ID
, HRORG.BUSINESS_GROUP_ID
, HRORG.NAME
, HRORG.DATE_FROM
, HRORG.DATE_TO
FROM HR_ORGANIZATION_UNITS HRORG
, PA_ALL_ORGANIZATIONS PAORG
, HR_ORGANIZATION_INFORMATION ORG_INFO
WHERE PAORG.ORGANIZATION_ID = HRORG.ORGANIZATION_ID
AND HRORG.ORGANIZATION_ID = ORG_INFO.ORGANIZATION_ID
AND ORG_INFO.ORG_INFORMATION_CONTEXT = 'EXP ORGANIZATION DEFAULTS'
AND PAORG.PA_ORG_USE_TYPE = 'EXPENDITURES'
AND PAORG.INACTIVE_DATE IS NULL
AND (PAORG.ORGANIZATION_ID
, PAORG.ORG_ID) = ( SELECT ORG1.ORGANIZATION_ID
, ORG1.ORG_ID
FROM PA_ALL_ORGANIZATIONS ORG1
WHERE ORG1.PA_ORG_USE_TYPE = 'EXPENDITURES'
AND ORG1.INACTIVE_DATE IS NULL
AND ORG1.ORGANIZATION_ID = PAORG.ORGANIZATION_ID
AND ROWNUM = 1 )