DBA Data[Home] [Help]

APPS.QP_BULK_PREQ_GRP dependencies on QP_LIST_HEADERS_B

Line 532: qp_list_headers_b lhdr

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'

Line 631: qp_list_headers_b lhdr

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

Line 652: qp_list_headers_b lhdr

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