VIEW: APPS.PABV_PROJECT_TYPES

Source

View Text - Preformatted

SELECT ppta.project_type , hou.organization_id , t.name , ppta.description , '_LA:project_type_class_code:PA_LOOKUPS:PROJECT TYPE CLASS:MEANING' , '_LA:burden_cost_flag:FND_LOOKUPS:YES_NO:MEANING' , ppta.start_date_active , ppta.end_date_active , '_DF:PA:PA_PROJECT_TYPES_DESC_FLEX:ppta' , ppta.LAST_UPDATE_DATE , ppta.LAST_UPDATED_BY , ppta.CREATION_DATE , ppta.CREATED_BY FROM pa_project_types_all ppta ,HR_ALL_ORGANIZATION_UNITS hou ,HR_ALL_ORGANIZATION_UNITS_tl t WHERE PPTA.ORG_ID = hou.ORGANIZATION_ID(+) and PPTA.ORG_ID = t.organization_id(+) and t.language(+) = userenv('LANG') and '_SEC:ppta.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PPTA.PROJECT_TYPE
, HOU.ORGANIZATION_ID
, T.NAME
, PPTA.DESCRIPTION
, '_LA:PROJECT_TYPE_CLASS_CODE:PA_LOOKUPS:PROJECT TYPE CLASS:MEANING'
, '_LA:BURDEN_COST_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPTA.START_DATE_ACTIVE
, PPTA.END_DATE_ACTIVE
, '_DF:PA:PA_PROJECT_TYPES_DESC_FLEX:PPTA'
, PPTA.LAST_UPDATE_DATE
, PPTA.LAST_UPDATED_BY
, PPTA.CREATION_DATE
, PPTA.CREATED_BY
FROM PA_PROJECT_TYPES_ALL PPTA
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS_TL T
WHERE PPTA.ORG_ID = HOU.ORGANIZATION_ID(+)
AND PPTA.ORG_ID = T.ORGANIZATION_ID(+)
AND T.LANGUAGE(+) = USERENV('LANG')
AND '_SEC:PPTA.ORG_ID' IS NOT NULL WITH READ ONLY