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 207: qp_preq_lines_tmp b,

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

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

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

Line 2332: from qp_preq_lines_tmp lines

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

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

2449: ,p_source_document_line_id => l_line_rec.source_document_line_id
2450: ,p_order_source_id => l_line_rec.order_source_id
2451: ,p_source_document_type_id => l_line_rec.source_document_type_id);
2452: BEGIN
2453: select /*+ INDEX(lines qp_preq_lines_tmp_n1) */
2454: nvl(lines.order_uom_selling_price, lines.ADJUSTED_UNIT_PRICE * nvl(lines.priced_quantity,l_line_rec.ordered_quantity)/l_line_rec.ordered_quantity)
2455: , nvl(lines.line_unit_price, lines.UNIT_PRICE * lines.priced_quantity/l_line_rec.ordered_quantity)
2456: , lines.ADJUSTED_UNIT_PRICE
2457: , lines.UNIT_PRICE

Line 2478: from qp_preq_lines_tmp lines

2474: , l_line_rec.PRICE_LIST_ID
2475: , l_line_rec.UNIT_LIST_PERCENT
2476: , l_line_rec.UNIT_PERCENT_BASE_PRICE
2477: , l_line_rec.UNIT_SELLING_PERCENT
2478: from qp_preq_lines_tmp lines
2479: where lines.line_id=l_line_rec.line_id
2480: and lines.line_type_code='LINE'
2481: and l_line_rec.ordered_quantity <> 0
2482: and lines.process_status <> 'NOT_VALID'

Line 2620: FROM QP_PREQ_LINES_TMP ql

2616: l_gsa_released varchar2(1) := 'N';
2617: --bug 2028480 end
2618: CURSOR gsa_violators IS
2619: SELECT ql.LINE_ID, l.ordered_item, l.inventory_item_id, ql.pricing_status_text
2620: FROM QP_PREQ_LINES_TMP ql
2621: , OE_ORDER_LINES l
2622: WHERE ql.line_id=l.line_id
2623: AND ql.LINE_TYPE_CODE='LINE'
2624: AND ql.PROCESS_STATUS <> 'NOT_VALID'

Line 2630: SELECT LINE_ID FROM QP_PREQ_LINES_TMP

2626: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
2627: AND l.ITEM_TYPE_CODE NOT IN ('INCLUDED','CONFIG')
2628: AND l.TRANSACTION_PHASE_CODE ='F'; -- Bug 6617462;
2629: CURSOR updated_lines IS
2630: SELECT LINE_ID FROM QP_PREQ_LINES_TMP
2631: WHERE LINE_TYPE_CODE='LINE'
2632: AND PROCESS_STATUS <> 'NOT_VALID'
2633: AND PRICING_STATUS_CODE = (QP_PREQ_GRP.G_STATUS_UPDATED);
2634: --

Line 2858: from qp_preq_lines_tmp

2854:
2855: update oe_order_headers
2856: set price_request_code
2857: = (select price_request_code
2858: from qp_preq_lines_tmp
2859: where line_type_code='ORDER'
2860: and line_id=px_header_rec.header_id);
2861: oe_debug_pub.add('done updating header');
2862: END IF;

Line 2917: FROM QP_PREQ_LINES_TMP lines

2913: , l.inventory_item_id
2914: , l.sold_to_org_id
2915: , l.transaction_phase_code--for bug 3108881
2916: , l.order_source_id
2917: FROM QP_PREQ_LINES_TMP lines
2918: , OE_ORDER_LINES l
2919: WHERE lines.pricing_status_code IN
2920: ( QP_PREQ_GRP.G_STATUS_UPDATED
2921: , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 3285: FROM qp_preq_lines_tmp

3281: END IF;
3282: BEGIN
3283: SELECT processed_flag
3284: INTO l_order_adj_changed_flag
3285: FROM qp_preq_lines_tmp
3286: WHERE line_type_code='ORDER' and price_flag='Y';
3287: IF l_debug_level > 0 THEN
3288: oe_debug_pub.add( 'ORDER ADJ CHANGED:'||L_ORDER_ADJ_CHANGED_FLAG ) ;
3289: END IF;

Line 3399: from qp_preq_lines_tmp lines

3395: , l.lock_control + 1
3396: , SYSDATE
3397: , FND_GLOBAL.USER_ID
3398: , FND_GLOBAL.LOGIN_ID
3399: from qp_preq_lines_tmp lines
3400: where lines.line_id=l.line_id
3401: and l.open_flag <> 'N'
3402: and lines.line_type_code='LINE'
3403: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

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

3407: --l.header_id=oe_order_pub.g_hdr.header_id
3408: --and
3409: l.ordered_quantity <> 0
3410: and l.open_flag <> 'N'
3411: and l.line_id in (select line_id from qp_preq_lines_tmp lines
3412: where
3413: lines.pricing_status_code in
3414: (QP_PREQ_GRP.G_STATUS_UPDATED,
3415: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 3625: select line_id, price_flag, line_index from qp_preq_lines_tmp

3621: IS
3622:
3623: l_line_type_code varchar2(6);
3624: cursor updated_order_lines(l_line_type_code in varchar2) is
3625: select line_id, price_flag, line_index from qp_preq_lines_tmp
3626: where price_flag IN ('Y','P')
3627: and line_type_code = l_line_type_code
3628: and process_status <> 'NOT_VALID'
3629: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED

Line 3723: from qp_preq_lines_tmp

3719: select line_id,
3720: price_flag
3721: into l_line_id,
3722: l_price_flag
3723: from qp_preq_lines_tmp
3724: where line_id = p_line_id
3725: and line_type_code = 'LINE'
3726: and price_flag in ('Y', 'P')
3727: and process_status <> 'NOT_VALID'

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

3957: i number;
3958: l_pricing_events varchar2(40) := p_pricing_events||',';
3959: l_stmt number:=0;
3960: cursor del_attribs1 Is
3961: Select /*+ ORDERED USE_NL(ADJ LDETS) index(QPLINES QP_PREQ_LINES_TMP_N2) index(ADJ OE_PRICE_ADJUSTMENTS_N2)*/
3962: adj.price_adjustment_id, ldets.line_detail_index
3963: From QP_PREQ_LINES_TMP QPLINES
3964: ,OE_PRICE_ADJUSTMENTS ADJ
3965: ,QP_LDETS_V LDETS

Line 3963: From QP_PREQ_LINES_TMP QPLINES

3959: l_stmt number:=0;
3960: cursor del_attribs1 Is
3961: Select /*+ ORDERED USE_NL(ADJ LDETS) index(QPLINES QP_PREQ_LINES_TMP_N2) index(ADJ OE_PRICE_ADJUSTMENTS_N2)*/
3962: adj.price_adjustment_id, ldets.line_detail_index
3963: From QP_PREQ_LINES_TMP QPLINES
3964: ,OE_PRICE_ADJUSTMENTS ADJ
3965: ,QP_LDETS_V LDETS
3966: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
3967: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX

Line 4033: , QP_PREQ_LINES_TMP lines

4029: ldets.include_on_returns_flag,
4030: adj.lock_control + 1 adj_lock_control
4031: from OE_PRICE_ADJUSTMENTS adj
4032: , QP_LDETS_v ldets
4033: , QP_PREQ_LINES_TMP lines
4034: WHERE
4035: adj.header_id=oe_order_pub.g_hdr.header_id
4036: and lines.line_index = ldets.line_index
4037: and lines.process_status <> 'NOT_VALID'

Line 4079: , QP_PREQ_LINES_TMP lines

4075: ldets.include_on_returns_flag,
4076: adj.lock_control + 1 adj_lock_control
4077: from OE_PRICE_ADJUSTMENTS adj
4078: , QP_LDETS_v ldets
4079: , QP_PREQ_LINES_TMP lines
4080: WHERE
4081: adj.header_id=oe_order_pub.g_hdr.header_id
4082: and lines.line_index = ldets.line_index
4083: and lines.process_status <> 'NOT_VALID'

Line 4095: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2

4091:
4092: --bug 3836854
4093: Cursor upd_adj(l_line_type IN Varchar2) Is
4094: select ldets2.price_adjustment_id, ldets2.line_detail_index
4095: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
4096: where ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
4097: 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)
4098: and lines2.process_status <> 'NOT_VALID'
4099: and lines2.line_index = ldets2.line_index

Line 4131: qp_preq_lines_tmp

4127: l_hdr_line_index,
4128: l_hdr_line_id,
4129: l_hdr_pricing_status_code
4130: from
4131: qp_preq_lines_tmp
4132: where line_type_code = 'ORDER'
4133: and process_status <> 'NOT_VALID';
4134: EXCEPTION
4135: WHEN NO_DATA_FOUND THEN

Line 4466: , QP_PREQ_LINES_TMP lines

4462: , ldets.adjustment_amount
4463: , 1
4464: FROM
4465: QP_LDETS_v ldets
4466: , QP_PREQ_LINES_TMP lines
4467: , QP_LIST_HEADERS_B QH
4468: WHERE
4469: ldets.list_header_id=qh.list_header_id
4470: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 4524: QP_PREQ_LINES_TMP QPL

4520: ,1
4521: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,
4522: OE_PRICE_ADJUSTMENTS ADJ,
4523: OE_PRICE_ADJUSTMENTS RADJ,
4524: QP_PREQ_LINES_TMP QPL
4525: WHERE
4526: ADJ.HEADER_ID = RLTD.LINE_INDEX AND
4527: ADJ.LIST_LINE_ID = RLTD.LIST_LINE_ID AND
4528: RADJ.HEADER_ID = RLTD.RELATED_LINE_INDEX AND

Line 4569: QP_PREQ_LINES_TMP QPL,

4565: ,RADJ.PRICE_ADJUSTMENT_ID
4566: ,1
4567: FROM
4568: QP_PREQ_RLTD_LINES_TMP RLTD,
4569: QP_PREQ_LINES_TMP QPL,
4570: OE_PRICE_ADJUSTMENTS ADJ,
4571: OE_PRICE_ADJUSTMENTS RADJ
4572: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX AND
4573: QPL.LINE_ID = ADJ.LINE_ID AND

Line 4781: --, QP_PREQ_LINES_TMP QPL

4777: ,1
4778: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4779: --, QP_LDETS_v LDETS
4780: --, OE_PRICE_ADJUSTMENTS ADJ
4781: --, QP_PREQ_LINES_TMP QPL
4782: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4783: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4784: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
4785: --AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

Line 4811: ,QP_PREQ_LINES_TMP QPLINES

4807: WHERE exists
4808: (Select ADJ.PRICE_ADJUSTMENT_ID
4809: From QP_LDETS_V LDETS
4810: ,OE_PRICE_ADJUSTMENTS ADJ
4811: ,QP_PREQ_LINES_TMP QPLINES
4812: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4813: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX
4814: AND QPLINES.LINE_TYPE_CODE = 'ORDER'
4815: AND QPLINES.LINE_ID = ADJ.HEADER_ID

Line 4824: ,QP_PREQ_LINES_TMP QPLINES

4820: WHERE exists
4821: (Select ADJ.PRICE_ADJUSTMENT_ID
4822: From QP_LDETS_V LDETS
4823: ,OE_PRICE_ADJUSTMENTS ADJ
4824: ,QP_PREQ_LINES_TMP QPLINES
4825: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4826: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX
4827: AND QPLINES.LINE_ID = ADJ.LINE_ID
4828: AND QPLINES.LINE_TYPE_CODE = 'LINE'

Line 4932: , QP_PREQ_LINES_TMP QPLINE

4928: ,1
4929: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4930: , QP_LDETS_v LDETS
4931: , OE_PRICE_ADJUSTMENTS ADJ
4932: , QP_PREQ_LINES_TMP QPLINE
4933: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4934: -- AND QPLAT.LINE_INDEX = ADJ.HEADER_ID+nvl(ADJ.LINE_ID,0)
4935: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4936: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

Line 5971: --DELETE FROM QP_PREQ_LINES_TMP;

5967: begin
5968: oe_debug_pub.add('Entering oe_order_price_pvt.calulate_adjustments', 1);
5969:
5970: reset_all_tbls;
5971: --DELETE FROM QP_PREQ_LINES_TMP;
5972: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;
5973: --DELETE FROM QP_PREQ_LDETS_TMP;
5974: --DELETE FROM QP_PREQ_QUAL_TMP;
5975: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;

Line 6880: from qp_preq_lines_tmp

6876: l_list_line_no Varchar2(2000);
6877: --bug 3696768
6878: cursor reset_ipl_tbl is
6879: select line_id
6880: from qp_preq_lines_tmp
6881: where pricing_status_code <> QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST;
6882: --bug 3696768
6883: cursor wrong_lines is
6884: select line_id

Line 6895: from qp_preq_lines_tmp

6891: , adjusted_unit_price
6892: , priced_quantity
6893: , line_quantity
6894: , priced_uom_code
6895: from qp_preq_lines_tmp
6896: where process_status <> 'NOT_VALID' and
6897: (pricing_status_code not in
6898: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
6899: QP_PREQ_GRP.G_STATUS_UPDATED,

Line 6914: , qp_preq_lines_tmp lines

6910: , l.shipped_quantity
6911: , l.header_id
6912: , lines.line_index
6913: from oe_order_lines l
6914: , qp_preq_lines_tmp lines
6915: where lines.line_id = l.line_id
6916: and lines.line_type_code='LINE'
6917: and l.booked_flag = 'Y'
6918: and l.item_type_code NOT IN ('INCLUDED','CONFIG')