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 2884: qp_price_req_sources req,

2880: line.line_index,
2881: line.adjusted_unit_price,
2882: MIN(ql.operand) operand
2883: FROM qp_npreq_lines_tmp line,
2884: qp_price_req_sources req,
2885: qp_list_headers_b lhdr,
2886: qp_npreq_line_attrs_tmp lattr,
2887: qp_pricing_attributes qpa,
2888: qp_list_lines ql

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 9199: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1

9195: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_VALUE,5
9196: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
9197: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
9198: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
9199: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
9200: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,ACTIVE_FLAG,1
9201: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,CURRENCY_CODE,2
9202: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3
9203: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4

Line 9236: qp_price_req_sources req, --7323912

9232: (SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) INDEX(LHDR QP_LIST_HEADERS_B_N9) */ MIN(ql.operand) -- 7323912
9233: FROM qp_npreq_line_attrs_tmp lattr,
9234: qp_pricing_attributes qpa,
9235: qp_list_headers_b lhdr, --7323912
9236: qp_price_req_sources req, --7323912
9237: qp_list_lines ql
9238: WHERE lattr.line_index = line.line_index
9239: AND lattr.attribute_type = G_PRODUCT_TYPE
9240: AND lattr.context = qpa.product_attribute_context

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 14676: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1

14672: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
14673: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
14674: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14675: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14676: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
14677: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
14678: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_LINES_PK,LIST_LINE_ID,1
14679: */
14680: SELECT MIN(qpll.operand) INTO l_operand

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

14673: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
14674: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14675: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14676: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
14677: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
14678: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_LINES_PK,LIST_LINE_ID,1
14679: */
14680: SELECT MIN(qpll.operand) INTO l_operand
14681: FROM

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