DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on QP_PRICE_REQ_SOURCES_V

Line 2929: qp_price_req_sources_v req,

2925: line.line_index,
2926: line.adjusted_unit_price,
2927: MIN(ql.operand) operand
2928: FROM qp_npreq_lines_tmp line,
2929: qp_price_req_sources_v req,
2930: qp_list_headers_b lhdr,
2931: qp_npreq_line_attrs_tmp lattr,
2932: qp_pricing_attributes qpa,
2933: qp_list_lines ql

Line 9290: qp_price_req_sources_v req, --7323912

9286: (SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) INDEX(LHDR QP_LIST_HEADERS_B_N9) */ MIN(ql.operand) --7323912
9287: FROM qp_npreq_line_attrs_tmp lattr,
9288: qp_pricing_attributes qpa,
9289: qp_list_headers_b lhdr, --7323912
9290: qp_price_req_sources_v req, --7323912
9291: qp_list_lines ql
9292: WHERE lattr.line_index = line.line_index
9293: AND lattr.attribute_type = G_PRODUCT_TYPE
9294: AND lattr.context = qpa.product_attribute_context

Line 14686: QP_PRICE_REQ_SOURCES_V qpprs

14682: QP_QUALIFIERS qpq,
14683: QP_PRICING_ATTRIBUTES qppa,
14684: QP_LIST_LINES qpll,
14685: QP_LIST_HEADERS_B qplh,
14686: QP_PRICE_REQ_SOURCES_V qpprs
14687: WHERE
14688: qpq.qualifier_context = 'CUSTOMER' AND
14689: qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE15' AND
14690: qpq.qualifier_attr_value = 'Y' AND