APPS.AHL_OSP_RCV_PVT dependencies on PO_REQUISITION_LINES

Line 310: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,

306:
307: -- Cursor to get the PO line for the given Requisition line id. Only approved POs will be considered.
308: CURSOR get_po_line (c_po_req_line_id NUMBER) IS
309: SELECT PLL.po_line_id
310: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,
311: PO_HEADERS_ALL POH
312: WHERE REQ.requisition_line_id = c_po_req_line_id
313: AND PLL.line_location_id = REQ.line_location_id
314: AND PLL.po_header_id = POH.po_header_id

Line 1008: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,

1004:
1005: -- Cursor to get the PO line for the given Requisition line id. Only approved POs will be considered.
1006: CURSOR get_po_line (c_po_req_line_id NUMBER) IS
1007: SELECT PLL.po_line_id
1008: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,
1009: PO_HEADERS_ALL POH
1010: WHERE REQ.requisition_line_id = c_po_req_line_id
1011: AND PLL.line_location_id = REQ.line_location_id
1012: AND PLL.po_header_id = POH.po_header_id