View: PABV_ORGANIZATIONS

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PABV_ORGANIZATIONS

View Text

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

Columns