APPS.AHL_OSP_COST_PVT dependencies on PO_REQUISITION_LINES_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 (+);

Line 66: from PO_REQUISITION_LINES_ALL reql

62:
63: /** Added by jaramana on January 11, 2008 for the Requisition ER 6034236 **/
64: CURSOR get_req_line_price_csr(p_req_line_id IN NUMBER) IS
65: SELECT reql.unit_price*reql.quantity extended_price, reql.currency_code
66: from PO_REQUISITION_LINES_ALL reql
67: WHERE requisition_line_id = p_req_line_id;
68:
69: CURSOR currency_code_csr(p_org_id IN NUMBER) IS
70: select currency_code