APPS.AHL_OSP_RCV_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 90: FROM OE_ORDER_HEADERS_ALL

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
89: SELECT 'X'
90: FROM OE_ORDER_HEADERS_ALL
91: WHERE header_id = c_oe_header_id
92: AND booked_flag = 'Y';
93:
94: -- Cursor to get all the RMA type lines for the given sales order.

Line 539: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA

535:
536: -- Cursor to check whether the shipment is booked or not.
537: CURSOR chk_shipment_booked (c_oe_line_id NUMBER) IS
538: SELECT OHA.header_id
539: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA
540: WHERE OLA.line_id = c_oe_line_id
541: AND OHA.header_id = OLA.header_id
542: AND OHA.booked_flag = 'Y';
543:

Line 561: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;

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

Line 2289: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA

2285:
2286: -- Cursor to check whether the shipment is booked or not.
2287: CURSOR chk_shipment_booked (c_oe_line_id NUMBER) IS
2288: SELECT OHA.header_id
2289: FROM OE_ORDER_LINES_ALL OLA, OE_ORDER_HEADERS_ALL OHA
2290: WHERE OLA.line_id = c_oe_line_id
2291: AND OHA.header_id = OLA.header_id
2292: AND OHA.booked_flag = 'Y';
2293:

Line 2318: l_oe_header_id OE_ORDER_HEADERS_ALL.header_id%TYPE;

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