528: From oe_price_adjs_iface_all adj_iface,
529: oe_lines_iface_all lines_iface,
530: qp_int_lines line,
531: qp_list_lines ll,
532: qp_list_headers_b lhdr
533: Where adj_iface.ORDER_SOURCE_ID = lines_iface.ORDER_SOURCE_ID
534: and adj_iface.ORIG_SYS_DOCUMENT_REF = lines_iface.ORIG_SYS_DOCUMENT_REF
535: and adj_iface.ORIG_SYS_LINE_REF = lines_iface.ORIG_SYS_LINE_REF
536: and line.line_type_code = 'LINE'
627: From oe_price_adjs_iface_all adj_iface,
628: oe_headers_iface_all hdrs_iface,
629: qp_int_lines line,
630: qp_list_lines ll,
631: qp_list_headers_b lhdr
632: Where adj_iface.ORDER_SOURCE_ID = hdrs_iface.ORDER_SOURCE_ID
633: and adj_iface.ORIG_SYS_DOCUMENT_REF = hdrs_iface.ORIG_SYS_DOCUMENT_REF
634: and line.line_type_code = 'ORDER'
635: and adj_iface.ORIG_SYS_LINE_REF is null
648: From oe_price_adjs_iface_all adj_iface,
649: oe_lines_iface_all lines_iface,
650: qp_int_lines line,
651: qp_list_lines ll,
652: qp_list_headers_b lhdr
653: Where adj_iface.ORIG_SYS_LINE_REF = lines_iface.ORIG_SYS_LINE_REF
654: and lines_iface.line_id = line.line_id
655: --and lines_iface.header_id = line.header_id
656: and ll.list_line_id = adj_iface.list_line_id