VIEW: APPS.PABV_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 ,hr_general.decode_lookup('INTL_EXTL',o.internal_external_flag) internal_external_flag ,hr_general.decode_lookup('ORG_TYPE' ,o.type) type /* foreign key resolutions */ ,hrltl.location_code location_name ,paa.pa_org_use_type ,fcl.meaning ,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_IMPLEMENTATIONS_ALL PI , pa_all_organizations paa , fnd_common_lookups fcl 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 PI.PROJECT_ORGANIZATION_TYPE = o.TYPE and nvl(pi.org_id,-99) = nvl(paa.org_id,-99) and decode(paa.pa_org_use_type,'PROJECTS','PA_PROJECT_ORG','PA_EXPENDITURE_ORG') = fcl.lookup_code AND '_SEC:PI.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
, HR_GENERAL.DECODE_LOOKUP('INTL_EXTL'
, O.INTERNAL_EXTERNAL_FLAG) INTERNAL_EXTERNAL_FLAG
, HR_GENERAL.DECODE_LOOKUP('ORG_TYPE'
, O.TYPE) TYPE /* FOREIGN KEY RESOLUTIONS */
, HRLTL.LOCATION_CODE LOCATION_NAME
, PAA.PA_ORG_USE_TYPE
, FCL.MEANING
, 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_IMPLEMENTATIONS_ALL PI
, PA_ALL_ORGANIZATIONS PAA
, FND_COMMON_LOOKUPS FCL
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 PI.PROJECT_ORGANIZATION_TYPE = O.TYPE
AND NVL(PI.ORG_ID
, -99) = NVL(PAA.ORG_ID
, -99)
AND DECODE(PAA.PA_ORG_USE_TYPE
, 'PROJECTS'
, 'PA_PROJECT_ORG'
, 'PA_EXPENDITURE_ORG') = FCL.LOOKUP_CODE
AND '_SEC:PI.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