eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PREQ_PUB dependencies on QP_PRICE_REQ_SOURCES

Line 2874: qp_price_req_sources req,

2870: line.line_index,
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

Line 2919: qp_price_req_sources_v req,

2915: line.line_index,
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

Line 9122: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1

9118: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_VALUE,5
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

Line 9159: qp_price_req_sources req, --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
9163: AND lattr.context = qpa.product_attribute_context

Line 9213: qp_price_req_sources_v req, --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
9217: AND lattr.context = qpa.product_attribute_context

Line 14488: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1

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: */
14492: SELECT MIN(qpll.operand) INTO l_operand

Line 14489: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2

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: */
14492: SELECT MIN(qpll.operand) INTO l_operand
14493: FROM

Line 14498: QP_PRICE_REQ_SOURCES_V qpprs

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
14502: qpq.qualifier_attr_value = 'Y' AND