View: PA_ALLOC_TARGET_LINES_V

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

View Text

SELECT PATL.ROWID
, PATL.RULE_ID
, PATL.LINE_NUM
, PATL.PROJECT_ORG_ID
, HRTL1.NAME
, PATL.TASK_ORG_ID
, HRTL2.NAME
, PATL.PROJECT_TYPE
, PATL.CLASS_CATEGORY
, PATL.CLASS_CODE
, PATL.SERVICE_TYPE
, PLU.MEANING
, PATL.PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME
, PATL.TASK_ID
, PAT.TASK_NUMBER
, PAT.TASK_NAME
, PATL.EXCLUDE_FLAG
, PATL.BILLABLE_ONLY_FLAG
, PATL.LINE_PERCENT
, PATL.CREATED_BY
, PATL.CREATION_DATE
, PATL.LAST_UPDATE_DATE
, PATL.LAST_UPDATED_BY
, PATL.LAST_UPDATE_LOGIN
FROM PA_ALLOC_TARGET_LINES PATL
, HR_ORG_UNITS_NO_JOIN HOU1
, HR_ALL_ORGANIZATION_UNITS_TL HRTL1
, HR_ORG_UNITS_NO_JOIN HOU2
, HR_ALL_ORGANIZATION_UNITS_TL HRTL2
, PA_PROJECTS_ALL PAP
, PA_TASKS PAT
, PA_LOOKUPS PLU
WHERE PATL.PROJECT_ORG_ID = HOU1.ORGANIZATION_ID (+)
AND HOU1.ORGANIZATION_ID = HRTL1.ORGANIZATION_ID(+)
AND DECODE(HRTL1.ORGANIZATION_ID
, NULL
, '1'
, HRTL1.LANGUAGE)= DECODE (HRTL1.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND PATL.TASK_ORG_ID = HOU2.ORGANIZATION_ID (+)
AND HOU2.ORGANIZATION_ID = HRTL2.ORGANIZATION_ID(+)
AND DECODE(HRTL2.ORGANIZATION_ID
, NULL
, '1'
, HRTL2.LANGUAGE)= DECODE (HRTL2.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND PATL.PROJECT_ID = PAP.PROJECT_ID (+)
AND PATL.TASK_ID = PAT.TASK_ID (+)
AND ( PATL.SERVICE_TYPE = PLU.LOOKUP_CODE (+)
AND PLU.LOOKUP_TYPE (+) = 'SERVICE TYPE')

Columns