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 OE_PRICE_ADJUSTMENTS

Line 1979: from oe_price_adjustments adj1,

1975: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1976: line_Tbl_Index pls_integer;
1977: Cursor prg_lines is
1978: select adj1.line_id prg_line_id, assoc.rltd_price_adj_id
1979: from oe_price_adjustments adj1,
1980: oe_price_adj_assocs assoc,
1981: oe_price_adjustments adj2
1982: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
1983: assoc.price_adjustment_id = adj2.price_adjustment_id AND

Line 1981: oe_price_adjustments adj2

1977: Cursor prg_lines is
1978: select adj1.line_id prg_line_id, assoc.rltd_price_adj_id
1979: from oe_price_adjustments adj1,
1980: oe_price_adj_assocs assoc,
1981: oe_price_adjustments adj2
1982: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
1983: assoc.price_adjustment_id = adj2.price_adjustment_id AND
1984: adj2.list_line_type_code = 'PRG' AND
1985: adj2.line_id = p_line_id;

Line 2081: select modified_from from oe_price_adjustments

2077: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2078: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
2079: l_ordered_item varchar2(300);
2080: cursor adj_cur is
2081: select modified_from from oe_price_adjustments
2082: where line_id=px_line_rec.line_id
2083: and list_line_type_code='IUE';
2084: --
2085: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3688: DELETE FROM OE_PRICE_ADJUSTMENTS

3684: (QP_PREQ_PUB.G_STATUS_UPDATED,
3685: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION
3686: )
3687: THEN
3688: DELETE FROM OE_PRICE_ADJUSTMENTS
3689: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id
3690: AND LINE_ID IS NULL
3691: --AND LIST_LINE_TYPE_CODE NOT IN ('TAX') --Bug 13573144
3692: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','TSN') --Bug 13573144

Line 3762: DELETE /+ index (adj oe_price_adjustments_n2) /

3758: BEGIN
3759:
3760: l_line_type_code := 'LINE';
3761: For one_line in updated_order_lines(l_line_type_code) loop
3762: DELETE /*+ index (adj oe_price_adjustments_n2) */
3763: FROM OE_PRICE_ADJUSTMENTS adj
3764: WHERE --HEADER_ID=oe_order_pub.g_hdr.header_id
3765: LINE_ID = one_line.line_id
3766: --AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE') --bug 2858712 --Bug 13573144

Line 3763: FROM OE_PRICE_ADJUSTMENTS adj

3759:
3760: l_line_type_code := 'LINE';
3761: For one_line in updated_order_lines(l_line_type_code) loop
3762: DELETE /*+ index (adj oe_price_adjustments_n2) */
3763: FROM OE_PRICE_ADJUSTMENTS adj
3764: WHERE --HEADER_ID=oe_order_pub.g_hdr.header_id
3765: LINE_ID = one_line.line_id
3766: --AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE') --bug 2858712 --Bug 13573144
3767: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE','TSN') --Bug 13573144

Line 3846: DELETE FROM OE_PRICE_ADJUSTMENTS

3842: and process_status <> 'NOT_VALID'
3843: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3844: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3845:
3846: DELETE FROM OE_PRICE_ADJUSTMENTS
3847: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id
3848: AND LINE_ID=p_line_id
3849: AND NVL(UPDATED_FLAG, 'N')='N'
3850: AND PRICING_PHASE_ID IN (select b.pricing_phase_id

Line 3925: FROM oe_price_adjustments

3921: BEGIN
3922:
3923: SELECT price_adjustment_id
3924: INTO l_price_adjustment_id
3925: FROM oe_price_adjustments
3926: WHERE price_adjustment_id = p_price_adjustment_id
3927: FOR UPDATE NOWAIT;
3928:
3929: IF l_debug_level > 0 Then

Line 3957: UPDATE OE_PRICE_ADJUSTMENTS adj

3953:
3954: END;
3955: --bug 5497035
3956:
3957: UPDATE OE_PRICE_ADJUSTMENTS adj
3958: SET ( operand
3959: , operand_per_pqty
3960: , adjusted_amount
3961: , adjusted_amount_per_pqty

Line 4076: Select /+ ORDERED USE_NL(ADJ LDETS) index(QPLINES QP_PREQ_LINES_TMP_N2) index(ADJ OE_PRICE_ADJUSTMENTS_N2)/

4072: i number;
4073: l_pricing_events varchar2(40) := p_pricing_events||',';
4074: l_stmt number:=0;
4075: cursor del_attribs1 Is
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

Line 4079: ,OE_PRICE_ADJUSTMENTS ADJ

4075: cursor del_attribs1 Is
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

Line 4097: OE_PRICE_ADJUSTMENTS ADJ

4093:
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

Line 4146: from OE_PRICE_ADJUSTMENTS adj

4142: ldets.price_break_type_code,
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

Line 4192: from OE_PRICE_ADJUSTMENTS adj

4188: ldets.price_break_type_code,
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

Line 4373: INSERT INTO OE_PRICE_ADJUSTMENTS

4369: l_stmt:=7;
4370: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4371: OE_ADV_PRICE_PVT.Insert_Adj(p_header_id);
4372: ELSE
4373: INSERT INTO OE_PRICE_ADJUSTMENTS
4374: ( PRICE_ADJUSTMENT_ID
4375: , CREATION_DATE
4376: , CREATED_BY
4377: , LAST_UPDATE_DATE

Line 4476: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id

4472: , ADJUSTED_AMOUNT_PER_PQTY
4473: , LOCK_CONTROL
4474: )
4475: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
4476: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
4477: , sysdate --p_Line_Adj_rec.creation_date
4478: , fnd_global.user_id --p_Line_Adj_rec.created_by
4479: , sysdate --p_Line_Adj_rec.last_update_date
4480: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

Line 4637: OE_PRICE_ADJUSTMENTS ADJ,

4633: ,ADJ.LINE_ID
4634: ,RADJ.PRICE_ADJUSTMENT_ID
4635: ,1
4636: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,
4637: OE_PRICE_ADJUSTMENTS ADJ,
4638: OE_PRICE_ADJUSTMENTS RADJ,
4639: QP_PREQ_LINES_TMP QPL
4640: WHERE
4641: ADJ.HEADER_ID = RLTD.LINE_INDEX AND

Line 4638: OE_PRICE_ADJUSTMENTS RADJ,

4634: ,RADJ.PRICE_ADJUSTMENT_ID
4635: ,1
4636: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,
4637: OE_PRICE_ADJUSTMENTS ADJ,
4638: OE_PRICE_ADJUSTMENTS RADJ,
4639: QP_PREQ_LINES_TMP QPL
4640: WHERE
4641: ADJ.HEADER_ID = RLTD.LINE_INDEX AND
4642: ADJ.LIST_LINE_ID = RLTD.LIST_LINE_ID AND

Line 4685: OE_PRICE_ADJUSTMENTS ADJ,

4681: ,1
4682: FROM
4683: QP_PREQ_RLTD_LINES_TMP RLTD,
4684: QP_PREQ_LINES_TMP QPL,
4685: OE_PRICE_ADJUSTMENTS ADJ,
4686: OE_PRICE_ADJUSTMENTS RADJ
4687: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX AND
4688: QPL.LINE_ID = ADJ.LINE_ID AND
4689: QPL.LINE_TYPE_CODE = 'LINE' AND

Line 4686: OE_PRICE_ADJUSTMENTS RADJ

4682: FROM
4683: QP_PREQ_RLTD_LINES_TMP RLTD,
4684: QP_PREQ_LINES_TMP QPL,
4685: OE_PRICE_ADJUSTMENTS ADJ,
4686: OE_PRICE_ADJUSTMENTS RADJ
4687: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX AND
4688: QPL.LINE_ID = ADJ.LINE_ID AND
4689: QPL.LINE_TYPE_CODE = 'LINE' AND
4690: QPL.PROCESS_STATUS <> 'NOT_VALID' AND

Line 4727: -- , OE_PRICE_ADJUSTMENTS ADJ

4723: , qplat.setup_value_from
4724: , qplat.setup_value_to
4725: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
4726: -- , QP_PREQ_LDETS_TMP LDETS
4727: -- , OE_PRICE_ADJUSTMENTS ADJ
4728: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4729: --AND QPLAT.LINE_INDEX = ADJ.HEADER_ID + nvl(ADJ.LINE_ID, 0)
4730: --AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4731: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)

Line 4789: -- , OE_PRICE_ADJUSTMENTS ADJ

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
4793: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)

Line 4835: -- , OE_PRICE_ADJUSTMENTS ADJ

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
4839: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)

Line 4895: --, OE_PRICE_ADJUSTMENTS ADJ

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
4899: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)

Line 4925: ,OE_PRICE_ADJUSTMENTS 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
4929: AND QPLINES.LINE_TYPE_CODE = 'ORDER'

Line 4938: ,OE_PRICE_ADJUSTMENTS 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
4942: AND QPLINES.LINE_ID = ADJ.LINE_ID

Line 4989: , OE_PRICE_ADJUSTMENTS ADJ

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
4993: AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id

Line 5048: , OE_PRICE_ADJUSTMENTS ADJ

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)
5052: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX

Line 5108: , OE_PRICE_ADJUSTMENTS ADJ

5104: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
5105: ,1
5106: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
5107: , QP_PREQ_LDETS_TMP LDETS
5108: , OE_PRICE_ADJUSTMENTS ADJ
5109: , QP_PREQ_LINES_TMP QPLINE
5110: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
5111: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
5112: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX

Line 8199: FROM oe_price_adjustments

8195:
8196: /*12598464 start
8197: SELECT Count(1)
8198: INTO l_hdr_chg_count
8199: FROM oe_price_adjustments
8200: WHERE header_id= px_Line_Tbl(1).header_id
8201: AND list_line_type_code='FREIGHT_CHARGE'
8202: AND line_id IS NULL;
8203: 12598464 end*/