DBA Data[Home] [Help]

APPS.QP_BULK_PREQ_GRP dependencies on QP_LIST_LINES

Line 531: qp_list_lines ll,

527: adj_iface.ADJUSTED_AMOUNT_PER_PQTY
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

Line 630: qp_list_lines ll,

626: adj_iface.ADJUSTED_AMOUNT_PER_PQTY
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'

Line 651: qp_list_lines ll,

647: select count(*) into ldet_count
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