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_ORDERS_B

Line 93: FROM AHL_OSP_ORDERS_B

89:
90: -- Cursor to get the shipment header id, i.e. oe_header_id, for the given OSP order id.
91: CURSOR get_oe_header_id (c_osp_order_id NUMBER) IS
92: SELECT oe_header_id
93: FROM AHL_OSP_ORDERS_B
94: WHERE osp_order_id = c_osp_order_id;
95:
96: -- Cursor to check whether the shipment, i.e. oe_header_id is booked or not.
97: CURSOR chk_shipment_booked (c_oe_header_id NUMBER) IS

Line 115: l_oe_header_id AHL_OSP_ORDERS_B.oe_header_id%TYPE;

111: --
112: l_api_name CONSTANT VARCHAR2(30) := 'Can_Receive_Against_OSP';
113: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
114:
115: l_oe_header_id AHL_OSP_ORDERS_B.oe_header_id%TYPE;
116: l_oe_line_id OE_ORDER_LINES_ALL.line_id%TYPE;
117: l_dummy VARCHAR2(1);
118: --
119:

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 321: l_osp_order_id AHL_OSP_ORDERS_B.osp_order_id%TYPE;

317: --
318: l_api_name CONSTANT VARCHAR2(30) := 'Can_Receive_Against_PO';
319: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
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;

Line 322: l_po_header_id AHL_OSP_ORDERS_B.po_header_id%TYPE;

318: l_api_name CONSTANT VARCHAR2(30) := 'Can_Receive_Against_PO';
319: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
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;

Line 323: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_id%TYPE;

319: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
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;

Line 740: FROM ahl_osp_orders_b OSP, AHL_VENDOR_CERTIFICATIONS_V AVCV

736:
737: -- Cursor to check whether the given vendor is warranty enabled
738: CURSOR is_warranty_vendor (c_osp_order_id NUMBER) IS
739: SELECT AVCV.Warranty_flag
740: FROM ahl_osp_orders_b OSP, AHL_VENDOR_CERTIFICATIONS_V AVCV
741: WHERE OSP.VENDOR_ID = AVCV.VENDOR_ID
742: AND OSP.OSP_ORDER_ID = c_osp_order_id;
743:
744: -- Cursor to check whether the item is trackable

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 1039: l_osp_order_number AHL_OSP_ORDERS_B.osp_order_number%TYPE;

1035: l_api_version CONSTANT NUMBER := 1.0;
1036: l_api_name CONSTANT VARCHAR2(30) := 'Receive_Against_PO';
1037: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1038:
1039: l_osp_order_number AHL_OSP_ORDERS_B.osp_order_number%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;

Line 1040: l_po_header_id AHL_OSP_ORDERS_B.po_header_id%TYPE;

1036: l_api_name CONSTANT VARCHAR2(30) := 'Receive_Against_PO';
1037: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1038:
1039: l_osp_order_number AHL_OSP_ORDERS_B.osp_order_number%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;

Line 1041: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_id%TYPE;

1037: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1038:
1039: l_osp_order_number AHL_OSP_ORDERS_B.osp_order_number%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;

Line 1042: l_po_vendor_id AHL_OSP_ORDERS_B.vendor_id%TYPE;

1038:
1039: l_osp_order_number AHL_OSP_ORDERS_B.osp_order_number%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;

Line 1043: l_po_vendor_site_id AHL_OSP_ORDERS_B.vendor_site_id%TYPE;

1039: l_osp_order_number AHL_OSP_ORDERS_B.osp_order_number%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;

Line 1517: ahl_osp_orders_b osp

1513: osp.order_type_code,
1514: oel.source_document_line_id osp_line_id,
1515: osp.object_version_number
1516: FROM oe_order_lines_all oel,
1517: ahl_osp_orders_b osp
1518: WHERE oel.header_id = osp.oe_header_id
1519: AND oel.line_id = c_oe_line_id;
1520:
1521: CURSOR get_osp_order_line_dtls(c_osp_line_id NUMBER) IS