APPS.AHL_OSP_RCV_PVT dependencies on FND_PROFILE

Line 221: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

217: CURSOR chk_return_line (c_oe_line_id NUMBER) IS
218: SELECT 'X'
219: FROM OE_ORDER_LINES_ALL
220: WHERE line_id = c_oe_line_id
221: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
222:
223: -- SATHAPLI::Bug 6877509 - changes start, 02-Apr-08
224: -- Cursor to get the ordered and shipped quantities of the given return line.
225: -- If the return line has been split (like in partial qty receive for non-serialized items), we have to look at

Line 543: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

539: CURSOR chk_return_line (c_oe_line_id NUMBER) IS
540: SELECT 'X'
541: FROM OE_ORDER_LINES_ALL
542: WHERE line_id = c_oe_line_id
543: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
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

Line 708: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

704: CURSOR chk_return_line (c_oe_line_id NUMBER) IS
705: SELECT 'X'
706: FROM OE_ORDER_LINES_ALL
707: WHERE line_id = c_oe_line_id
708: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
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

Line 2563: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

2559: CURSOR chk_return_line (c_oe_line_id NUMBER) IS
2560: SELECT 'X'
2561: FROM OE_ORDER_LINES_ALL
2562: WHERE line_id = c_oe_line_id
2563: AND line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
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