APPS.AHL_OSP_COST_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 50: FROM AHL_OSP_ORDER_LINES ospl, PO_REQUISITION_LINES_ALL reql, PO_LINE_LOCATIONS_ALL locs

46: **/
47: SELECT ospl.osp_order_line_id, ospl.osp_order_id, ospl.service_item_id, ospl.service_item_description,
48: ospl.service_item_uom_code, ospl.quantity, ospl.po_line_id, ospl.inventory_org_id,
49: ospl.po_req_line_id, locs.po_line_id req_loc_po_line_id
50: FROM AHL_OSP_ORDER_LINES ospl, PO_REQUISITION_LINES_ALL reql, PO_LINE_LOCATIONS_ALL locs
51: WHERE ospl.WORKORDER_ID = p_workorder_id
52: AND ospl.STATUS_CODE IS NULL -- (Not PO_CANCELLED or PO_DELETED)
53: AND ospl.po_req_line_id = reql.requisition_line_id (+)
54: AND reql.LINE_LOCATION_ID = locs.LINE_LOCATION_ID (+);