APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_WORKORDERS

Line 243: l_search_criteria := l_search_criteria || and_str || ' EXISTS (SELECT OL.OSP_ORDER_LINE_ID FROM AHL_WORKORDERS_OSP_V WO, '

239: and_str := ' AND ';
240: LI_Field_Exist := TRUE;
241: END IF;
242: IF P_search_order_rec.Department IS NOT NULL THEN
243: l_search_criteria := l_search_criteria || and_str || ' EXISTS (SELECT OL.OSP_ORDER_LINE_ID FROM AHL_WORKORDERS_OSP_V WO, '
244: || ' AHL_OSP_ORDER_LINES OL WHERE '
245: || ' OL.OSP_ORDER_ID = OSP.OSP_ORDER_ID AND OL.WORKORDER_ID = WO.WORKORDER_ID ';
246: --|| ' AND UPPER(WO.DEPARTMENT_CODE) LIKE UPPER('''|| P_search_order_rec.Department || ''')) ';
247:

Line 536: l_sql_string:= l_sql_string || ' FROM AHL_WORKORDERS_OSP_V WO ';

532: l_sql_string:= l_sql_string || ', DEPARTMENT_CODE ';
533:
534:
535:
536: l_sql_string:= l_sql_string || ' FROM AHL_WORKORDERS_OSP_V WO ';
537:
538: -- l_search_criteria := '';
539: and_str := ' ';
540:

Line 1384: l_line_queries := l_line_queries || ' FROM AHL_WORKORDERS_OSP_V WO ';

1380: l_line_queries := l_line_queries ||', WO.PROJECT_NAME ';
1381: l_line_queries := l_line_queries ||', WO.PROJECT_TASK_ID ';
1382: l_line_queries := l_line_queries ||', WO.PROJECT_TASK_NAME ';
1383:
1384: l_line_queries := l_line_queries || ' FROM AHL_WORKORDERS_OSP_V WO ';
1385: l_line_queries := l_line_queries || ' WHERE ';
1386:
1387: l_line_queries := l_line_queries || ' (';
1388: i := 0;

Line 1504: FROM ahl_workorders_osp_v

1500: /*
1501: SELECT inventory_item_id,
1502: organization_id,
1503: service_item_id
1504: FROM ahl_workorders_osp_v
1505: WHERE workorder_id = p_work_order_id;
1506: */
1507: SELECT vts.inventory_item_id,
1508: vst.organization_id,

Line 1510: FROM ahl_workorders wo,

1506: */
1507: SELECT vts.inventory_item_id,
1508: vst.organization_id,
1509: arb.service_item_id
1510: FROM ahl_workorders wo,
1511: ahl_visits_b vst,
1512: ahl_visit_tasks_b vts,
1513: ahl_routes_b arb
1514: WHERE workorder_id = p_work_order_id

Line 1744: from PO_VENDORS_VIEW VEN, PO_ASL_STATUSES AST, PO_APPROVED_SUPPLIER_LIST ASL, AHL_WORKORDERS_OSP_V WO

1740: CURSOR l_approved_vendors_csr(l_workorder_id IN NUMBER,
1741: l_org_id IN NUMBER) IS
1742: /*
1743: SELECT VENDOR_NAME
1744: from PO_VENDORS_VIEW VEN, PO_ASL_STATUSES AST, PO_APPROVED_SUPPLIER_LIST ASL, AHL_WORKORDERS_OSP_V WO
1745: WHERE WO.WORKORDER_ID = l_workorder_id AND
1746: ASL.ITEM_ID = WO.SERVICE_ITEM_ID AND
1747: (ASL.USING_ORGANIZATION_ID = l_org_id OR
1748: (ASL.OWNING_ORGANIZATION_ID = l_org_id AND ASL.USING_ORGANIZATION_ID = -1)) AND

Line 1761: AHL_WORKORDERS WO,

1757: SELECT VENDOR_NAME
1758: from PO_VENDORS_VIEW VEN,
1759: PO_ASL_STATUSES AST,
1760: PO_APPROVED_SUPPLIER_LIST ASL,
1761: AHL_WORKORDERS WO,
1762: AHL_ROUTES_B arb
1763: WHERE WO.WORKORDER_ID = l_workorder_id
1764: AND arb.route_id = wo.route_id
1765: AND ASL.ITEM_ID = arb.SERVICE_ITEM_ID