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_PUB

Line 264: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW,

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)
267: AND lines.process_status <> 'NOT_VALID'
268: AND ldets.line_index=lines.line_index;

Line 265: QP_PREQ_PUB.G_STATUS_UPDATED)

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)
267: AND lines.process_status <> 'NOT_VALID'
268: AND ldets.line_index=lines.line_index;
269:

Line 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))

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))
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

Line 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)*/

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))
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

Line 291: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index

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:
294:
295:

Line 604: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW

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: )
607: AND ldets.Line_index = lines.Line_index
608: order by ldets.line_index ASC;

Line 605: , QP_PREQ_PUB.G_STATUS_UPDATED

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: )
607: AND ldets.Line_index = lines.Line_index
608: order by ldets.line_index ASC;
609:

Line 1301: process_status IN (QP_PREQ_PUB.G_STATUS_NEW

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
1303: , QP_PREQ_PUB.G_STATUS_DELETED
1304: , 'FREEGOOD'
1305: );

Line 1302: , QP_PREQ_PUB.G_STATUS_UPDATED

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
1303: , QP_PREQ_PUB.G_STATUS_DELETED
1304: , 'FREEGOOD'
1305: );
1306: l_line_rec oe_order_pub.line_rec_type;

Line 1303: , QP_PREQ_PUB.G_STATUS_DELETED

1299: where
1300: --processed_code = 'ENGINE';
1301: process_status IN (QP_PREQ_PUB.G_STATUS_NEW
1302: , QP_PREQ_PUB.G_STATUS_UPDATED
1303: , QP_PREQ_PUB.G_STATUS_DELETED
1304: , 'FREEGOOD'
1305: );
1306: l_line_rec oe_order_pub.line_rec_type;
1307: l_buy_line_rec oe_order_pub.line_rec_type;

Line 1329: If (i.Process_status = QP_PREQ_PUB.G_STATUS_DELETED) THEN

1325: IF l_debug_level > 0 THEN
1326: oe_debug_pub.add( 'PRG LINE:'||I.LINE_ID||' PROCESS STATUS: '||I.PROCESS_STATUS ) ;
1327: END IF;
1328:
1329: If (i.Process_status = QP_PREQ_PUB.G_STATUS_DELETED) THEN
1330: l_line_rec := px_line_tbl(px_price_line_id_tbl(i.line_id));
1331: Delete_Prg(l_line_rec);
1332: px_line_tbl(px_price_line_id_tbl(i.line_id)) := l_line_rec;
1333: Elsif (i.Process_Status = 'FREEGOOD'

Line 1336: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_UPDATED

1332: px_line_tbl(px_price_line_id_tbl(i.line_id)) := l_line_rec;
1333: Elsif (i.Process_Status = 'FREEGOOD'
1334: and nvl(px_line_tbl(px_price_line_id_tbl(i.line_id)).cancelled_quantity, 0) = 0) THEN
1335: Null;
1336: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_UPDATED
1337: OR i.Process_Status = 'FREEGOOD') THEN
1338: l_line_rec := px_line_tbl(px_price_line_id_tbl(i.line_id));
1339: If l_line_rec.open_flag = 'N' Then
1340: Raise E_Closed_Line;

Line 1409: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_NEW) THEN

1405: End If; -- cancelled_quantity larger than ordered_quantity?
1406: IF (l_line_rec.operation <> OE_GLOBALS.G_OPR_NONE) THEN
1407: px_line_tbl(px_price_line_id_tbl(i.line_id)) := l_line_rec;
1408: END IF;
1409: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_NEW) THEN
1410: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
1411: l_line_rec.cancelled_quantity := 0;
1412: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1413: l_line_rec.Header_id := oe_order_cache.g_header_rec.header_id;

Line 2484: LDET.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_NEW,QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) AND

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
2484: LDET.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_NEW,QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) AND
2485: nvl(LDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
2486: lDET.CREATED_FROM_LIST_TYPE_CODE NOT IN ('PRL','AGR') AND
2487: lDET.PRICE_ADJUSTMENT_ID IS NOT NULL AND
2488: RLDET.PRICE_ADJUSTMENT_ID IS NOT NULL AND