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 AHL_OSP_ORDER_LINES

Line 7: G_CSI_T_SOURCE_LINE_REF CONSTANT VARCHAR2(50) := 'AHL_OSP_ORDER_LINES';

3:
4: -- Global variable containing package name for debugs messages
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_OSP_RCV_PVT';
6: G_TRANSACTION_TABLE CONSTANT VARCHAR2(30) := 'OE_ORDER_LINES_ALL';
7: G_CSI_T_SOURCE_LINE_REF CONSTANT VARCHAR2(50) := 'AHL_OSP_ORDER_LINES';
8: -- Ship-only transaction type
9: G_OM_ORDER CONSTANT VARCHAR2(30) := 'OM_SHIPMENT';
10: -- Return transaction type
11: G_OM_RETURN CONSTANT VARCHAR2(30) := 'RMA_RECEIPT';

Line 250: FROM AHL_OSP_ORDER_LINES AOL, AHL_OSP_ORDERS_B AOB

246: CURSOR get_po_header_id (c_oe_return_line_id NUMBER) IS
247: SELECT AOB.po_header_id,
248: AOB.po_req_header_id,
249: AOL.osp_order_id
250: FROM AHL_OSP_ORDER_LINES AOL, AHL_OSP_ORDERS_B AOB
251: WHERE AOL.oe_return_line_id = c_oe_return_line_id
252: AND AOL.osp_order_id = AOB.osp_order_id
253: AND AOB.status_code IN ('PO_CREATED', 'REQ_CREATED')
254: AND ROWNUM = 1;

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 315: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;

311:
312: l_osp_order_id AHL_OSP_ORDERS_B.osp_order_id%TYPE;
313: l_po_header_id AHL_OSP_ORDERS_B.po_header_id%TYPE;
314: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_id%TYPE;
315: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;
316: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;
317: l_oe_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
318: l_oe_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
319: l_po_line_qty NUMBER;

Line 316: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;

312: l_osp_order_id AHL_OSP_ORDERS_B.osp_order_id%TYPE;
313: l_po_header_id AHL_OSP_ORDERS_B.po_header_id%TYPE;
314: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_id%TYPE;
315: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;
316: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;
317: l_oe_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
318: l_oe_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
319: l_po_line_qty NUMBER;
320: l_po_line_tot_qty NUMBER;

Line 547: FROM AHL_OSP_ORDER_LINES

543:
544: -- Cursor to get the ship line id of the OSP order lines, that correspond to the given return line.
545: CURSOR get_osp_ship_line_id (c_oe_return_line_id NUMBER) IS
546: SELECT oe_ship_line_id
547: FROM AHL_OSP_ORDER_LINES
548: WHERE oe_return_line_id = c_oe_return_line_id
549: AND ROWNUM = 1;
550:
551: -- Cursor to get the ordered and shipped quantities of the given return line.

Line 562: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;

558: l_api_name CONSTANT VARCHAR2(30) := 'Can_Receive_Against_RMA';
559: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
560:
561: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;
562: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;
563: l_ship_line_qty_rec get_oe_quantities%ROWTYPE;
564: l_return_line_qty_rec get_oe_quantities%ROWTYPE;
565: l_dummy VARCHAR2(1);
566: --

Line 719: FROM AHL_OSP_ORDER_LINES AOL, AHL_OSP_ORDERS_B AOB

715: CURSOR get_po_header_id (c_oe_return_line_id NUMBER) IS
716: SELECT AOB.po_header_id,
717: AOB.po_req_header_id,
718: AOB.osp_order_number
719: FROM AHL_OSP_ORDER_LINES AOL, AHL_OSP_ORDERS_B AOB
720: WHERE AOL.oe_return_line_id = c_oe_return_line_id
721: AND AOL.osp_order_id = AOB.osp_order_id
722: AND AOB.status_code IN ('PO_CREATED', 'REQ_CREATED')
723: AND ROWNUM = 1;

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 814: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;

810: l_po_header_id AHL_OSP_ORDERS_B.po_header_id%TYPE;
811: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_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;

Line 815: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;

811: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_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;

Line 1296: FROM ahl_osp_order_lines

1292: SELECT inventory_item_id,
1293: serial_number,
1294: lot_number,
1295: exchange_instance_id
1296: FROM ahl_osp_order_lines
1297: WHERE osp_order_line_id = c_osp_line_id;
1298:
1299: CURSOR ahl_oe_lot_serial_id_csr (c_oe_line_id NUMBER) IS
1300: SELECT lot_number,

Line 1313: FROM ahl_osp_order_lines

1309: AND rownum = 1;
1310:
1311: CURSOR get_oe_line_id(c_osp_line_id NUMBER) IS
1312: SELECT oe_return_line_id
1313: FROM ahl_osp_order_lines
1314: WHERE osp_order_line_id = c_osp_line_id;
1315:
1316: CURSOR get_instance_id(c_inv_item_id NUMBER, c_serial_number VARCHAR2) IS
1317: SELECT instance_id

Line 1337: FROM ahl_osp_order_lines matched_ol,

1333: AND processing_status_code = 'ERROR';
1334:
1335: CURSOR get_same_phyitem_order_lines(c_osp_order_line_id IN NUMBER) IS
1336: SELECT matched_ol.osp_order_line_id
1337: FROM ahl_osp_order_lines matched_ol,
1338: ahl_osp_order_lines passed_ol
1339: WHERE passed_ol.osp_order_line_id = c_osp_order_line_id
1340: AND passed_ol.inventory_item_id = matched_ol.inventory_item_id
1341: AND passed_ol.serial_number = matched_ol.serial_number;

Line 1338: ahl_osp_order_lines passed_ol

1334:
1335: CURSOR get_same_phyitem_order_lines(c_osp_order_line_id IN NUMBER) IS
1336: SELECT matched_ol.osp_order_line_id
1337: FROM ahl_osp_order_lines matched_ol,
1338: ahl_osp_order_lines passed_ol
1339: WHERE passed_ol.osp_order_line_id = c_osp_order_line_id
1340: AND passed_ol.inventory_item_id = matched_ol.inventory_item_id
1341: AND passed_ol.serial_number = matched_ol.serial_number;
1342:

Line 2297: FROM AHL_OSP_ORDER_LINES

2293:
2294: -- Cursor to get the ship line id of the OSP order lines, that correspond to the given return line.
2295: CURSOR get_osp_ship_line_id (c_oe_return_line_id NUMBER) IS
2296: SELECT oe_ship_line_id
2297: FROM AHL_OSP_ORDER_LINES
2298: WHERE oe_return_line_id = c_oe_return_line_id
2299: AND ROWNUM = 1;
2300:
2301: -- Cursor to get the ordered and shipped quantities of the given return line.

Line 2319: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;

2315: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Receiving_Params';
2316: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2317:
2318: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;
2319: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;
2320: l_oe_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
2321: l_oe_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
2322: l_valid_flag BOOLEAN := TRUE;
2323: l_part_num_change_flag BOOLEAN := FALSE;

Line 2613: FROM AHL_OSP_ORDER_LINES a

2609: a.ATTRIBUTE13,
2610: a.ATTRIBUTE14,
2611: a.ATTRIBUTE15,
2612: a.PO_REQ_LINE_ID
2613: FROM AHL_OSP_ORDER_LINES a
2614: WHERE a.osp_order_id = p_osp_id
2615: AND a.osp_order_line_id = p_osp_line_id;
2616:
2617: --

Line 2639: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW (

2635: FOR l_osp_line_rec IN ahl_osp_lines_csr(p_osp_order_id, p_osp_line_id)
2636: LOOP
2637: l_row_check := 'Y';
2638:
2639: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW (
2640: P_OSP_ORDER_LINE_ID => l_osp_line_rec.OSP_ORDER_LINE_ID,
2641: P_OBJECT_VERSION_NUMBER => l_osp_line_rec.OBJECT_VERSION_NUMBER+1,
2642: P_LAST_UPDATE_DATE => l_osp_line_rec.LAST_UPDATE_DATE,
2643: P_LAST_UPDATED_BY => l_osp_line_rec.LAST_UPDATED_BY,

Line 2754: FROM AHL_OSP_ORDER_LINES a

2750: a.ATTRIBUTE13,
2751: a.ATTRIBUTE14,
2752: a.ATTRIBUTE15,
2753: a.PO_REQ_LINE_ID
2754: FROM AHL_OSP_ORDER_LINES a
2755: WHERE a.osp_order_id = p_osp_id
2756: AND a.osp_order_line_id = p_osp_line_id;
2757: --
2758: l_oe_ship_line_id NUMBER;

Line 2781: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW (

2777: ELSE
2778: l_oe_return_line_id := l_osp_line_rec.oe_return_line_id;
2779: END IF;
2780:
2781: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW (
2782: P_OSP_ORDER_LINE_ID => l_osp_line_rec.OSP_ORDER_LINE_ID,
2783: P_OBJECT_VERSION_NUMBER => l_osp_line_rec.OBJECT_VERSION_NUMBER+1,
2784: P_LAST_UPDATE_DATE => l_osp_line_rec.LAST_UPDATE_DATE,
2785: P_LAST_UPDATED_BY => l_osp_line_rec.LAST_UPDATED_BY,