APPS.AHL_OSP_RCV_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 99: FROM OE_ORDER_HEADERS_ALL

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
98: SELECT 'X'
99: FROM OE_ORDER_HEADERS_ALL
100: WHERE header_id = c_oe_header_id
101: AND booked_flag = 'Y';
102:
103: -- Cursor to get all the RMA type lines for the given sales order.

Line 548: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA

544:
545: -- Cursor to check whether the shipment is booked or not.
546: CURSOR chk_shipment_booked (c_oe_line_id NUMBER) IS
547: SELECT OHA.header_id
548: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA
549: WHERE OLA.line_id = c_oe_line_id
550: AND OHA.header_id = OLA.header_id
551: AND OHA.booked_flag = 'Y';
552:

Line 570: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;

566: --
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);

Line 713: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA

709:
710: -- Cursor to check whether the shipment is booked or not.
711: CURSOR chk_shipment_booked (c_oe_line_id NUMBER) IS
712: SELECT OHA.header_id
713: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA
714: WHERE OLA.line_id = c_oe_line_id
715: AND OHA.header_id = OLA.header_id
716: AND OHA.booked_flag = 'Y';
717:

Line 755: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;

751: --
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);

Line 2568: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA

2564:
2565: -- Cursor to check whether the shipment is booked or not.
2566: CURSOR chk_shipment_booked (c_oe_line_id NUMBER) IS
2567: SELECT OHA.header_id
2568: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA
2569: WHERE OLA.line_id = c_oe_line_id
2570: AND OHA.header_id = OLA.header_id
2571: AND OHA.booked_flag = 'Y';
2572:

Line 2597: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;

2593: --
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;