APPS.AHL_OSP_RCV_PVT dependencies on PO_REQUISITION_LINES

Line 301: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,

297:
298: -- Cursor to get the PO line for the given Requisition line id. Only approved POs will be considered.
299: CURSOR get_po_line (c_po_req_line_id NUMBER) IS
300: SELECT PLL.po_line_id
301: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,
302: PO_HEADERS_ALL POH
303: WHERE REQ.requisition_line_id = c_po_req_line_id
304: AND PLL.line_location_id = REQ.line_location_id
305: AND PLL.po_header_id = POH.po_header_id

Line 778: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,

774:
775: -- Cursor to get the PO line for the given Requisition line id. Only approved POs will be considered.
776: CURSOR get_po_line (c_po_req_line_id NUMBER) IS
777: SELECT PLL.po_line_id
778: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,
779: PO_HEADERS_ALL POH
780: WHERE REQ.requisition_line_id = c_po_req_line_id
781: AND PLL.line_location_id = REQ.line_location_id
782: AND PLL.po_header_id = POH.po_header_id