DBA Data[Home] [Help]

APPS.QP_CROSS_ORDER_VOLUME_LOAD dependencies on QP_LIST_HEADERS

Line 277: FROM qp_list_headers qlh,

273: -- Cursor to get all items which have cross order volume pricing attributes defined
274:
275: CURSOR Cur_get_items IS
276: SELECT distinct to_number(qpa.product_attr_value) c_inventory_item_id
277: FROM qp_list_headers qlh,
278: qp_list_lines qpl,
279: qp_pricing_attributes qpa
280: WHERE qlh.list_header_id = qpl.list_header_id
281: AND qpl.list_line_id = qpa.list_line_id

Line 566: FROM qp_list_headers qlh,

562: l_sob_currency VARCHAR2(15) := x_sob_currency;
563:
564: CURSOR Cur_cross_order_qualifiers IS
565: SELECT 'Y'
566: FROM qp_list_headers qlh,
567: qp_qualifiers qq
568: WHERE qq.list_header_id = qlh.list_header_id
569: AND qlh.active_flag = 'Y'
570: AND qq.qualifier_context = 'VOLUME'