DBA Data[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on PO_LINES_ALL

Line 280: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL

276: POL.quantity,
277: (SELECT SUM(PLL.quantity_received)
278: FROM PO_LINE_LOCATIONS_ALL PLL
279: WHERE PLL.po_line_id = POL.po_line_id) quantity_received
280: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL
281: WHERE AOL.oe_return_line_id = c_oe_return_line_id
282: AND POL.po_line_id(+) = AOL.po_line_id
283: AND NVL(AOL.status_code, 'X') <> 'PO_DELETED'
284: AND NVL(AOL.status_code, 'X') <> 'PO_CANCELLED'

Line 295: FROM PO_LINES_ALL POL

291: SELECT POL.quantity,
292: (SELECT SUM(PLL.quantity_received)
293: FROM PO_LINE_LOCATIONS_ALL PLL
294: WHERE PLL.po_line_id = POL.po_line_id) quantity_received
295: FROM PO_LINES_ALL POL
296: WHERE POL.po_line_id = c_po_line_id;
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

Line 735: FROM PO_HEADERS_ALL POH, PO_LINES_ALL POL

731:
732: -- Cursor to get the PO details. This will be used only for those PO headers, which are derived from the Requisition.
733: CURSOR get_po_header_details2 (c_po_line_id NUMBER) IS
734: SELECT POH.vendor_id, POH.vendor_site_id
735: FROM PO_HEADERS_ALL POH, PO_LINES_ALL POL
736: WHERE POL.po_line_id = c_po_line_id
737: AND POH.po_header_id = POL.po_header_id
738: AND ROWNUM = 1;
739:

Line 757: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL

753: POL.quantity,
754: (SELECT SUM(PLL.quantity_received)
755: FROM PO_LINE_LOCATIONS_ALL PLL
756: WHERE PLL.po_line_id = POL.po_line_id) quantity_received
757: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL
758: WHERE AOL.oe_return_line_id = c_oe_return_line_id
759: AND POL.po_line_id(+) = AOL.po_line_id
760: AND NVL(AOL.status_code, 'X') <> 'PO_DELETED'
761: AND NVL(AOL.status_code, 'X') <> 'PO_CANCELLED'

Line 772: FROM PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL PLL

768: SELECT POL.quantity,
769: (SELECT SUM(PLL.quantity_received)
770: FROM PO_LINE_LOCATIONS_ALL PLL
771: WHERE PLL.po_line_id = POL.po_line_id) quantity_received
772: FROM PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL PLL
773: WHERE POL.po_line_id = c_po_line_id;
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