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_LDETS_V

Line 3702: AND list_line_id not in (select list_line_id from qp_ldets_v ld

3698: and b.pricing_phase_id = a.pricing_phase_id
3699: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3700: = decode(p_hdr_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3701: AND HEADER_ID = p_hdr_line_id
3702: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3703: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3704: QP_PREQ_GRP.G_STATUS_UPDATED,
3705: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3706: and ld.line_index = p_hdr_line_index

Line 3776: AND list_line_id not in (select list_line_id from qp_ldets_v ld

3772: where instr(p_pricing_events, a.pricing_event_code||',') > 0
3773: and b.pricing_phase_id = a.pricing_phase_id
3774: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3775: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3776: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3777: where ld. process_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3778: QP_PREQ_PUB.G_STATUS_UNCHANGED,
3779: QP_PREQ_PUB.G_STATUS_NEW)
3780: and ld.line_index = one_line.line_index

Line 3861: from qp_ldets_v ld

3857: AND LINE_ID = p_line_id
3858: --AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE') --bug 2858712 --Bug 13573144
3859: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE','TSN') --Bug 13573144
3860: AND list_line_id not in (select list_line_id
3861: from qp_ldets_v ld
3862: where ld.process_code in
3863: (QP_PREQ_GRP.G_STATUS_UPDATED,
3864: QP_PREQ_GRP.G_STATUS_UNCHANGED,
3865: QP_PREQ_PUB.G_STATUS_NEW)

Line 4049: QP_LDETS_v ldets

4045: , fnd_global.user_id
4046: , fnd_global.LOGIN_ID
4047: --bug#7369643
4048: from
4049: QP_LDETS_v ldets
4050: where ldets.line_detail_index = p_line_detail_index
4051: )
4052: where adj.price_adjustment_id = p_price_adjustment_id
4053: returning adj.list_line_id bulk collect into px_debug_upd_adj_tbl;

Line 4080: ,QP_LDETS_V LDETS

4076: Select /*+ ORDERED USE_NL(ADJ LDETS) index(QPLINES QP_PREQ_LINES_TMP_N2) index(ADJ OE_PRICE_ADJUSTMENTS_N2)*/
4077: adj.price_adjustment_id, ldets.line_detail_index
4078: From QP_PREQ_LINES_TMP QPLINES
4079: ,OE_PRICE_ADJUSTMENTS ADJ
4080: ,QP_LDETS_V LDETS
4081: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4082: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX
4083: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
4084: -- where pricing_event_code = p_pricing_events)

Line 4098: ,QP_LDETS_V LDETS

4094: cursor del_attribs2(p_hdr_line_index in number, p_hdr_line_id in number) Is
4095: Select ADJ.PRICE_ADJUSTMENT_ID, LDETS.LINE_DETAIL_INDEX
4096: From
4097: OE_PRICE_ADJUSTMENTS ADJ
4098: ,QP_LDETS_V LDETS
4099: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4100: AND LDETS.LINE_INDEX = p_hdr_line_index
4101: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
4102: -- where pricing_event_code = p_pricing_events)

Line 4147: , QP_LDETS_v ldets

4143: ldets.proration_type_code,
4144: ldets.include_on_returns_flag,
4145: adj.lock_control + 1 adj_lock_control
4146: from OE_PRICE_ADJUSTMENTS adj
4147: , QP_LDETS_v ldets
4148: , QP_PREQ_LINES_TMP lines
4149: WHERE
4150: adj.header_id=oe_order_pub.g_hdr.header_id
4151: and lines.line_index = ldets.line_index

Line 4193: , QP_LDETS_v ldets

4189: ldets.proration_type_code,
4190: ldets.include_on_returns_flag,
4191: adj.lock_control + 1 adj_lock_control
4192: from OE_PRICE_ADJUSTMENTS adj
4193: , QP_LDETS_v ldets
4194: , QP_PREQ_LINES_TMP lines
4195: WHERE
4196: adj.header_id=oe_order_pub.g_hdr.header_id
4197: and lines.line_index = ldets.line_index

Line 4210: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2

4206:
4207: --bug 3836854
4208: Cursor upd_adj(l_line_type IN Varchar2) Is
4209: select ldets2.price_adjustment_id, ldets2.line_detail_index
4210: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
4211: where ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
4212: 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)
4213: and lines2.process_status <> 'NOT_VALID'
4214: and lines2.line_index = ldets2.line_index

Line 4580: QP_LDETS_v ldets

4576: , ldets.OPERAND_value
4577: , ldets.adjustment_amount
4578: , 1
4579: FROM
4580: QP_LDETS_v ldets
4581: , QP_PREQ_LINES_TMP lines
4582: , QP_LIST_HEADERS_B QH
4583: WHERE
4584: ldets.list_header_id=qh.list_header_id

Line 4788: -- , QP_LDETS_v LDETS

4784: 'QP_ATTR_DEFNS_PRICING')
4785: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4786: ,1
4787: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4788: -- , QP_LDETS_v LDETS
4789: -- , OE_PRICE_ADJUSTMENTS ADJ
4790: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4791: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID
4792: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 4834: -- , QP_LDETS_v LDETS

4830: , qplat.attribute
4831: , qplat.setup_value_from
4832: , qplat.setup_value_to
4833: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4834: -- , QP_LDETS_v LDETS
4835: -- , OE_PRICE_ADJUSTMENTS ADJ
4836: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4837: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)
4838: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 4894: --, QP_LDETS_v LDETS

4890: 'QP_ATTR_DEFNS_PRICING')
4891: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4892: ,1
4893: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4894: --, QP_LDETS_v LDETS
4895: --, OE_PRICE_ADJUSTMENTS ADJ
4896: --, QP_PREQ_LINES_TMP QPL
4897: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4898: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 4924: From QP_LDETS_V LDETS

4920: /* Delete price_adj_attribs for order level adj*/
4921: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs
4922: WHERE exists
4923: (Select ADJ.PRICE_ADJUSTMENT_ID
4924: From QP_LDETS_V LDETS
4925: ,OE_PRICE_ADJUSTMENTS ADJ
4926: ,QP_PREQ_LINES_TMP QPLINES
4927: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4928: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX

Line 4937: From QP_LDETS_V LDETS

4933: /* Delete price_adj_attribs for line level adj*/
4934: /*DELETE FROM Oe_Price_Adj_Attribs adjattrs
4935: WHERE exists
4936: (Select ADJ.PRICE_ADJUSTMENT_ID
4937: From QP_LDETS_V LDETS
4938: ,OE_PRICE_ADJUSTMENTS ADJ
4939: ,QP_PREQ_LINES_TMP QPLINES
4940: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
4941: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX

Line 4988: , QP_LDETS_v LDETS

4984: 'QP_ATTR_DEFNS_PRICING')
4985: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
4986: ,1
4987: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4988: , QP_LDETS_v LDETS
4989: , OE_PRICE_ADJUSTMENTS ADJ
4990: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4991: -- AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4992: AND ADJ.LINE_ID IS NULL

Line 5047: , QP_LDETS_v LDETS

5043: 'QP_ATTR_DEFNS_PRICING')
5044: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
5045: ,1
5046: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5047: , QP_LDETS_v LDETS
5048: , OE_PRICE_ADJUSTMENTS ADJ
5049: , QP_PREQ_LINES_TMP QPLINE
5050: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
5051: -- AND QPLAT.LINE_INDEX = ADJ.HEADER_ID+nvl(ADJ.LINE_ID,0)

Line 7121: From qp_ldets_v ldet, qp_list_lines qpll, qp_price_formulas_vl f

7117:
7118: Function get_formula(p_line_index In Number) Return Varchar2 IS
7119: Cursor Get_Formula Is
7120: Select f.formula
7121: From qp_ldets_v ldet, qp_list_lines qpll, qp_price_formulas_vl f
7122: Where ldet.line_index = p_line_index
7123: AND ldet.list_line_id = qpll.list_line_id
7124: AND f.price_formula_id = nvl(qpll.price_by_formula_id,qpll.generate_using_formula_id);
7125: l_formula_name Varchar2(2000);