View: PAFV_ORGANIZATIONS

Product:	PA - Projects
Description:	This shows information about project organizations, project expenditure organizations, and event organizations.
Implementation/DBA Data:	APPS.PAFV_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
, '_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

Columns