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.OE_ORDER_PRICE_PVT dependencies on QP_PREQ_LINES_TMP

Line 208: qp_preq_lines_tmp b,

204: Cursor list_lines_no is
205: Select c.name,
206: a.list_line_no
207: From qp_preq_ldets_tmp a,
208: qp_preq_lines_tmp b,
209: qp_list_headers_vl c
210: Where b.line_id = p_line_id
211: And b.line_index = a.line_index
212: And a.created_from_list_header_id = c.list_header_id

Line 2308: select /+ INDEX(lines qp_preq_lines_tmp_n1) /

2304: l_line_rec := px_line_tbl(l_line_index);
2305: oe_debug_pub.add('Ord Qty:'||l_line_rec.ordered_quantity, 3 ) ;
2306: if l_line_rec.ordered_quantity <> 0 then --bug 2823498
2307: BEGIN
2308: select /*+ INDEX(lines qp_preq_lines_tmp_n1) */
2309: nvl(lines.order_uom_selling_price, lines.ADJUSTED_UNIT_PRICE * nvl(lines.priced_quantity,l_line_rec.ordered_quantity)/l_line_rec.ordered_quantity)
2310: , nvl(lines.line_unit_price, lines.UNIT_PRICE * nvl(lines.priced_quantity,l_line_rec.ordered_quantity)/l_line_rec.ordered_quantity)
2311: , lines.ADJUSTED_UNIT_PRICE
2312: , lines.UNIT_PRICE

Line 2333: from qp_preq_lines_tmp lines

2329: , l_line_rec.PRICE_LIST_ID
2330: , l_line_rec.UNIT_LIST_PERCENT
2331: , l_line_rec.UNIT_PERCENT_BASE_PRICE
2332: , l_line_rec.UNIT_SELLING_PERCENT
2333: from qp_preq_lines_tmp lines
2334: where lines.line_id=l_line_rec.line_id
2335: and lines.line_type_code='LINE'
2336: and lines.process_status <> 'NOT_VALID'
2337: and lines.pricing_status_code in

Line 2460: select /+ INDEX(lines qp_preq_lines_tmp_n1) /

2456: ,p_source_document_line_id => l_line_rec.source_document_line_id
2457: ,p_order_source_id => l_line_rec.order_source_id
2458: ,p_source_document_type_id => l_line_rec.source_document_type_id);
2459: BEGIN
2460: select /*+ INDEX(lines qp_preq_lines_tmp_n1) */
2461: nvl(lines.order_uom_selling_price, lines.ADJUSTED_UNIT_PRICE * nvl(lines.priced_quantity,l_line_rec.ordered_quantity)/l_line_rec.ordered_quantity)
2462: , nvl(lines.line_unit_price, lines.UNIT_PRICE * lines.priced_quantity/l_line_rec.ordered_quantity)
2463: , lines.ADJUSTED_UNIT_PRICE
2464: , lines.UNIT_PRICE

Line 2485: from qp_preq_lines_tmp lines

2481: , l_line_rec.PRICE_LIST_ID
2482: , l_line_rec.UNIT_LIST_PERCENT
2483: , l_line_rec.UNIT_PERCENT_BASE_PRICE
2484: , l_line_rec.UNIT_SELLING_PERCENT
2485: from qp_preq_lines_tmp lines
2486: where lines.line_id=l_line_rec.line_id
2487: and lines.line_type_code='LINE'
2488: and l_line_rec.ordered_quantity <> 0
2489: and lines.process_status <> 'NOT_VALID'

Line 2627: FROM QP_PREQ_LINES_TMP ql

2623: l_gsa_released varchar2(1) := 'N';
2624: --bug 2028480 end
2625: CURSOR gsa_violators IS
2626: SELECT ql.LINE_ID, l.ordered_item, l.inventory_item_id, ql.pricing_status_text
2627: FROM QP_PREQ_LINES_TMP ql
2628: , OE_ORDER_LINES l
2629: WHERE ql.line_id=l.line_id
2630: AND ql.LINE_TYPE_CODE='LINE'
2631: AND ql.PROCESS_STATUS <> 'NOT_VALID'

Line 2637: SELECT LINE_ID FROM QP_PREQ_LINES_TMP

2633: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
2634: AND l.ITEM_TYPE_CODE NOT IN ('INCLUDED','CONFIG')
2635: AND l.TRANSACTION_PHASE_CODE ='F'; -- Bug 6617462;
2636: CURSOR updated_lines IS
2637: SELECT LINE_ID FROM QP_PREQ_LINES_TMP
2638: WHERE LINE_TYPE_CODE='LINE'
2639: AND PROCESS_STATUS <> 'NOT_VALID'
2640: AND PRICING_STATUS_CODE = (QP_PREQ_GRP.G_STATUS_UPDATED);
2641: --

Line 2866: from qp_preq_lines_tmp

2862: THEN
2863:
2864: --bug 9777018 : Start
2865: select price_request_code into l_price_request_code
2866: from qp_preq_lines_tmp
2867: where line_type_code='ORDER' and line_id=px_header_rec.header_id;
2868:
2869: oe_debug_pub.add(' l_price_request_code = '|| l_price_request_code);
2870:

Line 2938: FROM QP_PREQ_LINES_TMP lines

2934: , l.inventory_item_id
2935: , l.sold_to_org_id
2936: , l.transaction_phase_code--for bug 3108881
2937: , l.order_source_id
2938: FROM QP_PREQ_LINES_TMP lines
2939: , OE_ORDER_LINES l
2940: WHERE lines.pricing_status_code IN
2941: ( QP_PREQ_GRP.G_STATUS_UPDATED
2942: , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 3307: FROM qp_preq_lines_tmp

3303: END IF;
3304: BEGIN
3305: SELECT processed_flag
3306: INTO l_order_adj_changed_flag
3307: FROM qp_preq_lines_tmp
3308: WHERE line_type_code='ORDER' and price_flag='Y';
3309: IF l_debug_level > 0 THEN
3310: oe_debug_pub.add( 'ORDER ADJ CHANGED:'||L_ORDER_ADJ_CHANGED_FLAG ) ;
3311: END IF;

Line 3400: from qp_preq_lines_tmp lines

3396: FROM oe_order_lines_all
3397: WHERE ordered_quantity <> 0
3398: AND open_flag <> 'N'
3399: AND line_id in (select line_id
3400: from qp_preq_lines_tmp lines
3401: where lines.pricing_status_code in
3402: (QP_PREQ_GRP.G_STATUS_UPDATED,
3403: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
3404: )

Line 3469: from qp_preq_lines_tmp lines

3465: , l.lock_control + 1
3466: , SYSDATE
3467: , FND_GLOBAL.USER_ID
3468: , FND_GLOBAL.LOGIN_ID
3469: from qp_preq_lines_tmp lines
3470: where lines.line_id=l.line_id
3471: and l.open_flag <> 'N'
3472: and lines.line_type_code='LINE'
3473: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 3481: and l.line_id in (select line_id from qp_preq_lines_tmp lines

3477: --l.header_id=oe_order_pub.g_hdr.header_id
3478: --and
3479: l.ordered_quantity <> 0
3480: and l.open_flag <> 'N'
3481: and l.line_id in (select line_id from qp_preq_lines_tmp lines
3482: where
3483: lines.pricing_status_code in
3484: (QP_PREQ_GRP.G_STATUS_UPDATED,
3485: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 3739: select line_id, price_flag, line_index from qp_preq_lines_tmp

3735: IS
3736:
3737: l_line_type_code varchar2(6);
3738: cursor updated_order_lines(l_line_type_code in varchar2) is
3739: select line_id, price_flag, line_index from qp_preq_lines_tmp
3740: where price_flag IN ('Y','P')
3741: and line_type_code = l_line_type_code
3742: and process_status <> 'NOT_VALID'
3743: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED

Line 3838: from qp_preq_lines_tmp

3834: select line_id,
3835: price_flag
3836: into l_line_id,
3837: l_price_flag
3838: from qp_preq_lines_tmp
3839: where line_id = p_line_id
3840: and line_type_code = 'LINE'
3841: and price_flag in ('Y', 'P')
3842: and process_status <> 'NOT_VALID'

Line 4076: Select /+ ORDERED USE_NL(ADJ LDETS) index(QPLINES QP_PREQ_LINES_TMP_N2) index(ADJ OE_PRICE_ADJUSTMENTS_N2)/

4072: i number;
4073: l_pricing_events varchar2(40) := p_pricing_events||',';
4074: l_stmt number:=0;
4075: cursor del_attribs1 Is
4076: Select /*+ ORDERED USE_NL(ADJ LDETS) index(QPLINES QP_PREQ_LINES_TMP_N2) index(ADJ OE_PRICE_ADJUSTMENTS_N2)*/
4077: adj.price_adjustment_id, ldets.line_detail_index
4078: From QP_PREQ_LINES_TMP QPLINES
4079: ,OE_PRICE_ADJUSTMENTS ADJ
4080: ,QP_LDETS_V LDETS

Line 4078: From QP_PREQ_LINES_TMP QPLINES

4074: l_stmt number:=0;
4075: cursor del_attribs1 Is
4076: Select /*+ ORDERED USE_NL(ADJ LDETS) index(QPLINES QP_PREQ_LINES_TMP_N2) index(ADJ OE_PRICE_ADJUSTMENTS_N2)*/
4077: adj.price_adjustment_id, ldets.line_detail_index
4078: From QP_PREQ_LINES_TMP QPLINES
4079: ,OE_PRICE_ADJUSTMENTS ADJ
4080: ,QP_LDETS_V LDETS
4081: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4082: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX

Line 4148: , QP_PREQ_LINES_TMP lines

4144: ldets.include_on_returns_flag,
4145: adj.lock_control + 1 adj_lock_control
4146: from OE_PRICE_ADJUSTMENTS adj
4147: , QP_LDETS_v ldets
4148: , QP_PREQ_LINES_TMP lines
4149: WHERE
4150: adj.header_id=oe_order_pub.g_hdr.header_id
4151: and lines.line_index = ldets.line_index
4152: and lines.process_status <> 'NOT_VALID'

Line 4194: , QP_PREQ_LINES_TMP lines

4190: ldets.include_on_returns_flag,
4191: adj.lock_control + 1 adj_lock_control
4192: from OE_PRICE_ADJUSTMENTS adj
4193: , QP_LDETS_v ldets
4194: , QP_PREQ_LINES_TMP lines
4195: WHERE
4196: adj.header_id=oe_order_pub.g_hdr.header_id
4197: and lines.line_index = ldets.line_index
4198: and lines.process_status <> 'NOT_VALID'

Line 4210: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2

4206:
4207: --bug 3836854
4208: Cursor upd_adj(l_line_type IN Varchar2) Is
4209: select ldets2.price_adjustment_id, ldets2.line_detail_index
4210: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
4211: where ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
4212: AND lines2.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4213: and lines2.process_status <> 'NOT_VALID'
4214: and lines2.line_index = ldets2.line_index

Line 4246: qp_preq_lines_tmp

4242: l_hdr_line_index,
4243: l_hdr_line_id,
4244: l_hdr_pricing_status_code
4245: from
4246: qp_preq_lines_tmp
4247: where line_type_code = 'ORDER'
4248: and process_status <> 'NOT_VALID';
4249: EXCEPTION
4250: WHEN NO_DATA_FOUND THEN

Line 4581: , QP_PREQ_LINES_TMP lines

4577: , ldets.adjustment_amount
4578: , 1
4579: FROM
4580: QP_LDETS_v ldets
4581: , QP_PREQ_LINES_TMP lines
4582: , QP_LIST_HEADERS_B QH
4583: WHERE
4584: ldets.list_header_id=qh.list_header_id
4585: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 4639: QP_PREQ_LINES_TMP QPL

4635: ,1
4636: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,
4637: OE_PRICE_ADJUSTMENTS ADJ,
4638: OE_PRICE_ADJUSTMENTS RADJ,
4639: QP_PREQ_LINES_TMP QPL
4640: WHERE
4641: ADJ.HEADER_ID = RLTD.LINE_INDEX AND
4642: ADJ.LIST_LINE_ID = RLTD.LIST_LINE_ID AND
4643: RADJ.HEADER_ID = RLTD.RELATED_LINE_INDEX AND

Line 4684: QP_PREQ_LINES_TMP QPL,

4680: ,RADJ.PRICE_ADJUSTMENT_ID
4681: ,1
4682: FROM
4683: QP_PREQ_RLTD_LINES_TMP RLTD,
4684: QP_PREQ_LINES_TMP QPL,
4685: OE_PRICE_ADJUSTMENTS ADJ,
4686: OE_PRICE_ADJUSTMENTS RADJ
4687: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX AND
4688: QPL.LINE_ID = ADJ.LINE_ID AND

Line 4896: --, QP_PREQ_LINES_TMP QPL

4892: ,1
4893: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4894: --, QP_LDETS_v LDETS
4895: --, OE_PRICE_ADJUSTMENTS ADJ
4896: --, QP_PREQ_LINES_TMP QPL
4897: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4898: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4899: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4900: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

Line 4926: ,QP_PREQ_LINES_TMP QPLINES

4922: WHERE exists
4923: (Select ADJ.PRICE_ADJUSTMENT_ID
4924: From QP_LDETS_V LDETS
4925: ,OE_PRICE_ADJUSTMENTS ADJ
4926: ,QP_PREQ_LINES_TMP QPLINES
4927: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4928: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX
4929: AND QPLINES.LINE_TYPE_CODE = 'ORDER'
4930: AND QPLINES.LINE_ID = ADJ.HEADER_ID

Line 4939: ,QP_PREQ_LINES_TMP QPLINES

4935: WHERE exists
4936: (Select ADJ.PRICE_ADJUSTMENT_ID
4937: From QP_LDETS_V LDETS
4938: ,OE_PRICE_ADJUSTMENTS ADJ
4939: ,QP_PREQ_LINES_TMP QPLINES
4940: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4941: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX
4942: AND QPLINES.LINE_ID = ADJ.LINE_ID
4943: AND QPLINES.LINE_TYPE_CODE = 'LINE'

Line 5049: , QP_PREQ_LINES_TMP QPLINE

5045: ,1
5046: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5047: , QP_LDETS_v LDETS
5048: , OE_PRICE_ADJUSTMENTS ADJ
5049: , QP_PREQ_LINES_TMP QPLINE
5050: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
5051: -- AND QPLAT.LINE_INDEX = ADJ.HEADER_ID+nvl(ADJ.LINE_ID,0)
5052: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
5053: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

Line 5109: , QP_PREQ_LINES_TMP QPLINE

5105: ,1
5106: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5107: , QP_PREQ_LDETS_TMP LDETS
5108: , OE_PRICE_ADJUSTMENTS ADJ
5109: , QP_PREQ_LINES_TMP QPLINE
5110: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
5111: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
5112: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
5113: AND LDETS.CREATED_FROM_LIST_LINE_ID=ADJ.LIST_LINE_ID

Line 6254: --DELETE FROM QP_PREQ_LINES_TMP;

6250: oe_debug_pub.add('Entering oe_order_price_pvt.calulate_adjustments', 0.5); -- debug level changed to 0.5 for bug 13435459
6251: END IF;
6252:
6253: reset_all_tbls;
6254: --DELETE FROM QP_PREQ_LINES_TMP;
6255: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;
6256: --DELETE FROM QP_PREQ_LDETS_TMP;
6257: --DELETE FROM QP_PREQ_QUAL_TMP;
6258: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;

Line 7159: from qp_preq_lines_tmp

7155: l_list_line_no Varchar2(2000);
7156: --bug 3696768
7157: cursor reset_ipl_tbl is
7158: select line_id
7159: from qp_preq_lines_tmp
7160: where pricing_status_code <> QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST;
7161: --bug 3696768
7162: cursor wrong_lines is
7163: select line_id

Line 7174: from qp_preq_lines_tmp

7170: , adjusted_unit_price
7171: , priced_quantity
7172: , line_quantity
7173: , priced_uom_code
7174: from qp_preq_lines_tmp
7175: where process_status <> 'NOT_VALID' and
7176: (pricing_status_code not in
7177: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
7178: QP_PREQ_GRP.G_STATUS_UPDATED,

Line 7193: , qp_preq_lines_tmp lines

7189: , l.shipped_quantity
7190: , l.header_id
7191: , lines.line_index
7192: from oe_order_lines l
7193: , qp_preq_lines_tmp lines
7194: where lines.line_id = l.line_id
7195: and lines.line_type_code='LINE'
7196: and l.booked_flag = 'Y'
7197: and l.item_type_code NOT IN ('INCLUDED','CONFIG')