eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_RCV_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 278: FROM PO_LINE_LOCATIONS_ALL PLL

274: SELECT AOL.po_line_id,
275: AOL.po_req_line_id,
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

Line 293: FROM PO_LINE_LOCATIONS_ALL PLL

289: -- This will be used for those PO lines, which have been derived from Requisition lines.
290: CURSOR get_po_line_quantity2 (c_po_line_id NUMBER) IS
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:

Line 301: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,

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
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

Line 755: FROM PO_LINE_LOCATIONS_ALL PLL

751: SELECT AOL.po_line_id,
752: AOL.po_req_line_id,
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

Line 770: FROM PO_LINE_LOCATIONS_ALL PLL

766: -- This will be used for those PO lines, which have been derived from Requisition lines.
767: CURSOR get_po_line_quantity2 (c_po_line_id NUMBER) IS
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:

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

Line 778: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,

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
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

Line 795: FROM PO_LINE_LOCATIONS_ALL

791:
792: -- Cursor to get the 'ship to org id' for a given PO line id.
793: CURSOR get_ship_to_org_id (c_po_line_id NUMBER) IS
794: SELECT ship_to_organization_id
795: FROM PO_LINE_LOCATIONS_ALL
796: WHERE po_line_id = c_po_line_id;
797:
798: -- Cursor to get the 'ship to location id' for a given PO line id.
799: CURSOR get_ship_to_loc_id (c_po_line_id NUMBER) IS

Line 801: FROM PO_LINE_LOCATIONS_ALL

797:
798: -- Cursor to get the 'ship to location id' for a given PO line id.
799: CURSOR get_ship_to_loc_id (c_po_line_id NUMBER) IS
800: SELECT ship_to_location_id
801: FROM PO_LINE_LOCATIONS_ALL
802: WHERE po_line_id = c_po_line_id;
803:
804: --
805: l_api_version CONSTANT NUMBER := 1.0;

Line 816: l_ship_to_org_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE;

812: l_po_vendor_id AHL_OSP_ORDERS_B.vendor_id%TYPE;
813: l_po_vendor_site_id AHL_OSP_ORDERS_B.vendor_site_id%TYPE;
814: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;
815: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;
816: l_ship_to_org_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE;
817: l_ship_to_loc_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE;
818: l_po_line_qty NUMBER;
819: l_po_line_tot_qty NUMBER;
820: l_po_diff_qty NUMBER;

Line 817: l_ship_to_loc_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE;

813: l_po_vendor_site_id AHL_OSP_ORDERS_B.vendor_site_id%TYPE;
814: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;
815: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;
816: l_ship_to_org_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE;
817: l_ship_to_loc_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE;
818: l_po_line_qty NUMBER;
819: l_po_line_tot_qty NUMBER;
820: l_po_diff_qty NUMBER;
821: l_req_id NUMBER;