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.PAFV_ORGANIZATIONS

Source

View Text - Preformatted


SELECT /* unique attributes */ t2.name business_group_name ,t1.name organization_name /* regular attributes */ ,o.date_from date_from ,o.date_to date_to ,o.internal_address_line internal_address_line ,o.comments comments ,'_LA:o.internal_external_flag:FND_COMMON_LOOKUPS:INTL_EXTL:MEANING' internal_external_flag ,'_LA:o.type:FND_COMMON_LOOKUPS:ORG_TYPE:MEANING' type /* foreign key resolutions */ ,hrltl.location_code location_name ,paa.pa_org_use_type ,'_LA:decode(paa.pa_org_use_type,''PROJECTS'',''PA_PROJECT_ORG'',''PA_EXPENDITURE_ORG''):FND_COMMON_LOOKUPS:ORG_CLASS:MEANING' org_use_type ,paa.inactive_date /* descriptive flexfield */ ,'_DF:PER:PER_ORGANIZATION_UNITS:bgr' /* ids */ ,o.business_group_id business_group_id ,o.cost_allocation_keyflex_id cost_allocation_keyflex_id ,o.location_id location_id ,o.organization_id organization_id ,paa.org_id ,o.soft_coding_keyflex_id soft_coding_keyflex_id FROM hr_locations_all_tl hrltl , hr_all_organization_units o , hr_all_organization_units_tl t1 , hr_all_organization_units bgr , hr_all_organization_units_tl t2 , pa_all_organizations paa WHERE o.location_id = hrltl.location_id(+) AND decode(hrltl.location_id,NULL,'1', hrltl.LANGUAGE) = decode(hrltl.location_id,NULL,'1',userenv('LANG') ) AND o.BUSINESS_GROUP_ID = bgr.organization_id AND paa.organization_id = o.organization_id AND '_SEC:paa.org_id' IS NOT NULL AND o.organization_id = t1.organization_id AND t1.language = userenv('LANG') AND bgr.organization_id = t2.organization_id AND t2.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ T2.NAME BUSINESS_GROUP_NAME
, T1.NAME ORGANIZATION_NAME /* REGULAR ATTRIBUTES */
, O.DATE_FROM DATE_FROM
, O.DATE_TO DATE_TO
, O.INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS_LINE
, O.COMMENTS COMMENTS
, '_LA:O.INTERNAL_EXTERNAL_FLAG:FND_COMMON_LOOKUPS:INTL_EXTL:MEANING' INTERNAL_EXTERNAL_FLAG
, '_LA:O.TYPE:FND_COMMON_LOOKUPS:ORG_TYPE:MEANING' TYPE /* FOREIGN KEY RESOLUTIONS */
, HRLTL.LOCATION_CODE LOCATION_NAME
, PAA.PA_ORG_USE_TYPE
, '_LA:DECODE(PAA.PA_ORG_USE_TYPE
, ''PROJECTS''
, ''PA_PROJECT_ORG''
, ''PA_EXPENDITURE_ORG''):FND_COMMON_LOOKUPS:ORG_CLASS:MEANING' ORG_USE_TYPE
, PAA.INACTIVE_DATE /* DESCRIPTIVE FLEXFIELD */
, '_DF:PER:PER_ORGANIZATION_UNITS:BGR' /* IDS */
, O.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, O.COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, O.LOCATION_ID LOCATION_ID
, O.ORGANIZATION_ID ORGANIZATION_ID
, PAA.ORG_ID
, O.SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID
FROM HR_LOCATIONS_ALL_TL HRLTL
, HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL T1
, HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS_TL T2
, PA_ALL_ORGANIZATIONS PAA
WHERE O.LOCATION_ID = HRLTL.LOCATION_ID(+)
AND DECODE(HRLTL.LOCATION_ID
, NULL
, '1'
, HRLTL.LANGUAGE) = DECODE(HRLTL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG') )
AND O.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND PAA.ORGANIZATION_ID = O.ORGANIZATION_ID
AND '_SEC:PAA.ORG_ID' IS NOT NULL
AND O.ORGANIZATION_ID = T1.ORGANIZATION_ID
AND T1.LANGUAGE = USERENV('LANG')
AND BGR.ORGANIZATION_ID = T2.ORGANIZATION_ID
AND T2.LANGUAGE = USERENV('LANG') WITH READ ONLY