APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_OSP_ORDERS_B

Line 1582: FROM ahl_visits_b vst, ahl_visit_tasks_b vts, ahl_workorders wo,ahl_osp_orders_b osph, ahl_osp_order_lines ospl

1578:
1579: --Cursor to Get Visit Number and OSP number From Workorder.
1580: Cursor Get_Visit_And_OSP_From_Wip_Job(c_wip_entity_id IN NUMBER) IS
1581: SELECT vst.visit_number,osph.osp_order_number
1582: FROM ahl_visits_b vst, ahl_visit_tasks_b vts, ahl_workorders wo,ahl_osp_orders_b osph, ahl_osp_order_lines ospl
1583: WHERE
1584: wo.wip_entity_id = c_wip_entity_id
1585: and wo.visit_task_id IS NOT NULL
1586: and wo.visit_task_id = vts.visit_task_id

Line 1601: from CSI_ITEM_INSTANCES CII , ahl_osp_orders_b osph, ahl_osp_order_lines ospl

1597: CURSOR Get_OSP_Number(c_instance_id IN NUMBER) IS
1598: select OSP_ORDER_NUMBER from
1599: (
1600: select OSP_ORDER_NUMBER
1601: from CSI_ITEM_INSTANCES CII , ahl_osp_orders_b osph, ahl_osp_order_lines ospl
1602: WHERE CII.instance_id = c_instance_id
1603: and CII.inventory_item_id = ospl.inventory_item_id
1604: and CII.serial_number = ospl.serial_number
1605: and ospl.osp_order_id = osph.osp_order_id (+)

Line 1625: l_osp_order ahl_osp_orders_b.osp_order_number%TYPE;

1621: l_sub_inventory mtl_item_locations.subinventory_code%TYPE;
1622: l_locator_name VARCHAR2(204);
1623: -- end fix for bug 16304850
1624: l_job_name ahl_workorders.workorder_name%TYPE;
1625: l_osp_order ahl_osp_orders_b.osp_order_number%TYPE;
1626:
1627: BEGIN
1628:
1629: --Return NULL if visit or instance is null