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 307: QP_PREQ_LINES_TMP lines

303:
304: Cursor upgraded_items IS
305: SELECT ldets.line_detail_index,ldets.Line_index,ldets.related_item_id,lines.line_id
306: FROM QP_LDETS_V ldets,
307: QP_PREQ_LINES_TMP lines
308: WHERE ldets.list_line_Type_code /*created_from_list_line_type list_line_Type_code*/= 'IUE'
309: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW,
310: QP_PREQ_PUB.G_STATUS_UPDATED)
311: 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 326: from qp_preq_lines_tmp where

322: AND list_line_Type_code = 'IUE'
323: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
324: where instr(p_pricing_events||',', pricing_event_code||',') >0)
325: AND LINE_ID IN (select line_id
326: from qp_preq_lines_tmp where
327: line_type_code='LINE'
328: and price_flag IN ('Y','P')
329: and process_status <> 'NOT_VALID'
330: 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 335: from qp_ldets_v ld, qp_preq_lines_tmp l

331: /* AND list_line_id NOT IN (SELECT list_line_id
332: from qp_ldets_v where process_code
333: 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)*/
334: AND list_line_id NOT IN (SELECT list_line_id
335: from qp_ldets_v ld, qp_preq_lines_tmp l
336: where ld.process_code
337: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index
338: and l.line_id = adj.line_id);
339:

Line 672: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

668: , ldets.substitution_attribute, ldets.substitution_value_to
669: ,CHANGE_REASON_CODE,CHANGE_REASON_TEXT
670: , MODIFIER_LEVEL_CODE --Bug 13573144
671: ,lines.line_type_code --bug 4190357
672: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
673: WHERE ldets.list_line_type_code = 'TSN'
674: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW
675: , QP_PREQ_PUB.G_STATUS_UPDATED
676: )

Line 691: from qp_preq_lines_tmp where

687: AND adj.list_line_Type_code = 'TSN'
688: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
689: where instr(p_pricing_events||',', pricing_event_code||',')>0)
690: AND adj.LINE_ID IN (select line_id
691: from qp_preq_lines_tmp where
692: line_type_code='LINE'
693: and price_flag IN ('Y','P')
694: and process_status <> 'NOT_VALID'
695: 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 697: from qp_ldets_v ld, qp_preq_lines_tmp l

693: and price_flag IN ('Y','P')
694: and process_status <> 'NOT_VALID'
695: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED, QP_PREQ_PUB.G_STATUS_GSA_VIOLATION, QP_PREQ_PUB.G_STATUS_UNCHANGED))
696: AND adj.price_Adjustment_id NOT IN (SELECT ld.price_Adjustment_id
697: from qp_ldets_v ld, qp_preq_lines_tmp l
698: where ld.process_code
699: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index
700: );
701:

Line 713: from qp_preq_lines_tmp where

709: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
710: where instr(p_pricing_events||',', pricing_event_code||',')>0)
711: AND adj.line_id IS NULL
712: AND adj.header_id IN (select line_id
713: from qp_preq_lines_tmp where
714: line_type_code='ORDER'
715: and price_flag IN ('Y','P')
716: and process_status <> 'NOT_VALID'
717: 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 719: from qp_ldets_v ld, qp_preq_lines_tmp l

715: and price_flag IN ('Y','P')
716: and process_status <> 'NOT_VALID'
717: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED, QP_PREQ_PUB.G_STATUS_GSA_VIOLATION, QP_PREQ_PUB.G_STATUS_UNCHANGED))
718: AND adj.price_Adjustment_id NOT IN (SELECT price_Adjustment_id
719: from qp_ldets_v ld, qp_preq_lines_tmp l
720: where ld.process_code
721: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index
722: and l.line_type_code='ORDER' and l.line_id = adj.header_id);
723:

Line 1269: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE

1265: END Term_Substitution;
1266:
1267: Procedure Set_Prg(
1268: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
1269: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
1270: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
1271: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925
1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925

Line 1270: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE

1266:
1267: Procedure Set_Prg(
1268: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
1269: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
1270: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
1271: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925
1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925
1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE

Line 1271: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE

1267: Procedure Set_Prg(
1268: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
1269: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
1270: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
1271: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925
1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925
1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE

Line 1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925

1268: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
1269: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
1270: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
1271: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925
1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925
1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE

Line 1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925

1269: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
1270: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
1271: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925
1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925
1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE

Line 1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE

1270: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
1271: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925
1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925
1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE

Line 1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE

1271: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925
1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925
1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE

Line 1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE

1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925
1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925
1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE

Line 1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE

1273: , p_service_period IN QP_PREQ_LINES_TMP.service_period%TYPE DEFAULT NULL --Service ER 16227925
1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
1281: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE

Line 1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE

1274: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE
1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
1281: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
1282: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE

Line 1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE

1275: , p_unit_price IN QP_PREQ_LINES_TMP.unit_price%TYPE
1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
1281: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
1282: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
1283: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE

Line 1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE

1276: , p_adjusted_unit_price IN QP_PREQ_LINES_TMP.adjusted_unit_price%TYPE
1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
1281: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
1282: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
1283: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
1284: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE

Line 1281: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE

1277: , p_line_unit_price IN QP_PREQ_LINES_TMP.line_unit_price%TYPE
1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
1281: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
1282: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
1283: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
1284: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
1285: )

Line 1282: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE

1278: , p_order_uom_selling_price IN QP_PREQ_LINES_TMP.order_uom_selling_price%TYPE
1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
1281: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
1282: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
1283: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
1284: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
1285: )
1286: IS

Line 1283: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE

1279: , p_line_category IN QP_PREQ_LINES_TMP.line_category%TYPE
1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
1281: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
1282: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
1283: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
1284: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
1285: )
1286: IS
1287: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;

Line 1284: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE

1280: , p_priced_quantity IN QP_PREQ_LINES_TMP.priced_quantity%TYPE
1281: , p_price_list_header_id IN QP_PREQ_LINES_TMP.price_list_header_id%TYPE
1282: , p_percent_price IN QP_PREQ_LINES_TMP.percent_price%TYPE
1283: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
1284: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
1285: )
1286: IS
1287: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1288: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 1559: UPDATE QP_PREQ_LINES_TMP

1555: END IF;
1556: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1557: BEGIN
1558: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110510' THEN
1559: UPDATE QP_PREQ_LINES_TMP
1560: SET PROCESS_STATUS='NOT_VALID'
1561: WHERE LINE_ID = l_line_rec.line_id;
1562: ELSE
1563: QP_UTIL_PUB.Update_Lines('MAKE_STATUS_INVALID',l_line_rec.line_id,

Line 1637: From qp_preq_lines_tmp

1633: , priced_uom_code
1634: , price_request_code
1635: , service_duration --Service ER 16227925
1636: , service_period --Service ER 16227925
1637: From qp_preq_lines_tmp
1638: where
1639: --processed_code = 'ENGINE';
1640: process_status IN (QP_PREQ_PUB.G_STATUS_NEW
1641: , QP_PREQ_PUB.G_STATUS_UPDATED

Line 1735: UPDATE QP_PREQ_LINES_TMP

1731: l_pricing_quantity := l_pricing_quantity - nvl(l_line_rec.cancelled_quantity, 0);
1732: IF nvl(l_line_rec.cancelled_quantity, 0) > 0 THEN
1733: BEGIN
1734: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110510' THEN
1735: UPDATE QP_PREQ_LINES_TMP
1736: SET PRICED_QUANTITY = l_pricing_quantity
1737: where line_id = l_line_rec.line_id;
1738: ELSE
1739: QP_UTIL_PUB.Update_Lines('UPDATE_PRICED_QUANTITY',l_line_rec.line_id,null,l_pricing_quantity);

Line 1801: UPDATE QP_PREQ_LINES_TMP

1797: --bug 4234500
1798:
1799: BEGIN
1800: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110510' THEN
1801: UPDATE QP_PREQ_LINES_TMP
1802: SET LINE_ID = l_line_rec.line_id
1803: where line_index = i.line_index;
1804: ELSE
1805: QP_UTIL_PUB.Update_Lines('UPDATE_LINE_ID', l_line_rec.line_id,

Line 1819: FROM qp_preq_lines_tmp

1815: AND relationship_type_code = 'GENERATED_LINE' and rownum=1;
1816:
1817: SELECT line_id
1818: INTO l_parent_line_id
1819: FROM qp_preq_lines_tmp
1820: WHERE line_index = l_parent_line_index;
1821:
1822:
1823: l_buy_line_rec := px_line_tbl(px_price_line_id_tbl(MOD(l_parent_line_id, G_BINARY_LIMIT))); --BUG 8631297

Line 2054: FROM QP_PREQ_LINES_TMP

2050: Procedure Process_Limits IS
2051:
2052: Cursor Hold_Lines IS
2053: SELECT line_index, line_id, line_Type_code, hold_code
2054: FROM QP_PREQ_LINES_TMP
2055: WHERE HOLD_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED);
2056:
2057: Cursor limit_violated_details IS
2058: SELECT ldets.line_index, ldets.limit_text, lines.line_id

Line 2059: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

2055: WHERE HOLD_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED);
2056:
2057: Cursor limit_violated_details IS
2058: SELECT ldets.line_index, ldets.limit_text, lines.line_id
2059: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
2060: WHERE ldets.LIMIT_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED )
2061: AND ldets.line_index = lines.line_index;
2062: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
2063: l_Header_id number := oe_order_cache.g_header_rec.Header_id;

Line 2228: -- qp_preq_lines_tmp lines,

2224: begin
2225: select 1 into l_source_system_code from
2226: oe_order_headers_all oh,
2227: qp_list_headers qh,
2228: -- qp_preq_lines_tmp lines,
2229: qp_preq_ldets_tmp ldets
2230: where qh.currency_code = oh.transactional_curr_code
2231: and oh.header_id = l_header_id
2232: -- and lines.line_index = ldets.line_index

Line 2278: , QP_PREQ_LINES_TMP lines

2274: price_break_type_code, substitution_attribute,
2275: proration_type_code, include_on_returns_flag,lines.line_index line_index
2276: from
2277: QP_LDETS_v ldets
2278: , QP_PREQ_LINES_TMP lines
2279: , QP_LIST_HEADERS_B QH
2280: where
2281: ldets.LIST_HEADER_ID = qh.list_header_id
2282: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED) --Bug8467307

Line 2553: QP_PREQ_LINES_TMP lines

2549: SELECT l.LINE_ID,
2550: lines.PRICE_LIST_HEADER_ID,
2551: l.price_list_id
2552: FROM
2553: QP_PREQ_LINES_TMP lines
2554: ,OE_ORDER_LINES l
2555: WHERE lines.pricing_status_code IN
2556: ( QP_PREQ_GRP.G_STATUS_UPDATED
2557: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 2888: , QP_PREQ_LINES_TMP lines

2884: , ldets.adjustment_amount
2885: , 1
2886: FROM
2887: QP_LDETS_v ldets
2888: , QP_PREQ_LINES_TMP lines
2889: , QP_LIST_HEADERS_B QH
2890: WHERE
2891: ldets.list_header_id=qh.list_header_id
2892: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 2952: QP_PREQ_LINES_TMP RLINE

2948: FROM
2949: QP_PREQ_RLTD_LINES_TMP RLTD,
2950: QP_PREQ_LDETS_TMP LDET,
2951: QP_PREQ_LDETS_TMP RLDET,
2952: QP_PREQ_LINES_TMP RLINE
2953: WHERE
2954: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND
2955: RLDET.LINE_DETAIL_INDEX = RLTD.RELATED_LINE_DETAIL_INDEX AND
2956: LDET.PRICING_STATUS_CODE = 'N' AND