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 259: FROM AHL_OSP_ORDER_LINES AOL, AHL_OSP_ORDERS_B AOB

255: CURSOR get_po_header_id (c_oe_return_line_id NUMBER) IS
256: SELECT AOB.po_header_id,
257: AOB.po_req_header_id,
258: AOL.osp_order_id
259: FROM AHL_OSP_ORDER_LINES AOL, AHL_OSP_ORDERS_B AOB
260: WHERE AOL.oe_return_line_id = c_oe_return_line_id
261: AND AOL.osp_order_id = AOB.osp_order_id
262: AND AOB.status_code IN ('PO_CREATED', 'REQ_CREATED')
263: AND ROWNUM = 1;

Line 289: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL

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
292: AND NVL(AOL.status_code, 'X') <> 'PO_DELETED'
293: AND NVL(AOL.status_code, 'X') <> 'PO_CANCELLED'

Line 324: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;

320:
321: l_osp_order_id AHL_OSP_ORDERS_B.osp_order_id%TYPE;
322: l_po_header_id AHL_OSP_ORDERS_B.po_header_id%TYPE;
323: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_id%TYPE;
324: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;
325: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;
326: l_oe_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
327: l_oe_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
328: l_po_line_qty NUMBER;

Line 325: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;

321: l_osp_order_id AHL_OSP_ORDERS_B.osp_order_id%TYPE;
322: l_po_header_id AHL_OSP_ORDERS_B.po_header_id%TYPE;
323: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_id%TYPE;
324: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;
325: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;
326: l_oe_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
327: l_oe_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
328: l_po_line_qty NUMBER;
329: l_po_line_tot_qty NUMBER;

Line 556: FROM AHL_OSP_ORDER_LINES

552:
553: -- Cursor to get the ship line id of the OSP order lines, that correspond to the given return line.
554: CURSOR get_osp_ship_line_id (c_oe_return_line_id NUMBER) IS
555: SELECT oe_ship_line_id
556: FROM AHL_OSP_ORDER_LINES
557: WHERE oe_return_line_id = c_oe_return_line_id
558: AND ROWNUM = 1;
559:
560: -- Cursor to get the ordered and shipped quantities of the given return line.

Line 571: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;

567: l_api_name CONSTANT VARCHAR2(30) := 'Can_Receive_Against_RMA';
568: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
569:
570: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;
571: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;
572: l_ship_line_qty_rec get_oe_quantities%ROWTYPE;
573: l_return_line_qty_rec get_oe_quantities%ROWTYPE;
574: l_dummy VARCHAR2(1);
575: --

Line 721: FROM AHL_OSP_ORDER_LINES

717:
718: -- Cursor to get the ship line id of the OSP order lines, that correspond to the given return line.
719: CURSOR get_osp_ship_line_id (c_oe_return_line_id NUMBER) IS
720: SELECT oe_ship_line_id
721: FROM AHL_OSP_ORDER_LINES
722: WHERE oe_return_line_id = c_oe_return_line_id
723: AND ROWNUM = 1;
724:
725: -- Cursor to get the ordered and shipped quantities of the given return line.

Line 756: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;

752: l_api_name CONSTANT VARCHAR2(30) := 'Can_Nav_to_Warranty_WB';
753: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
754:
755: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;
756: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;
757: l_ship_line_qty_rec get_oe_quantities%ROWTYPE;
758: --l_return_line_qty_rec get_oe_quantities%ROWTYPE;
759: l_dummy VARCHAR2(1);
760: L_NO_WORKBENCH VARCHAR2(15) := 'NoWorkbench';

Line 949: FROM AHL_OSP_ORDER_LINES AOL, AHL_OSP_ORDERS_B AOB

945: CURSOR get_po_header_id (c_oe_return_line_id NUMBER) IS
946: SELECT AOB.po_header_id,
947: AOB.po_req_header_id,
948: AOB.osp_order_number
949: FROM AHL_OSP_ORDER_LINES AOL, AHL_OSP_ORDERS_B AOB
950: WHERE AOL.oe_return_line_id = c_oe_return_line_id
951: AND AOL.osp_order_id = AOB.osp_order_id
952: AND AOB.status_code IN ('PO_CREATED', 'REQ_CREATED')
953: AND ROWNUM = 1;

Line 987: FROM AHL_OSP_ORDER_LINES AOL, PO_LINES_ALL POL

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
990: AND NVL(AOL.status_code, 'X') <> 'PO_DELETED'
991: AND NVL(AOL.status_code, 'X') <> 'PO_CANCELLED'

Line 1044: l_po_line_id AHL_OSP_ORDER_LINES.po_line_id%TYPE;

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

Line 1045: l_po_req_line_id AHL_OSP_ORDER_LINES.po_req_line_id%TYPE;

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

Line 1526: FROM ahl_osp_order_lines

1522: SELECT inventory_item_id,
1523: serial_number,
1524: lot_number,
1525: exchange_instance_id
1526: FROM ahl_osp_order_lines
1527: WHERE osp_order_line_id = c_osp_line_id;
1528:
1529: CURSOR ahl_oe_lot_serial_id_csr (c_oe_line_id NUMBER) IS
1530: SELECT lot_number,

Line 1543: FROM ahl_osp_order_lines

1539: AND rownum = 1;
1540:
1541: CURSOR get_oe_line_id(c_osp_line_id NUMBER) IS
1542: SELECT oe_return_line_id
1543: FROM ahl_osp_order_lines
1544: WHERE osp_order_line_id = c_osp_line_id;
1545:
1546: CURSOR get_instance_id(c_inv_item_id NUMBER, c_serial_number VARCHAR2) IS
1547: SELECT instance_id

Line 1567: FROM ahl_osp_order_lines matched_ol,

1563: AND processing_status_code = 'ERROR';
1564:
1565: CURSOR get_same_phyitem_order_lines(c_osp_order_line_id IN NUMBER) IS
1566: SELECT matched_ol.osp_order_line_id
1567: FROM ahl_osp_order_lines matched_ol,
1568: ahl_osp_order_lines passed_ol
1569: WHERE passed_ol.osp_order_line_id = c_osp_order_line_id
1570: AND passed_ol.inventory_item_id = matched_ol.inventory_item_id
1571: AND passed_ol.serial_number = matched_ol.serial_number

Line 1568: ahl_osp_order_lines passed_ol

1564:
1565: CURSOR get_same_phyitem_order_lines(c_osp_order_line_id IN NUMBER) IS
1566: SELECT matched_ol.osp_order_line_id
1567: FROM ahl_osp_order_lines matched_ol,
1568: ahl_osp_order_lines passed_ol
1569: WHERE passed_ol.osp_order_line_id = c_osp_order_line_id
1570: AND passed_ol.inventory_item_id = matched_ol.inventory_item_id
1571: AND passed_ol.serial_number = matched_ol.serial_number
1572: --modfication by jrotich 08/22/2012 in order to fix bug 14526440

Line 2576: FROM AHL_OSP_ORDER_LINES

2572:
2573: -- Cursor to get the ship line id of the OSP order lines, that correspond to the given return line.
2574: CURSOR get_osp_ship_line_id (c_oe_return_line_id NUMBER) IS
2575: SELECT oe_ship_line_id
2576: FROM AHL_OSP_ORDER_LINES
2577: WHERE oe_return_line_id = c_oe_return_line_id
2578: AND ROWNUM = 1;
2579:
2580: -- Cursor to get the ordered and shipped quantities of the given return line.

Line 2598: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;

2594: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Receiving_Params';
2595: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2596:
2597: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;
2598: l_oe_ship_line_id AHL_OSP_ORDER_LINES.oe_ship_line_id%TYPE;
2599: l_oe_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
2600: l_oe_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
2601: l_valid_flag BOOLEAN := TRUE;
2602: l_part_num_change_flag BOOLEAN := FALSE;

Line 2892: FROM AHL_OSP_ORDER_LINES a

2888: a.ATTRIBUTE13,
2889: a.ATTRIBUTE14,
2890: a.ATTRIBUTE15,
2891: a.PO_REQ_LINE_ID
2892: FROM AHL_OSP_ORDER_LINES a
2893: WHERE a.osp_order_id = p_osp_id
2894: AND a.osp_order_line_id = p_osp_line_id;
2895:
2896: --

Line 2918: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW (

2914: FOR l_osp_line_rec IN ahl_osp_lines_csr(p_osp_order_id, p_osp_line_id)
2915: LOOP
2916: l_row_check := 'Y';
2917:
2918: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW (
2919: P_OSP_ORDER_LINE_ID => l_osp_line_rec.OSP_ORDER_LINE_ID,
2920: P_OBJECT_VERSION_NUMBER => l_osp_line_rec.OBJECT_VERSION_NUMBER+1,
2921: P_LAST_UPDATE_DATE => l_osp_line_rec.LAST_UPDATE_DATE,
2922: P_LAST_UPDATED_BY => l_osp_line_rec.LAST_UPDATED_BY,

Line 3033: FROM AHL_OSP_ORDER_LINES a

3029: a.ATTRIBUTE13,
3030: a.ATTRIBUTE14,
3031: a.ATTRIBUTE15,
3032: a.PO_REQ_LINE_ID
3033: FROM AHL_OSP_ORDER_LINES a
3034: WHERE a.osp_order_id = p_osp_id
3035: AND a.osp_order_line_id = p_osp_line_id;
3036: --
3037: l_oe_ship_line_id NUMBER;

Line 3060: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW (

3056: ELSE
3057: l_oe_return_line_id := l_osp_line_rec.oe_return_line_id;
3058: END IF;
3059:
3060: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW (
3061: P_OSP_ORDER_LINE_ID => l_osp_line_rec.OSP_ORDER_LINE_ID,
3062: P_OBJECT_VERSION_NUMBER => l_osp_line_rec.OBJECT_VERSION_NUMBER+1,
3063: P_LAST_UPDATE_DATE => l_osp_line_rec.LAST_UPDATE_DATE,
3064: P_LAST_UPDATED_BY => l_osp_line_rec.LAST_UPDATED_BY,