VIEW: APPS.PA_ALLOC_SOURCE_LINES_V

Source

View Text - Preformatted

SELECT pasl.rowid ,pasl.rule_id ,pasl.line_num ,pasl.project_org_id ,hrtl1.name ,pasl.task_org_id ,hrtl2.name ,pasl.project_type ,pasl.class_category ,pasl.class_code ,pasl.service_type ,plu.meaning ,pasl.project_id ,pap.segment1 ,pap.name ,pasl.task_id ,pat.task_number ,pat.task_name ,pasl.exclude_flag ,pasl.Created_by ,pasl.Creation_date ,pasl.Last_update_date ,pasl.Last_updated_by ,pasl.Last_update_login FROM pa_alloc_source_lines pasl ,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 pasl.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 pasl.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 pasl.project_id = pap.project_id (+) AND pasl.task_id = pat.task_id (+) AND (pasl.service_type = plu.lookup_code (+) AND plu.lookup_type (+) = 'SERVICE TYPE' )

View Text - HTML Formatted

SELECT PASL.ROWID
, PASL.RULE_ID
, PASL.LINE_NUM
, PASL.PROJECT_ORG_ID
, HRTL1.NAME
, PASL.TASK_ORG_ID
, HRTL2.NAME
, PASL.PROJECT_TYPE
, PASL.CLASS_CATEGORY
, PASL.CLASS_CODE
, PASL.SERVICE_TYPE
, PLU.MEANING
, PASL.PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME
, PASL.TASK_ID
, PAT.TASK_NUMBER
, PAT.TASK_NAME
, PASL.EXCLUDE_FLAG
, PASL.CREATED_BY
, PASL.CREATION_DATE
, PASL.LAST_UPDATE_DATE
, PASL.LAST_UPDATED_BY
, PASL.LAST_UPDATE_LOGIN
FROM PA_ALLOC_SOURCE_LINES PASL
, 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 PASL.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 PASL.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 PASL.PROJECT_ID = PAP.PROJECT_ID (+)
AND PASL.TASK_ID = PAT.TASK_ID (+)
AND (PASL.SERVICE_TYPE = PLU.LOOKUP_CODE (+)
AND PLU.LOOKUP_TYPE (+) = 'SERVICE TYPE' )