APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_WORKORDERS

Line 2509: FROM ahl_workorders

2505: -- SELECT workorder_id, wip_entity_id FROM ahl_all_workorders_v
2506: -- WHERE visit_task_id = p_visit_task_id;
2507: -- Changed for changing the perf bug# 4919518
2508: SELECT workorder_id,wip_entity_id
2509: FROM ahl_workorders
2510: WHERE visit_task_id = p_visit_task_id
2511: AND STATUS_CODE <> '22';
2512:
2513: l_workorder_id NUMBER;

Line 2817: l_job_status_code AHL_WORKORDERS_V.JOB_STATUS_CODE%TYPE;

2813: l_release_visit_required VARCHAR2(1) :='N';
2814: l_module_name VARCHAR2(200):='ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_items_no_price';
2815:
2816: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_cost_price_rec;
2817: l_job_status_code AHL_WORKORDERS_V.JOB_STATUS_CODE%TYPE;
2818: l_job_status_meaning AHL_WORKORDERS_V.JOB_STATUS_MEANING%TYPE;
2819:
2820: l_cost_price_tbl1 Cost_Price_Tbl_Type;
2821: l_cost_price_tbl Cost_Price_Tbl_Type;

Line 2818: l_job_status_meaning AHL_WORKORDERS_V.JOB_STATUS_MEANING%TYPE;

2814: l_module_name VARCHAR2(200):='ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_items_no_price';
2815:
2816: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_cost_price_rec;
2817: l_job_status_code AHL_WORKORDERS_V.JOB_STATUS_CODE%TYPE;
2818: l_job_status_meaning AHL_WORKORDERS_V.JOB_STATUS_MEANING%TYPE;
2819:
2820: l_cost_price_tbl1 Cost_Price_Tbl_Type;
2821: l_cost_price_tbl Cost_Price_Tbl_Type;
2822:

Line 3393: FROM ahl_workorders wo

3389: workorder_name,
3390: wip_entity_id,
3391: visit_id,
3392: master_workorder_flag
3393: FROM ahl_workorders wo
3394: WHERE wo.visit_id = C_VISIT_ID
3395: AND wo.visit_task_id IS NULL
3396: AND wo.status_code NOT IN (22,7)
3397: AND wo.master_workorder_flag = 'Y';

Line 3405: FROM ahl_workorders wo

3401: -- Cursor to check child workorders has been created for visit tasks
3402: CURSOR c_check_wo_exists_cur (C_VISIT_TASK_ID IN NUMBER)
3403: IS
3404: SELECT 1
3405: FROM ahl_workorders wo
3406: WHERE wo.visit_task_id = C_VISIT_TASK_ID
3407: AND wo.status_code NOT IN (22,7);
3408:
3409: -- Local Variables