Hi. I REALLY need help figuring out how to join some UDF's with my activities in P6. I have Activity codes joined with the activity ID's but I just can't figure out the UDF's. Below is my example - the first set is the joining of an activity code named Responsible Party. This works great. The next is the attempted joining of a UDF for BL Duration but it isn't working. Please help!
SELECT PROJECT.PROJ_ID AS PROJ_ID
,PROJECT.PROJ_SHORT_NAME AS PROJ_SHORT_NAME
,TASK.TASK_ID AS TASK_ID
,TASK.TASK_CODE AS TASK_CODE
,TASK.TASK_NAME AS TASK_NAME
,(SELECT TOP (1) ac.[actv_code_name]
FROM [PMDB].[dbo].[TASK] t
join [PMDB].[dbo].[TASKACTV] ta on t.task_id = ta.task_id
join [PMDB].[dbo].[ACTVCODE] ac on ta.actv_code_id = ac.actv_code_id
where t.task_id = TASK.TASK_ID and ac.actv_code_type_id = 21137) AS [Responsible Party]
,(SELECT TOP (1) ac.[actv_code_name]
FROM [PMDB].[dbo].[TASK] t
join [PMDB].[dbo].[TASKACTV] ta on t.task_id = ta.task_id
join [PMDB].[dbo].[ACTVCODE] ac on ta.actv_code_id = ac.actv_code_id
where t.task_id = TASK.TASK_ID and ac.udf_type_id = 6314) AS [BL Duration]
,(SELECT TOP (1) ac.[actv_code_name]
FROM [PMDB].[dbo].[TASK] t
join [PMDB].[dbo].[TASKACTV] ta on t.task_id = ta.task_id
join [PMDB].[dbo].[UDFCODE] ac on ta.udf_code_id = ac.udf_code_id
FROM DBO.PROJECT PROJECT
JOIN DBO.PROJWBS PROJWBS ON PROJECT.PROJ_ID = PROJWBS.PROJ_ID
JOIN DBO.PROJPCAT PROJPCAT ON PROJPCAT.PROJ_ID = PROJECT.PROJ_ID
JOIN DBO.PCATTYPE PCATTYPE ON PCATTYPE.PROJ_CATG_TYPE_ID = PROJPCAT.PROJ_CATG_TYPE_ID
JOIN DBO.PCATVAL PCATVAL ON PCATVAL.PROJ_CATG_ID = PROJPCAT.PROJ_CATG_ID
JOIN DBO.UDFTYPE UDFTYPE ON UDFTYPE.UDF_TYPE_ID = UDFTYPE.UDF_TYPE_ID
JOIN DBO.UDFVALUE UDFVALUE ON UDFVALUE.UDF_TYPE_ID = UDFTYPE.UDF_TYPE_ID
