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 84: FROM AHL_OSP_ORDERS_B

80:
81: -- Cursor to get the shipment header id, i.e. oe_header_id, for the given OSP order id.
82: CURSOR get_oe_header_id (c_osp_order_id NUMBER) IS
83: SELECT oe_header_id
84: FROM AHL_OSP_ORDERS_B
85: WHERE osp_order_id = c_osp_order_id;
86:
87: -- Cursor to check whether the shipment, i.e. oe_header_id is booked or not.
88: CURSOR chk_shipment_booked (c_oe_header_id NUMBER) IS

Line 106: l_oe_header_id AHL_OSP_ORDERS_B.oe_header_id%TYPE;

102: --
103: l_api_name CONSTANT VARCHAR2(30) := 'Can_Receive_Against_OSP';
104: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
105:
106: l_oe_header_id AHL_OSP_ORDERS_B.oe_header_id%TYPE;
107: l_oe_line_id OE_ORDER_LINES_ALL.line_id%TYPE;
108: l_dummy VARCHAR2(1);
109: --
110:

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

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

Line 313: l_po_header_id AHL_OSP_ORDERS_B.po_header_id%TYPE;

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

Line 314: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_id%TYPE;

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

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

805: l_api_version CONSTANT NUMBER := 1.0;
806: l_api_name CONSTANT VARCHAR2(30) := 'Receive_Against_PO';
807: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
808:
809: l_osp_order_number AHL_OSP_ORDERS_B.osp_order_number%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;

Line 810: l_po_header_id AHL_OSP_ORDERS_B.po_header_id%TYPE;

806: l_api_name CONSTANT VARCHAR2(30) := 'Receive_Against_PO';
807: l_debug_key CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
808:
809: l_osp_order_number AHL_OSP_ORDERS_B.osp_order_number%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;

Line 811: l_po_req_header_id AHL_OSP_ORDERS_B.po_req_header_id%TYPE;

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

Line 812: l_po_vendor_id AHL_OSP_ORDERS_B.vendor_id%TYPE;

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

Line 813: l_po_vendor_site_id AHL_OSP_ORDERS_B.vendor_site_id%TYPE;

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

Line 1287: ahl_osp_orders_b osp

1283: osp.order_type_code,
1284: oel.source_document_line_id osp_line_id,
1285: osp.object_version_number
1286: FROM oe_order_lines_all oel,
1287: ahl_osp_orders_b osp
1288: WHERE oel.header_id = osp.oe_header_id
1289: AND oel.line_id = c_oe_line_id;
1290:
1291: CURSOR get_osp_order_line_dtls(c_osp_line_id NUMBER) IS