APPS.QP_PREQ_PUB dependencies on QP_LIST_HEADERS_B

Line 1556: qp_list_headers_b qplh

1552: , NULL BREAK_UOM_CONTEXT
1553: , NULL BREAK_UOM_ATTRIBUTE
1554: , NULL PROCESS_CODE -- 3215497
1555: FROM qp_int_lines line, oe_price_adjustments adj,
1556: qp_list_headers_b qplh
1557: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
1558: AND line.process_status IN (QP_PREQ_PUB.G_STATUS_UPDATED,
1559: QP_PREQ_PUB.G_STATUS_NEW,
1560: QP_PREQ_PUB.G_STATUS_UNCHANGED,

Line 1673: qp_list_headers_b qplh

1669: , NULL BREAK_UOM_CONTEXT
1670: , NULL BREAK_UOM_ATTRIBUTE
1671: , NULL PROCESS_CODE -- 3215497
1672: FROM qp_int_lines line, oe_price_adjustments adj,
1673: qp_list_headers_b qplh
1674: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
1675: AND line.process_status IN (QP_PREQ_PUB.G_STATUS_UPDATED,
1676: QP_PREQ_PUB.G_STATUS_NEW,
1677: QP_PREQ_PUB.G_STATUS_UNCHANGED,

Line 2867: -- bug 3804392 - removed the hint qp_list_headers_b_n2 and also rearranged the tables in FROM clause

2863: PROCEDURE CHECK_GSA_VIOLATION(
2864: x_return_status OUT NOCOPY VARCHAR2,
2865: x_return_status_text OUT NOCOPY VARCHAR2) IS
2866:
2867: -- bug 3804392 - removed the hint qp_list_headers_b_n2 and also rearranged the tables in FROM clause
2868: CURSOR l_gsa_check_cur IS
2869: SELECT /*+ ORDERED USE_NL(req lhdr lattr qpa ql) index(qpa qp_pricing_attributes_n5) */
2870: line.line_index,
2871: line.adjusted_unit_price,

Line 2875: qp_list_headers_b lhdr,

2871: line.adjusted_unit_price,
2872: MIN(ql.operand) operand
2873: FROM qp_npreq_lines_tmp line,
2874: qp_price_req_sources req,
2875: qp_list_headers_b lhdr,
2876: qp_npreq_line_attrs_tmp lattr,
2877: qp_pricing_attributes qpa,
2878: qp_list_lines ql
2879: WHERE lattr.line_index = line.line_index

Line 2912: -- bug 3804392 - removed the hint qp_list_headers_b_n2 and also rearranged the tables in FROM clause

2908: AND trunc(nvl(ql.End_date_active
2909: , line.pricing_effective_date))
2910: GROUP BY line.line_index, line.adjusted_unit_price;
2911:
2912: -- bug 3804392 - removed the hint qp_list_headers_b_n2 and also rearranged the tables in FROM clause
2913: CURSOR l_attrmgr_gsa_check_cur IS
2914: SELECT /*+ ORDERED USE_NL(req lhdr lattr qpa ql) index(qpa qp_pricing_attributes_n5) */
2915: line.line_index,
2916: line.adjusted_unit_price,

Line 2920: qp_list_headers_b lhdr,

2916: line.adjusted_unit_price,
2917: MIN(ql.operand) operand
2918: FROM qp_npreq_lines_tmp line,
2919: qp_price_req_sources_v req,
2920: qp_list_headers_b lhdr,
2921: qp_npreq_line_attrs_tmp lattr,
2922: qp_pricing_attributes qpa,
2923: qp_list_lines ql
2924: WHERE lattr.line_index = line.line_index

Line 9123: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,ACTIVE_FLAG,1

9119: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
9120: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
9121: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
9122: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
9123: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,ACTIVE_FLAG,1
9124: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,CURRENCY_CODE,2
9125: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3
9126: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4
9127: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_HEADER_ID,5

Line 9124: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,CURRENCY_CODE,2

9120: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
9121: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
9122: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
9123: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,ACTIVE_FLAG,1
9124: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,CURRENCY_CODE,2
9125: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3
9126: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4
9127: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_HEADER_ID,5
9128: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,GSA_INDICATOR,6

Line 9125: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3

9121: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
9122: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
9123: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,ACTIVE_FLAG,1
9124: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,CURRENCY_CODE,2
9125: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3
9126: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4
9127: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_HEADER_ID,5
9128: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,GSA_INDICATOR,6
9129: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_LINES_PK,LIST_LINE_ID,1

Line 9126: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4

9122: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
9123: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,ACTIVE_FLAG,1
9124: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,CURRENCY_CODE,2
9125: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3
9126: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4
9127: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_HEADER_ID,5
9128: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,GSA_INDICATOR,6
9129: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_LINES_PK,LIST_LINE_ID,1
9130: */

Line 9127: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_HEADER_ID,5

9123: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,ACTIVE_FLAG,1
9124: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,CURRENCY_CODE,2
9125: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3
9126: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4
9127: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_HEADER_ID,5
9128: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,GSA_INDICATOR,6
9129: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_LINES_PK,LIST_LINE_ID,1
9130: */
9131: IF l_debug = FND_API.G_TRUE THEN

Line 9128: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,GSA_INDICATOR,6

9124: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,CURRENCY_CODE,2
9125: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3
9126: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4
9127: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_HEADER_ID,5
9128: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,GSA_INDICATOR,6
9129: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_LINES_PK,LIST_LINE_ID,1
9130: */
9131: IF l_debug = FND_API.G_TRUE THEN
9132: QP_PREQ_GRP.engine_debug('Pub GSA attr_mgr_installed '

Line 9155: (SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) INDEX(LHDR QP_LIST_HEADERS_B_N9) */ MIN(ql.operand) -- 7323912

9151: AND gsa_attr.attribute = G_GSA_ATTRIBUTE
9152: AND gsa_attr.value_from = G_YES)
9153: AND line.adjusted_unit_price <=
9154: --(SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) */ MIN(ql.operand) -- 7323912
9155: (SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) INDEX(LHDR QP_LIST_HEADERS_B_N9) */ MIN(ql.operand) -- 7323912
9156: FROM qp_npreq_line_attrs_tmp lattr,
9157: qp_pricing_attributes qpa,
9158: qp_list_headers_b lhdr, --7323912
9159: qp_price_req_sources req, --7323912

Line 9158: qp_list_headers_b lhdr, --7323912

9154: --(SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) */ MIN(ql.operand) -- 7323912
9155: (SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) INDEX(LHDR QP_LIST_HEADERS_B_N9) */ MIN(ql.operand) -- 7323912
9156: FROM qp_npreq_line_attrs_tmp lattr,
9157: qp_pricing_attributes qpa,
9158: qp_list_headers_b lhdr, --7323912
9159: qp_price_req_sources req, --7323912
9160: qp_list_lines ql
9161: WHERE lattr.line_index = line.line_index
9162: AND lattr.attribute_type = G_PRODUCT_TYPE

Line 9209: (SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) INDEX(LHDR QP_LIST_HEADERS_B_N9) */ MIN(ql.operand) --7323912

9205: AND gsa_attr.attribute = G_GSA_ATTRIBUTE
9206: AND gsa_attr.value_from = G_YES)
9207: AND line.adjusted_unit_price <=
9208: --(SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) */ MIN(ql.operand) --7323912
9209: (SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) INDEX(LHDR QP_LIST_HEADERS_B_N9) */ MIN(ql.operand) --7323912
9210: FROM qp_npreq_line_attrs_tmp lattr,
9211: qp_pricing_attributes qpa,
9212: qp_list_headers_b lhdr, --7323912
9213: qp_price_req_sources_v req, --7323912

Line 9212: qp_list_headers_b lhdr, --7323912

9208: --(SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) */ MIN(ql.operand) --7323912
9209: (SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) INDEX(LHDR QP_LIST_HEADERS_B_N9) */ MIN(ql.operand) --7323912
9210: FROM qp_npreq_line_attrs_tmp lattr,
9211: qp_pricing_attributes qpa,
9212: qp_list_headers_b lhdr, --7323912
9213: qp_price_req_sources_v req, --7323912
9214: qp_list_lines ql
9215: WHERE lattr.line_index = line.line_index
9216: AND lattr.attribute_type = G_PRODUCT_TYPE

Line 12520: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1

12516:
12517: /*
12518: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
12519: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_INT_LDETS_N4,PRICING_STATUS_CODE,1
12520: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
12521: */
12522: CURSOR l_ldets_cur(p_line_index NUMBER) IS
12523: SELECT /*+ ORDERED USE_NL(A B C) l_ldets_cur */
12524: a.LINE_DETAIL_INDEX,

Line 12760: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1

12756:
12757: /*
12758: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
12759: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
12760: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
12761: */
12762: CURSOR l_ldets_cur(p_line_index NUMBER) IS
12763: SELECT /*+ ORDERED USE_NL(A B C) l_ldets_cur */
12764: a.LINE_DETAIL_INDEX,

Line 14487: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1

14483: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
14484: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
14485: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
14486: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14487: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14488: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
14489: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
14490: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_LINES_PK,LIST_LINE_ID,1
14491: */

Line 14497: QP_LIST_HEADERS_B qplh,

14493: FROM
14494: QP_QUALIFIERS qpq,
14495: QP_PRICING_ATTRIBUTES qppa,
14496: QP_LIST_LINES qpll,
14497: QP_LIST_HEADERS_B qplh,
14498: QP_PRICE_REQ_SOURCES_V qpprs
14499: WHERE
14500: qpq.qualifier_context = 'CUSTOMER' AND
14501: qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE15' AND