VIEW: APPS.PA_ALLOC_TARGET_LINES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')