APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_WORKORDERS

Line 2428: FROM ahl_workorders

2424: -- SELECT workorder_id, wip_entity_id FROM ahl_all_workorders_v
2425: -- WHERE visit_task_id = p_visit_task_id;
2426: -- Changed for changing the perf bug# 4919518
2427: SELECT workorder_id,wip_entity_id
2428: FROM ahl_workorders
2429: WHERE visit_task_id = p_visit_task_id
2430: AND STATUS_CODE <> '22';
2431:
2432: l_workorder_id NUMBER;

Line 2736: l_job_status_code AHL_WORKORDERS_V.JOB_STATUS_CODE%TYPE;

2732: l_release_visit_required VARCHAR2(1) :='N';
2733: l_module_name VARCHAR2(200):='ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_items_no_price';
2734:
2735: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_cost_price_rec;
2736: l_job_status_code AHL_WORKORDERS_V.JOB_STATUS_CODE%TYPE;
2737: l_job_status_meaning AHL_WORKORDERS_V.JOB_STATUS_MEANING%TYPE;
2738:
2739: l_cost_price_tbl1 Cost_Price_Tbl_Type;
2740: l_cost_price_tbl Cost_Price_Tbl_Type;

Line 2737: l_job_status_meaning AHL_WORKORDERS_V.JOB_STATUS_MEANING%TYPE;

2733: l_module_name VARCHAR2(200):='ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_items_no_price';
2734:
2735: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_cost_price_rec;
2736: l_job_status_code AHL_WORKORDERS_V.JOB_STATUS_CODE%TYPE;
2737: l_job_status_meaning AHL_WORKORDERS_V.JOB_STATUS_MEANING%TYPE;
2738:
2739: l_cost_price_tbl1 Cost_Price_Tbl_Type;
2740: l_cost_price_tbl Cost_Price_Tbl_Type;
2741:

Line 3312: FROM ahl_workorders wo

3308: workorder_name,
3309: wip_entity_id,
3310: visit_id,
3311: master_workorder_flag
3312: FROM ahl_workorders wo
3313: WHERE wo.visit_id = C_VISIT_ID
3314: AND wo.visit_task_id IS NULL
3315: AND wo.status_code NOT IN (22,7)
3316: AND wo.master_workorder_flag = 'Y';

Line 3324: FROM ahl_workorders wo

3320: -- Cursor to check child workorders has been created for visit tasks
3321: CURSOR c_check_wo_exists_cur (C_VISIT_TASK_ID IN NUMBER)
3322: IS
3323: SELECT 1
3324: FROM ahl_workorders wo
3325: WHERE wo.visit_task_id = C_VISIT_TASK_ID
3326: AND wo.status_code NOT IN (22,7);
3327:
3328: -- Local Variables