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_ADV_PRICE_PVT dependencies on QP_PREQ_LINES_TMP

Line 262: QP_PREQ_LINES_TMP lines

258:
259: Cursor upgraded_items IS
260: SELECT ldets.line_detail_index,ldets.Line_index,ldets.related_item_id,lines.line_id
261: FROM QP_LDETS_V ldets,
262: QP_PREQ_LINES_TMP lines
263: WHERE ldets.list_line_Type_code /*created_from_list_line_type list_line_Type_code*/= 'IUE'
264: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW,
265: QP_PREQ_PUB.G_STATUS_UPDATED)
266: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 280: from qp_preq_lines_tmp where

276: AND list_line_Type_code = 'IUE'
277: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
278: where instr(p_pricing_events||',', pricing_event_code||',') >0)
279: AND LINE_ID IN (select line_id
280: from qp_preq_lines_tmp where
281: line_type_code='LINE'
282: and price_flag IN ('Y','P')
283: and process_status <> 'NOT_VALID'
284: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED, QP_PREQ_PUB.G_STATUS_GSA_VIOLATION, QP_PREQ_PUB.G_STATUS_UNCHANGED))

Line 289: from qp_ldets_v ld, qp_preq_lines_tmp l

285: /* AND list_line_id NOT IN (SELECT list_line_id
286: from qp_ldets_v where process_code
287: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and line_index=adj.line_id+oe_order_cache.g_header_rec.header_id)*/
288: AND list_line_id NOT IN (SELECT list_line_id
289: from qp_ldets_v ld, qp_preq_lines_tmp l
290: where ld.process_code
291: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index
292: and l.line_id = adj.line_id);
293:

Line 602: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

598: SELECT ldets.Line_index, ldets.line_detail_index, lines.line_id --bug 4190357 added line_detail_index
599: , ldets.substitution_attribute, ldets.substitution_value_to
600: ,CHANGE_REASON_CODE,CHANGE_REASON_TEXT
601: ,lines.line_type_code --bug 4190357
602: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
603: WHERE ldets.list_line_type_code = 'TSN'
604: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW
605: , QP_PREQ_PUB.G_STATUS_UPDATED
606: )

Line 984: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE

980: END Term_Substitution;
981:
982: Procedure Set_Prg(
983: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
984: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
985: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
986: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE

Line 985: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE

981:
982: Procedure Set_Prg(
983: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
984: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
985: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
986: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE

Line 986: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE

982: Procedure Set_Prg(
983: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
984: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
985: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
986: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE

Line 987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE

983: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
984: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
985: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
986: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE

Line 988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE

984: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
985: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
986: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE

Line 989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE

985: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
986: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE

Line 990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE

986: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
994: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE

Line 991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE

987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
994: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
995: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE

Line 992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE

988: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
994: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
995: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
996: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE

Line 993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE

989: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
994: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
995: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
996: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
997: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE

Line 994: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE

990: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
994: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
995: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
996: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
997: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
998: )

Line 995: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE

991: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
994: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
995: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
996: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
997: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
998: )
999: IS

Line 996: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE

992: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
994: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
995: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
996: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
997: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
998: )
999: IS
1000: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;

Line 997: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE

993: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
994: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
995: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
996: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
997: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
998: )
999: IS
1000: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1001: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 1234: UPDATE QP_PREQ_LINES_TMP

1230: END IF;
1231: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1232: BEGIN
1233: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110510' THEN
1234: UPDATE QP_PREQ_LINES_TMP
1235: SET PROCESS_STATUS='NOT_VALID'
1236: WHERE LINE_ID = l_line_rec.line_id;
1237: ELSE
1238: QP_UTIL_PUB.Update_Lines('MAKE_STATUS_INVALID',l_line_rec.line_id,

Line 1298: From qp_preq_lines_tmp

1294: , price_list_header_id
1295: , percent_price
1296: , priced_uom_code
1297: , price_request_code
1298: From qp_preq_lines_tmp
1299: where
1300: --processed_code = 'ENGINE';
1301: process_status IN (QP_PREQ_PUB.G_STATUS_NEW
1302: , QP_PREQ_PUB.G_STATUS_UPDATED

Line 1374: UPDATE QP_PREQ_LINES_TMP

1370: l_pricing_quantity := l_pricing_quantity - nvl(l_line_rec.cancelled_quantity, 0);
1371: IF nvl(l_line_rec.cancelled_quantity, 0) > 0 THEN
1372: BEGIN
1373: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110510' THEN
1374: UPDATE QP_PREQ_LINES_TMP
1375: SET PRICED_QUANTITY = l_pricing_quantity
1376: where line_id = l_line_rec.line_id;
1377: ELSE
1378: QP_UTIL_PUB.Update_Lines('UPDATE_PRICED_QUANTITY',l_line_rec.line_id,null,l_pricing_quantity);

Line 1428: UPDATE QP_PREQ_LINES_TMP

1424: --bug 4234500
1425:
1426: BEGIN
1427: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110510' THEN
1428: UPDATE QP_PREQ_LINES_TMP
1429: SET LINE_ID = l_line_rec.line_id
1430: where line_index = i.line_index;
1431: ELSE
1432: QP_UTIL_PUB.Update_Lines('UPDATE_LINE_ID', l_line_rec.line_id,

Line 1446: FROM qp_preq_lines_tmp

1442: AND relationship_type_code = 'GENERATED_LINE' and rownum=1;
1443:
1444: SELECT line_id
1445: INTO l_parent_line_id
1446: FROM qp_preq_lines_tmp
1447: WHERE line_index = l_parent_line_index;
1448:
1449: l_buy_line_rec := px_line_tbl(px_price_line_id_tbl(l_parent_line_id));
1450: If l_buy_line_rec.line_category_code = 'RETURN' and l_buy_line_rec.return_reason_code is Not Null Then

Line 1627: FROM QP_PREQ_LINES_TMP

1623: Procedure Process_Limits IS
1624:
1625: Cursor Hold_Lines IS
1626: SELECT line_index, line_id, line_Type_code, hold_code
1627: FROM QP_PREQ_LINES_TMP
1628: WHERE HOLD_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED);
1629:
1630: Cursor limit_violated_details IS
1631: SELECT ldets.line_index, ldets.limit_text, lines.line_id

Line 1632: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

1628: WHERE HOLD_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED);
1629:
1630: Cursor limit_violated_details IS
1631: SELECT ldets.line_index, ldets.limit_text, lines.line_id
1632: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
1633: WHERE ldets.LIMIT_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED )
1634: AND ldets.line_index = lines.line_index;
1635: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
1636: l_Header_id number := oe_order_cache.g_header_rec.Header_id;

Line 1801: -- qp_preq_lines_tmp lines,

1797: begin
1798: select 1 into l_source_system_code from
1799: oe_order_headers_all oh,
1800: qp_list_headers qh,
1801: -- qp_preq_lines_tmp lines,
1802: qp_preq_ldets_tmp ldets
1803: where qh.currency_code = oh.transactional_curr_code
1804: and oh.header_id = l_header_id
1805: -- and lines.line_index = ldets.line_index

Line 1851: , QP_PREQ_LINES_TMP lines

1847: price_break_type_code, substitution_attribute,
1848: proration_type_code, include_on_returns_flag,lines.line_index line_index
1849: from
1850: QP_LDETS_v ldets
1851: , QP_PREQ_LINES_TMP lines
1852: , QP_LIST_HEADERS_B QH
1853: where
1854: ldets.LIST_HEADER_ID = qh.list_header_id
1855: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED)

Line 2087: QP_PREQ_LINES_TMP lines

2083: SELECT l.LINE_ID,
2084: lines.PRICE_LIST_HEADER_ID,
2085: l.price_list_id
2086: FROM
2087: QP_PREQ_LINES_TMP lines
2088: ,OE_ORDER_LINES l
2089: WHERE lines.pricing_status_code IN
2090: ( QP_PREQ_GRP.G_STATUS_UPDATED
2091: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 2420: , QP_PREQ_LINES_TMP lines

2416: , ldets.adjustment_amount
2417: , 1
2418: FROM
2419: QP_LDETS_v ldets
2420: , QP_PREQ_LINES_TMP lines
2421: , QP_LIST_HEADERS_B QH
2422: WHERE
2423: ldets.list_header_id=qh.list_header_id
2424: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 2479: QP_PREQ_LINES_TMP RLINE

2475: FROM
2476: QP_PREQ_RLTD_LINES_TMP RLTD,
2477: QP_PREQ_LDETS_TMP LDET,
2478: QP_PREQ_LDETS_TMP RLDET,
2479: QP_PREQ_LINES_TMP RLINE
2480: WHERE
2481: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND
2482: RLDET.LINE_DETAIL_INDEX = RLTD.RELATED_LINE_DETAIL_INDEX AND
2483: LDET.PRICING_STATUS_CODE = 'N' AND