APPS.AHL_OSP_RCV_PVT dependencies on PO_LINES_ALL

Line 289: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL

285: POL.quantity,
286: (SELECT SUM(PLL.quantity_received)
287: FROM PO_LINE_LOCATIONS_ALL PLL
288: WHERE PLL.po_line_id = POL.po_line_id) quantity_received
289: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL
290: WHERE AOL.oe_return_line_id = c_oe_return_line_id
291: AND POL.po_line_id(+) = AOL.po_line_id
292: AND NVL(AOL.status_code, 'X') <> 'PO_DELETED'
293: AND NVL(AOL.status_code, 'X') <> 'PO_CANCELLED'

Line 304: FROM PO_LINES_ALL POL

300: SELECT POL.quantity,
301: (SELECT SUM(PLL.quantity_received)
302: FROM PO_LINE_LOCATIONS_ALL PLL
303: WHERE PLL.po_line_id = POL.po_line_id) quantity_received
304: FROM PO_LINES_ALL POL
305: WHERE POL.po_line_id = c_po_line_id;
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

Line 965: FROM PO_HEADERS_ALL POH, PO_LINES_ALL POL

961:
962: -- Cursor to get the PO details. This will be used only for those PO headers, which are derived from the Requisition.
963: CURSOR get_po_header_details2 (c_po_line_id NUMBER) IS
964: SELECT POH.vendor_id, POH.vendor_site_id
965: FROM PO_HEADERS_ALL POH, PO_LINES_ALL POL
966: WHERE POL.po_line_id = c_po_line_id
967: AND POH.po_header_id = POL.po_header_id
968: AND ROWNUM = 1;
969:

Line 987: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL

983: POL.quantity,
984: (SELECT SUM(PLL.quantity_received)
985: FROM PO_LINE_LOCATIONS_ALL PLL
986: WHERE PLL.po_line_id = POL.po_line_id) quantity_received
987: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL
988: WHERE AOL.oe_return_line_id = c_oe_return_line_id
989: AND POL.po_line_id(+) = AOL.po_line_id
990: AND NVL(AOL.status_code, 'X') <> 'PO_DELETED'
991: AND NVL(AOL.status_code, 'X') <> 'PO_CANCELLED'

Line 1002: FROM PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL PLL

998: SELECT POL.quantity,
999: (SELECT SUM(PLL.quantity_received)
1000: FROM PO_LINE_LOCATIONS_ALL PLL
1001: WHERE PLL.po_line_id = POL.po_line_id) quantity_received
1002: FROM PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL PLL
1003: WHERE POL.po_line_id = c_po_line_id;
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