APPS.AHL_OSP_COST_PVT dependencies on AHL_OSP_ORDER_LINES

Line 43: FROM AHL_OSP_ORDER_LINES

39: CURSOR get_osp_line_dtls_csr IS
40: /** Changed by jaramana on January 11, 2008 for the Requisition ER 6034236
41: SELECT osp_order_line_id, osp_order_id, service_item_id, service_item_description,
42: service_item_uom_code, quantity, po_line_id, inventory_org_id
43: FROM AHL_OSP_ORDER_LINES
44: WHERE WORKORDER_ID = p_workorder_id
45: AND STATUS_CODE IS NULL; -- (Not PO_CANCELLED or PO_DELETED)
46: **/
47: SELECT ospl.osp_order_line_id, ospl.osp_order_id, ospl.service_item_id, ospl.service_item_description,

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 (+);