eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PARTS_REQUIREMENT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 3680: FROM csp_requirement_headers ch, HR_ALL_ORGANIZATION_UNITS h

3676: if l_non_src_line = 0 then
3677: l_dest_ou := -999;
3678: SELECT ch.destination_organization_id, h.name
3679: into l_dest_ou, l_dest_org_name
3680: FROM csp_requirement_headers ch, HR_ALL_ORGANIZATION_UNITS h
3681: WHERE ch.task_id = l_task_id
3682: AND ch.task_assignment_id = l_Task_Assignment_id
3683: AND ch.destination_organization_id = h.organization_id
3684: AND rownum = 1;

Line 3830: FROM csp_requirement_headers ch, HR_ALL_ORGANIZATION_UNITS h

3826: elsif x_return_status = 'C' then
3827: l_dest_ou := -999;
3828: SELECT ch.destination_organization_id, h.name
3829: into l_dest_ou, l_dest_org_name
3830: FROM csp_requirement_headers ch, HR_ALL_ORGANIZATION_UNITS h
3831: WHERE ch.task_id = l_task_id
3832: AND ch.task_assignment_id = l_Task_Assignment_id
3833: AND ch.destination_organization_id = h.organization_id
3834: AND rownum = 1;