APPS.AHL_OSP_RCV_PVT dependencies on PO_HEADERS_ALL

Line 259: FROM PO_HEADERS_ALL

255:
256: -- Cursor to check whether the given Purchase order is approved or not.
257: CURSOR chk_po_header_approved (c_po_header_id NUMBER) IS
258: SELECT 'X'
259: FROM PO_HEADERS_ALL
260: WHERE NVL(approved_flag, 'N') = 'Y'
261: AND po_header_id = c_po_header_id;
262:
263: -- Cursor to check whether the given Requisition is approved or not.

Line 302: PO_HEADERS_ALL POH

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
306: AND NVL(POH.approved_flag, 'N') = 'Y';

Line 728: FROM PO_HEADERS_ALL

724:
725: -- Cursor to get the PO details.
726: CURSOR get_po_header_details1 (c_po_header_id NUMBER) IS
727: SELECT vendor_id, vendor_site_id
728: FROM PO_HEADERS_ALL
729: WHERE NVL(approved_flag, 'N') = 'Y'
730: AND po_header_id = c_po_header_id;
731:
732: -- Cursor to get the PO details. This will be used only for those PO headers, which are derived from the Requisition.

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 779: PO_HEADERS_ALL POH

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
783: AND NVL(POH.approved_flag, 'N') = 'Y';