APPS.AHL_OSP_RCV_PVT dependencies on PO_HEADERS_ALL

Line 268: FROM PO_HEADERS_ALL

264:
265: -- Cursor to check whether the given Purchase order is approved or not.
266: CURSOR chk_po_header_approved (c_po_header_id NUMBER) IS
267: SELECT 'X'
268: FROM PO_HEADERS_ALL
269: WHERE NVL(approved_flag, 'N') = 'Y'
270: AND po_header_id = c_po_header_id;
271:
272: -- Cursor to check whether the given Requisition is approved or not.

Line 311: PO_HEADERS_ALL POH

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

Line 958: FROM PO_HEADERS_ALL

954:
955: -- Cursor to get the PO details.
956: CURSOR get_po_header_details1 (c_po_header_id NUMBER) IS
957: SELECT vendor_id, vendor_site_id
958: FROM PO_HEADERS_ALL
959: WHERE NVL(approved_flag, 'N') = 'Y'
960: AND po_header_id = c_po_header_id;
961:
962: -- Cursor to get the PO details. This will be used only for those PO headers, which are derived from the Requisition.

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

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