select m from MAMRequestLines m join fetch  m.mamRequestHeaders r left join fetch m.requestHeaderFromStore rr where m.id =:id

select m from MAMRequestLines m join fetch  m.mamRequestHeaders r left join fetch m.requestHeaderFromStore rr join fetch rr.mamDeliveryPoints  left join fetch r.mamDeliveryPoints  join fetch where m.id =:id

@Entity(name = "RequestLines")
    @Table(name = "_REQUEST_LINES")

//@JsonIdentityInfo(generator=ObjectIdGenerators.PropertyGenerator.class, property = "@id")
    public class RequestLines extends Entity implements Serializable {


        @JsonInclude(JsonInclude.Include.NON_EMPTY)
        private RequestHeaders RequestHeaders;



        @JsonInclude(JsonInclude.Include.NON_EMPTY)
        private RequestHeaders requestHeaderFromStore;




        @Id
        @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "_REQUEST_Line_SEQ")
        @SequenceGenerator(name = "_REQUEST_Line_SEQ", sequenceName = "_REQUEST_Line_SEQ")
        @Column(name = "REQUEST_LINE_ID")
        public Long getId() {
            return id;
        }

        public void setId(Long id) {
            this.id = id;
        }


        @ManyToOne(fetch = FetchType.LAZY)
        @JoinColumn(name = "REQUEST_HEADER_ID", nullable = false)
        public RequestHeaders getRequestHeaders() {
            return RequestHeaders;
        }

        public void setRequestHeaders(RequestHeaders RequestHeaders) {
            this.RequestHeaders = RequestHeaders;
        }




        @ManyToOne(fetch = FetchType.LAZY)
        @JoinColumn(name = "REQUEST_HEADER_FROM_STORE")
        public RequestHeaders getRequestHeaderFromStore() {
            return requestHeaderFromStore;
        }

        public void setRequestHeaderFromStore(RequestHeaders requestHeaderFromStore) {
            this.requestHeaderFromStore = requestHeaderFromStore;
        }




    }

@Entity(name = "RequestHeaders")
    @Table(name = "REQUEST_HEADERS")
    //@JsonInclude(JsonInclude.Include.NON_EMPTY)
    public class RequestHeaders extends Entity implements Serializable {

        private long id;



    // @JsonInclude(JsonInclude.Include.NON_EMPTY)
      // @JsonIgnore
        private DeliveryPoints DeliveryPoints;


        @JsonIgnore
        private Set<RequestLines> RequestLinesSet;


        @Id
        @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "_REQUEST_HEADERS_SEQ")
        @SequenceGenerator(name = "_REQUEST_HEADERS_SEQ", sequenceName = "_REQUEST_HEADERS_SEQ")
        @Column(name = "REQUEST_HEADER_ID")
        public long getId() {
            return id;
        }

        public void setId(long id) {
            this.id = id;
        }



        @ManyToOne(fetch = FetchType.LAZY)
        @JoinColumn(name = "DELIVERY_POINT_ID", nullable = false)
        public DeliveryPoints getDeliveryPoints() {
            return DeliveryPoints;
        }

        public void setDeliveryPoints(DeliveryPoints DeliveryPoints) {
            this.DeliveryPoints = DeliveryPoints;
        }


        @OneToMany(mappedBy = "RequestHeaders", fetch = FetchType.LAZY, cascade = CascadeType.ALL, orphanRemoval = true)
        @OnDelete(action = OnDeleteAction.CASCADE)
        public Set<RequestLines> getRequestLinesSet() {
            return RequestLinesSet;
        }

        public void setRequestLinesSet(Set<RequestLines> RequestLinesSet) {
            this.RequestLinesSet = RequestLinesSet;
        }


    }



select m from MAMRequestLines m  join fetch m.mamRequestHeaders r left join fetch m.requestHeaderFromStore rr join fetch rr.mamDeliveryPoints join fetch rr.costCenter  join fetch r.mamDeliveryPoints  join fetch r.costCenter where m.id =:id