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 2827: qp_npreq_line_attrs_tmp gsa_attr

2823:
2824: CURSOR l_check_gsa_ind_cur IS
2825: SELECT 'Y'
2826: FROM qp_npreq_lines_tmp line,
2827: qp_npreq_line_attrs_tmp gsa_attr
2828: WHERE gsa_attr.line_index = line.line_index
2829: AND gsa_attr.pricing_status_code = G_STATUS_UNCHANGED
2830: AND gsa_attr.attribute_type = G_QUALIFIER_TYPE
2831: AND gsa_attr.context = G_CUSTOMER_CONTEXT

Line 2876: qp_npreq_line_attrs_tmp lattr,

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
2880: AND lattr.pricing_status_code IN

Line 2921: qp_npreq_line_attrs_tmp lattr,

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
2925: AND lattr.pricing_status_code IN

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

9107:
9108: END IF;
9109: /*
9110: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_lines_tmp_N2,LINE_TYPE_CODE,1
9111: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N2,LINE_TYPE_CODE,1
9112: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
9113: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
9114: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
9115: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2

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

9108: END IF;
9109: /*
9110: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_lines_tmp_N2,LINE_TYPE_CODE,1
9111: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N2,LINE_TYPE_CODE,1
9112: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
9113: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
9114: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
9115: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
9116: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3

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

9109: /*
9110: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_lines_tmp_N2,LINE_TYPE_CODE,1
9111: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N2,LINE_TYPE_CODE,1
9112: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
9113: INDX,QP_PREQ_PUB.calculate_price.upd5,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
9114: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
9115: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
9116: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
9117: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4

Line 9145: FROM qp_npreq_line_attrs_tmp gsa_attr

9141: --made this change look at only successful lines
9142: AND line.pricing_status_code IN
9143: (G_STATUS_UPDATED, G_STATUS_UNCHANGED)
9144: AND NOT EXISTS (SELECT 'X'
9145: FROM qp_npreq_line_attrs_tmp gsa_attr
9146: WHERE gsa_attr.line_index = line.line_index
9147: --fix for bug 2080187
9148: AND gsa_attr.pricing_status_code = G_STATUS_UNCHANGED
9149: AND gsa_attr.attribute_type = G_QUALIFIER_TYPE

Line 9156: FROM qp_npreq_line_attrs_tmp lattr,

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
9160: qp_list_lines ql

Line 9199: FROM qp_npreq_line_attrs_tmp gsa_attr

9195: --made this change look at only successful lines
9196: AND line.pricing_status_code IN
9197: (G_STATUS_UPDATED, G_STATUS_UNCHANGED)
9198: AND NOT EXISTS (SELECT 'X'
9199: FROM qp_npreq_line_attrs_tmp gsa_attr
9200: WHERE gsa_attr.line_index = line.line_index
9201: --fix for bug 2080187
9202: AND gsa_attr.pricing_status_code = G_STATUS_UNCHANGED
9203: AND gsa_attr.attribute_type = G_QUALIFIER_TYPE

Line 9210: FROM qp_npreq_line_attrs_tmp lattr,

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
9214: qp_list_lines ql

Line 10074: qp_npreq_line_attrs_tmp attr

10070: FROM qp_npreq_lines_tmp line,
10071: qp_npreq_rltd_lines_tmp rltd,
10072: qp_npreq_ldets_tmp ldet,
10073: qp_pricing_attributes qpa,
10074: qp_npreq_line_attrs_tmp attr
10075: WHERE line.pricing_status_code IN (G_STATUS_UNCHANGED, G_STATUS_UPDATED)
10076: AND line.price_flag = G_CALCULATE_ONLY
10077: AND nvl(line.processing_order, 1) = p_processing_order
10078: AND line.usage_pricing_type = QP_PREQ_GRP.G_BILLING_TYPE

Line 11355: , qp_npreq_line_attrs_tmp oldfreeitem

11351: FROM qp_npreq_lines_tmp oldfreeline
11352: , qp_npreq_rltd_lines_tmp newrltd
11353: , qp_npreq_ldets_tmp newfgdis
11354: , qp_npreq_lines_tmp newfgline
11355: , qp_npreq_line_attrs_tmp oldfreeitem
11356: , qp_npreq_line_attrs_tmp newfgitem
11357: --where G_REQUEST_TYPE_CODE = 'ONT'
11358: --bug 3085453 handle pricing availability UI
11359: -- they pass reqtype ONT and insert adj into ldets

Line 11356: , qp_npreq_line_attrs_tmp newfgitem

11352: , qp_npreq_rltd_lines_tmp newrltd
11353: , qp_npreq_ldets_tmp newfgdis
11354: , qp_npreq_lines_tmp newfgline
11355: , qp_npreq_line_attrs_tmp oldfreeitem
11356: , qp_npreq_line_attrs_tmp newfgitem
11357: --where G_REQUEST_TYPE_CODE = 'ONT'
11358: --bug 3085453 handle pricing availability UI
11359: -- they pass reqtype ONT and insert adj into ldets
11360: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = G_YES

Line 11475: , qp_npreq_line_attrs_tmp newfgitem

11471: FROM qp_npreq_lines_tmp oldfreeline
11472: , qp_npreq_rltd_lines_tmp newrltd
11473: , qp_npreq_ldets_tmp newfgdis
11474: , qp_npreq_lines_tmp newfgline
11475: , qp_npreq_line_attrs_tmp newfgitem
11476: , qp_npreq_line_attrs_tmp oldfreeitem
11477: --WHERE G_REQUEST_TYPE_CODE <> 'ONT'
11478: --bug 3085453 handle pricing availability UI
11479: -- they pass reqtype ONT and insert adj into ldets

Line 11476: , qp_npreq_line_attrs_tmp oldfreeitem

11472: , qp_npreq_rltd_lines_tmp newrltd
11473: , qp_npreq_ldets_tmp newfgdis
11474: , qp_npreq_lines_tmp newfgline
11475: , qp_npreq_line_attrs_tmp newfgitem
11476: , qp_npreq_line_attrs_tmp oldfreeitem
11477: --WHERE G_REQUEST_TYPE_CODE <> 'ONT'
11478: --bug 3085453 handle pricing availability UI
11479: -- they pass reqtype ONT and insert adj into ldets
11480: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG <> G_YES

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

11800: UPDATE qp_npreq_lines_tmp oldfgline
11801: SET oldfgline.process_status = G_STATUS_DELETED
11802: WHERE NOT EXISTS (SELECT newprg.line_index
11803: FROM qp_npreq_ldets_tmp newprg
11804: --, qp_npreq_line_attrs_tmp newfgitem <-- commented out, sql repos
11805: WHERE --G_REQUEST_TYPE_CODE = 'ONT'
11806: newprg.pricing_status_code = G_STATUS_NEW
11807: AND newprg.applied_flag = G_YES
11808: AND instr(oldfgline.process_status

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

12363: , ldet.accrual_flag
12364: , qpl.accrual_conversion_rate
12365: , qpl.estim_accrual_rate
12366: -- , qpl.benefit_qty
12367: FROM qp_npreq_ldets_tmp ldet, qp_npreq_line_attrs_tmp lattr, qp_list_lines qpl
12368: WHERE ldet.pricing_phase_id > 1
12369: AND ldet.pricing_status_code = G_STATUS_NEW
12370: AND ldet.line_index > -1
12371: AND ldet.created_from_list_line_type IN ('DIS', 'SUR', 'FREIGHT_CHARGE',