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_NPREQ_LINE_ATTRS_TMP

Line 285: UPDATE qp_npreq_line_attrs_tmp attr SET attr.list_header_id =

281: QP_PREQ_GRP.engine_debug('5.6 initialize_constants');
282: END IF;
283: --fix for bug 2374591 ask for promotions not getting applied
284: --updating the list_header_id in the attribute where list_line_id is passed
285: UPDATE qp_npreq_line_attrs_tmp attr SET attr.list_header_id =
286: (SELECT qpl.list_header_id FROM
287: qp_list_lines qpl WHERE qpl.list_line_id = to_number(attr.value_from))
288: WHERE attr.context = 'MODLIST'
289: AND attribute = 'QUALIFIER_ATTRIBUTE2'

Line 334: INSERT INTO qp_npreq_line_attrs_tmp

330: END IF;
331: /*
332: indxno index used
333: */
334: INSERT INTO qp_npreq_line_attrs_tmp
335: (LINE_INDEX
336: , LINE_DETAIL_INDEX
337: , ATTRIBUTE_LEVEL
338: , NO_QUALIFIERS_IN_GRP

Line 426: INSERT INTO qp_npreq_line_attrs_tmp

422: END IF;
423: /*
424: indxno index used
425: */
426: INSERT INTO qp_npreq_line_attrs_tmp
427: (LINE_INDEX
428: , LINE_DETAIL_INDEX
429: , ATTRIBUTE_LEVEL
430: , NO_QUALIFIERS_IN_GRP

Line 677: from qp_npreq_line_attrs_tmp

673: BEGIN
674: --determine the volume attribute on the linegrp modifier
675: select attribute
676: into l_lgrp_vol_attr
677: from qp_npreq_line_attrs_tmp
678: where line_detail_index = cl.line_detail_index
679: and context = QP_PREQ_GRP.G_PRIC_VOLUME_CONTEXT;
680:
681: IF l_debug = FND_API.G_TRUE THEN

Line 702: qp_npreq_line_attrs_tmp lattr

698: for cl1 in (select line.line_index, lattr.value_from,
699: line.parent_quantity, ldet.line_detail_index
700: from qp_npreq_ldets_tmp ldet,
701: qp_npreq_lines_tmp line,
702: qp_npreq_line_attrs_tmp lattr
703: where ldet.created_from_list_line_id = cl.created_from_list_line_id
704: and ldet.pricing_status_code = G_STATUS_NEW
705: and ldet.applied_flag = G_YES
706: and line.line_index = ldet.line_index

Line 763: --qp_npreq_line_attrs_tmp ldetattr, qp_npreq_line_attrs_tmp lattr,

759:
760: /*
761: for cl3 in (select sum(line.parent_quantity) lumpsum_qty
762: from qp_npreq_lines_tmp line
763: --qp_npreq_line_attrs_tmp ldetattr, qp_npreq_line_attrs_tmp lattr,
764: where ldetattr.line_index = cl.line_index
765: and line.priced_uom_code <> line.line_uom_code
766: and ldetattr.context = QP_PREQ_GRP.G_PRIC_VOLUME_CONTEXT
767: and ldetattr.line_detail_index = cl.line_detail_index

Line 2837: qp_npreq_line_attrs_tmp gsa_attr

2833:
2834: CURSOR l_check_gsa_ind_cur IS
2835: SELECT 'Y'
2836: FROM qp_npreq_lines_tmp line,
2837: qp_npreq_line_attrs_tmp gsa_attr
2838: WHERE gsa_attr.line_index = line.line_index
2839: AND gsa_attr.pricing_status_code = G_STATUS_UNCHANGED
2840: AND gsa_attr.attribute_type = G_QUALIFIER_TYPE
2841: AND gsa_attr.context = G_CUSTOMER_CONTEXT

Line 2886: qp_npreq_line_attrs_tmp lattr,

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
2889: WHERE lattr.line_index = line.line_index
2890: AND lattr.pricing_status_code IN

Line 2931: qp_npreq_line_attrs_tmp lattr,

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
2934: WHERE lattr.line_index = line.line_index
2935: AND lattr.pricing_status_code IN

Line 9188: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N2,LINE_TYPE_CODE,1

9184:
9185: END IF;
9186: /*
9187: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_lines_tmp_N2,LINE_TYPE_CODE,1
9188: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N2,LINE_TYPE_CODE,1
9189: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
9190: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
9191: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
9192: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2

Line 9189: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1

9185: END IF;
9186: /*
9187: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_lines_tmp_N2,LINE_TYPE_CODE,1
9188: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N2,LINE_TYPE_CODE,1
9189: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
9190: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
9191: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
9192: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
9193: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3

Line 9190: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2

9186: /*
9187: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_lines_tmp_N2,LINE_TYPE_CODE,1
9188: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N2,LINE_TYPE_CODE,1
9189: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
9190: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
9191: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
9192: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
9193: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
9194: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4

Line 9222: FROM qp_npreq_line_attrs_tmp gsa_attr

9218: --made this change look at only successful lines
9219: AND line.pricing_status_code IN
9220: (G_STATUS_UPDATED, G_STATUS_UNCHANGED)
9221: AND NOT EXISTS (SELECT 'X'
9222: FROM qp_npreq_line_attrs_tmp gsa_attr
9223: WHERE gsa_attr.line_index = line.line_index
9224: --fix for bug 2080187
9225: AND gsa_attr.pricing_status_code = G_STATUS_UNCHANGED
9226: AND gsa_attr.attribute_type = G_QUALIFIER_TYPE

Line 9233: FROM qp_npreq_line_attrs_tmp lattr,

9229: AND gsa_attr.value_from = G_YES)
9230: AND line.adjusted_unit_price <=
9231: --(SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) */ MIN(ql.operand) -- 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

Line 9276: FROM qp_npreq_line_attrs_tmp gsa_attr

9272: --made this change look at only successful lines
9273: AND line.pricing_status_code IN
9274: (G_STATUS_UPDATED, G_STATUS_UNCHANGED)
9275: AND NOT EXISTS (SELECT 'X'
9276: FROM qp_npreq_line_attrs_tmp gsa_attr
9277: WHERE gsa_attr.line_index = line.line_index
9278: --fix for bug 2080187
9279: AND gsa_attr.pricing_status_code = G_STATUS_UNCHANGED
9280: AND gsa_attr.attribute_type = G_QUALIFIER_TYPE

Line 9287: FROM qp_npreq_line_attrs_tmp lattr,

9283: AND gsa_attr.value_from = G_YES)
9284: AND line.adjusted_unit_price <=
9285: --(SELECT /*+ ORDERED USE_NL(qpa ql req lhdr) */ MIN(ql.operand) --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

Line 10153: qp_npreq_line_attrs_tmp attr

10149: FROM qp_npreq_lines_tmp line,
10150: qp_npreq_rltd_lines_tmp rltd,
10151: qp_npreq_ldets_tmp ldet,
10152: qp_pricing_attributes qpa,
10153: qp_npreq_line_attrs_tmp attr
10154: WHERE line.pricing_status_code IN (G_STATUS_UNCHANGED, G_STATUS_UPDATED)
10155: AND line.price_flag = G_CALCULATE_ONLY
10156: AND nvl(line.processing_order, 1) = p_processing_order
10157: AND line.usage_pricing_type = QP_PREQ_GRP.G_BILLING_TYPE

Line 11487: , qp_npreq_line_attrs_tmp oldfreeitem

11483: FROM qp_npreq_lines_tmp oldfreeline
11484: , qp_npreq_rltd_lines_tmp newrltd
11485: , qp_npreq_ldets_tmp newfgdis
11486: , qp_npreq_lines_tmp newfgline
11487: , qp_npreq_line_attrs_tmp oldfreeitem
11488: , qp_npreq_line_attrs_tmp newfgitem
11489: --where G_REQUEST_TYPE_CODE = 'ONT'
11490: --bug 3085453 handle pricing availability UI
11491: -- they pass reqtype ONT and insert adj into ldets

Line 11488: , qp_npreq_line_attrs_tmp newfgitem

11484: , qp_npreq_rltd_lines_tmp newrltd
11485: , qp_npreq_ldets_tmp newfgdis
11486: , qp_npreq_lines_tmp newfgline
11487: , qp_npreq_line_attrs_tmp oldfreeitem
11488: , qp_npreq_line_attrs_tmp newfgitem
11489: --where G_REQUEST_TYPE_CODE = 'ONT'
11490: --bug 3085453 handle pricing availability UI
11491: -- they pass reqtype ONT and insert adj into ldets
11492: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = G_YES

Line 11611: , qp_npreq_line_attrs_tmp newfgitem

11607: FROM qp_npreq_lines_tmp oldfreeline
11608: , qp_npreq_rltd_lines_tmp newrltd
11609: , qp_npreq_ldets_tmp newfgdis
11610: , qp_npreq_lines_tmp newfgline
11611: , qp_npreq_line_attrs_tmp newfgitem
11612: , qp_npreq_line_attrs_tmp oldfreeitem
11613: --WHERE G_REQUEST_TYPE_CODE <> 'ONT'
11614: --bug 3085453 handle pricing availability UI
11615: -- they pass reqtype ONT and insert adj into ldets

Line 11612: , qp_npreq_line_attrs_tmp oldfreeitem

11608: , qp_npreq_rltd_lines_tmp newrltd
11609: , qp_npreq_ldets_tmp newfgdis
11610: , qp_npreq_lines_tmp newfgline
11611: , qp_npreq_line_attrs_tmp newfgitem
11612: , qp_npreq_line_attrs_tmp oldfreeitem
11613: --WHERE G_REQUEST_TYPE_CODE <> 'ONT'
11614: --bug 3085453 handle pricing availability UI
11615: -- they pass reqtype ONT and insert adj into ldets
11616: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG <> G_YES

Line 11944: --, qp_npreq_line_attrs_tmp newfgitem <-- commented out, sql repos

11940: UPDATE qp_npreq_lines_tmp oldfgline
11941: SET oldfgline.process_status = G_STATUS_DELETED
11942: WHERE NOT EXISTS (SELECT newprg.line_index
11943: FROM qp_npreq_ldets_tmp newprg
11944: --, qp_npreq_line_attrs_tmp newfgitem <-- commented out, sql repos
11945: WHERE --G_REQUEST_TYPE_CODE = 'ONT'
11946: newprg.pricing_status_code = G_STATUS_NEW
11947: AND newprg.applied_flag = G_YES
11948: AND instr(oldfgline.process_status

Line 12524: FROM qp_npreq_ldets_tmp ldet, qp_npreq_line_attrs_tmp lattr, qp_list_lines qpl

12520: , ldet.accrual_flag
12521: , qpl.accrual_conversion_rate
12522: , qpl.estim_accrual_rate
12523: -- , qpl.benefit_qty
12524: FROM qp_npreq_ldets_tmp ldet, qp_npreq_line_attrs_tmp lattr, qp_list_lines qpl
12525: WHERE ldet.pricing_phase_id > 1
12526: AND ldet.pricing_status_code = G_STATUS_NEW
12527: AND ldet.line_index > -1
12528: AND ldet.created_from_list_line_type IN ('DIS', 'SUR', 'FREIGHT_CHARGE',