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.AHL_VWP_MR_CST_PR_PVT dependencies on AHL_WORKORDERS

Line 96: From ahl_workorders a

92:
93: Cursor c_work_csr(c_visit_task_id in number)
94: Is
95: Select a.WORKORDER_ID,a.MASTER_WORKORDER_FLAG
96: From ahl_workorders a
97: where a.visit_task_id=c_visit_task_id
98: and a.status_code <>'22' and a.status_code <>'7'
99: and a.master_workorder_flag='Y';
100: l_work_rec c_work_csr%rowtype;

Line 1393: l_job_status_code ahl_workorders_v.job_status_code%type;

1389:
1390: l_cost_price_tbl AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
1391: l_cost_price_tbl1 AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
1392:
1393: l_job_status_code ahl_workorders_v.job_status_code%type;
1394: l_job_status_mean ahl_workorders_v.job_status_meaning%type;
1395:
1396: l_price number:=0;
1397: l_index NUMBER:=0;

Line 1394: l_job_status_mean ahl_workorders_v.job_status_meaning%type;

1390: l_cost_price_tbl AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
1391: l_cost_price_tbl1 AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
1392:
1393: l_job_status_code ahl_workorders_v.job_status_code%type;
1394: l_job_status_mean ahl_workorders_v.job_status_meaning%type;
1395:
1396: l_price number:=0;
1397: l_index NUMBER:=0;
1398: