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 287: FROM PO_LINE_LOCATIONS_ALL PLL

283: SELECT AOL.po_line_id,
284: AOL.po_req_line_id,
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

Line 302: FROM PO_LINE_LOCATIONS_ALL PLL

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

Line 310: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,

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

Line 985: FROM PO_LINE_LOCATIONS_ALL PLL

981: SELECT AOL.po_line_id,
982: AOL.po_req_line_id,
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

Line 1000: FROM PO_LINE_LOCATIONS_ALL PLL

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

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

Line 1008: FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES REQ,

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

Line 1025: FROM PO_LINE_LOCATIONS_ALL

1021:
1022: -- Cursor to get the 'ship to org id' for a given PO line id.
1023: CURSOR get_ship_to_org_id (c_po_line_id NUMBER) IS
1024: SELECT ship_to_organization_id
1025: FROM PO_LINE_LOCATIONS_ALL
1026: WHERE po_line_id = c_po_line_id;
1027:
1028: -- Cursor to get the 'ship to location id' for a given PO line id.
1029: CURSOR get_ship_to_loc_id (c_po_line_id NUMBER) IS

Line 1031: FROM PO_LINE_LOCATIONS_ALL

1027:
1028: -- Cursor to get the 'ship to location id' for a given PO line id.
1029: CURSOR get_ship_to_loc_id (c_po_line_id NUMBER) IS
1030: SELECT ship_to_location_id
1031: FROM PO_LINE_LOCATIONS_ALL
1032: WHERE po_line_id = c_po_line_id;
1033:
1034: --
1035: l_api_version CONSTANT NUMBER := 1.0;

Line 1046: l_ship_to_org_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE;

1042: l_po_vendor_id AHL_OSP_ORDERS_B.vendor_id%TYPE;
1043: l_po_vendor_site_id AHL_OSP_ORDERS_B.vendor_site_id%TYPE;
1044: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;
1045: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;
1046: l_ship_to_org_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE;
1047: l_ship_to_loc_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE;
1048: l_po_line_qty NUMBER;
1049: l_po_line_tot_qty NUMBER;
1050: l_po_diff_qty NUMBER;

Line 1047: l_ship_to_loc_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE;

1043: l_po_vendor_site_id AHL_OSP_ORDERS_B.vendor_site_id%TYPE;
1044: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;
1045: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;
1046: l_ship_to_org_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE;
1047: l_ship_to_loc_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE;
1048: l_po_line_qty NUMBER;
1049: l_po_line_tot_qty NUMBER;
1050: l_po_diff_qty NUMBER;
1051: l_req_id NUMBER;