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 309: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW,

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

Line 310: QP_PREQ_PUB.G_STATUS_UPDATED)

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

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

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

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

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

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

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:
340:
341:

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

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

Line 675: , QP_PREQ_PUB.G_STATUS_UPDATED

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

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

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

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

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:
702: Cursor revert_back_tsn_order IS
703: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id,

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

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

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

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:
724: Cursor order_level_Adj(p_header_id in Number) IS
725: select substitution_attribute, modified_to

Line 1640: process_status IN (QP_PREQ_PUB.G_STATUS_NEW

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
1642: , QP_PREQ_PUB.G_STATUS_DELETED
1643: , 'FREEGOOD'
1644: );

Line 1641: , QP_PREQ_PUB.G_STATUS_UPDATED

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
1642: , QP_PREQ_PUB.G_STATUS_DELETED
1643: , 'FREEGOOD'
1644: );
1645: l_line_rec oe_order_pub.line_rec_type;

Line 1642: , QP_PREQ_PUB.G_STATUS_DELETED

1638: where
1639: --processed_code = 'ENGINE';
1640: process_status IN (QP_PREQ_PUB.G_STATUS_NEW
1641: , QP_PREQ_PUB.G_STATUS_UPDATED
1642: , QP_PREQ_PUB.G_STATUS_DELETED
1643: , 'FREEGOOD'
1644: );
1645: l_line_rec oe_order_pub.line_rec_type;
1646: l_buy_line_rec oe_order_pub.line_rec_type;

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

1682: END IF;
1683:
1684: -- 8631297
1685:
1686: If (i.Process_status = QP_PREQ_PUB.G_STATUS_DELETED) THEN
1687: l_line_rec := px_line_tbl(px_price_line_id_tbl(l_mod_line_id));
1688: Delete_Prg(l_line_rec);
1689: px_line_tbl(px_price_line_id_tbl(l_mod_line_id)) := l_line_rec;
1690: Elsif (i.Process_Status = 'FREEGOOD'

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

1689: px_line_tbl(px_price_line_id_tbl(l_mod_line_id)) := l_line_rec;
1690: Elsif (i.Process_Status = 'FREEGOOD'
1691: and nvl(px_line_tbl(px_price_line_id_tbl(l_mod_line_id)).cancelled_quantity, 0) = 0) THEN
1692: Null;
1693: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_UPDATED
1694: OR i.Process_Status = 'FREEGOOD') THEN
1695: l_line_rec := px_line_tbl(px_price_line_id_tbl(l_mod_line_id));
1696: If l_line_rec.open_flag = 'N' Then
1697: Raise E_Closed_Line;

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

1778: End If; -- cancelled_quantity larger than ordered_quantity?
1779: IF (l_line_rec.operation <> OE_GLOBALS.G_OPR_NONE) THEN
1780: px_line_tbl(px_price_line_id_tbl(l_mod_line_id)) := l_line_rec; -- Bug 8631297
1781: END IF;
1782: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_NEW) THEN
1783: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
1784: l_line_rec.cancelled_quantity := 0;
1785: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1786: l_line_rec.Header_id := oe_order_cache.g_header_rec.header_id;

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

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
2957: LDET.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_NEW,QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) AND
2958: nvl(LDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
2959: lDET.CREATED_FROM_LIST_TYPE_CODE NOT IN ('PRL','AGR') AND
2960: lDET.PRICE_ADJUSTMENT_ID IS NOT NULL AND
2961: RLDET.PRICE_ADJUSTMENT_ID IS NOT NULL AND

Line 2965: RLDET.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_NEW,QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) AND

2961: RLDET.PRICE_ADJUSTMENT_ID IS NOT NULL AND
2962: RLDET.PRICING_STATUS_CODE = 'N' AND
2963: --Start Bug 16467223, commenting below line and added the next line for checking in different pricess_code
2964: --RLDET.PROCESS_CODE = 'N' AND
2965: RLDET.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_NEW,QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) AND
2966: --End Bug 16467223
2967: nvl(RLDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
2968: -- not in might not be needed
2969: RLDET.PRICE_ADJUSTMENT_ID