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.IPA_ASSET_MECH_APIS_PKG dependencies on PA_TASKS

Line 69: pa_tasks pt,

65: FROM pa_projects_all ppr, -- Changed to _all as part of MOAC changes.
66: pa_project_types ppt,
67: -- pa_cost_distribution_lines_all pcdl,
68: pa_expenditure_items_all pei,
69: pa_tasks pt,
70: pa_tasks pt2
71: WHERE ppr.segment1 between x_project_num_from and x_project_num_to and
72: ppr.template_flag <> 'Y' and
73: ppr.project_status_code <> 'CLOSED' and

Line 70: pa_tasks pt2

66: pa_project_types ppt,
67: -- pa_cost_distribution_lines_all pcdl,
68: pa_expenditure_items_all pei,
69: pa_tasks pt,
70: pa_tasks pt2
71: WHERE ppr.segment1 between x_project_num_from and x_project_num_to and
72: ppr.template_flag <> 'Y' and
73: ppr.project_status_code <> 'CLOSED' and
74: ppr.project_type = ppt.project_type and

Line 549: from pa_tasks pt,

545: x_task_id in number) return boolean IS
546:
547: cursor check_auto_asset is
548: select 'X'
549: from pa_tasks pt,
550: pa_tasks pt2,
551: pa_project_types ppt,
552: pa_projects_all pp -- Changed to _ALL as part of MOAC changes
553: where pp.project_type = ppt.project_type

Line 550: pa_tasks pt2,

546:
547: cursor check_auto_asset is
548: select 'X'
549: from pa_tasks pt,
550: pa_tasks pt2,
551: pa_project_types ppt,
552: pa_projects_all pp -- Changed to _ALL as part of MOAC changes
553: where pp.project_type = ppt.project_type
554: and ppt.cip_grouping_method_code = 'CIPGCE'