APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_OSP_ORDER_LINES

Line 751: AHL_OSP_ORDER_LINES OSP, AHL_WARRANTY_ENTITLEMENTS ENT

747:
748: CURSOR get_osp_line_inst_csr (c_entl_id NUMBER) IS
749: SELECT VTK.instance_id
750: FROM AHL_VISIT_TASKS_B VTK, AHL_WORKORDERS WO,
751: AHL_OSP_ORDER_LINES OSP, AHL_WARRANTY_ENTITLEMENTS ENT
752: WHERE VTK.visit_task_id = WO.visit_task_id
753: AND WO.workorder_id = OSP.workorder_id
754: AND OSP.workorder_id IS NOT NULL
755: AND OSP.osp_order_line_id = ENT.osp_order_line_id

Line 759: FROM AHL_OSP_ORDER_LINES OSP, CSI_ITEM_INSTANCES CSI,

755: AND OSP.osp_order_line_id = ENT.osp_order_line_id
756: AND ENT.warranty_entitlement_id = c_entl_id
757: UNION ALL
758: SELECT CSI.instance_id
759: FROM AHL_OSP_ORDER_LINES OSP, CSI_ITEM_INSTANCES CSI,
760: AHL_WARRANTY_ENTITLEMENTS ENT
761: WHERE CSI.last_vld_organization_id = OSP.inventory_org_id
762: AND CSI.inventory_item_id = OSP.inventory_item_id
763: AND CSI.serial_number = OSP.serial_number

Line 835: FROM AHL_OSP_ORDERS_B OSPO, AHL_OSP_ORDER_LINES OSPL

831:
832: -- cursor to get the OSP order number for the given OSP line id
833: CURSOR get_osp_order_number_csr (c_osp_line_id NUMBER) IS
834: SELECT OSPO.osp_order_number
835: FROM AHL_OSP_ORDERS_B OSPO, AHL_OSP_ORDER_LINES OSPL
836: WHERE OSPO.osp_order_id = OSPL.osp_order_id
837: AND OSPL.osp_order_line_id = c_osp_line_id;
838:
839: --

Line 895: FROM AHL_OSP_ORDER_LINES

891:
892: -- cursor to get the OSP line number for the given OSP line id
893: CURSOR get_osp_line_number_csr (c_osp_line_id NUMBER) IS
894: SELECT osp_line_number
895: FROM AHL_OSP_ORDER_LINES
896: WHERE osp_order_line_id = c_osp_line_id;
897:
898: --
899: l_api_name CONSTANT VARCHAR2(30) := 'Get_OSP_Line_Number';

Line 954: FROM AHL_OSP_ORDER_LINES OSPL, FND_LOOKUP_VALUES_VL FOS

950:
951: -- cursor to get the OSP line status for the given OSP line id
952: CURSOR get_osp_line_status_csr (c_osp_line_id NUMBER) IS
953: SELECT FOS.meaning
954: FROM AHL_OSP_ORDER_LINES OSPL, FND_LOOKUP_VALUES_VL FOS
955: WHERE FOS.lookup_code = OSPL.status_code
956: AND FOS.lookup_type = 'AHL_OSP_LINE_STATUS_TYPE'
957: AND OSPL.osp_order_line_id = c_osp_line_id;
958:

Line 1771: FROM AHL_OSP_ORDER_LINES

1767: WHERE workorder_id = c_wo_id;
1768:
1769: CURSOR chk_osp_line_id_csr (c_line_id NUMBER) IS
1770: SELECT 'X'
1771: FROM AHL_OSP_ORDER_LINES
1772: WHERE osp_order_line_id = c_line_id;
1773:
1774: --
1775: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Warranty_Entitlement';