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_EVENT_PHASES

Line 157: from qp_event_Phases e, qp_pricing_phases p

153:
154: Cursor get_phases(l_event_code1 in Varchar2) Is
155: Select e.Pricing_Phase_Id,
156: nvl(p.user_freeze_override_flag,p.freeze_override_flag) pof
157: from qp_event_Phases e, qp_pricing_phases p
158: where e.pricing_phase_id = p.pricing_phase_id and
159: trunc(sysdate) between Trunc(nvl(start_date_active,sysdate)) and
160: trunc(nvl(End_Date_Active,sysdate))
161: and e.pricing_event_code IN

Line 174: FROM qp_event_phases

170: ,5 ,substr(p_pricing_event , instr(l_event_code1,',',1,rownum-1) + 1,
171: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
172: ,6 ,substr(p_pricing_event , instr(l_event_code1,',',1,rownum-1) + 1,
173: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
174: FROM qp_event_phases
175: WHERE rownum < 7);
176: --
177: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
178: --

Line 3695: from qp_event_phases a,

3691: --AND LIST_LINE_TYPE_CODE NOT IN ('TAX') --Bug 13573144
3692: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','TSN') --Bug 13573144
3693: AND NVL(UPDATED_FLAG, 'N')='N'
3694: AND PRICING_PHASE_ID IN (select b.pricing_phase_id
3695: from qp_event_phases a,
3696: qp_pricing_phases b
3697: where instr(p_pricing_events, a.pricing_event_code||',') > 0
3698: and b.pricing_phase_id = a.pricing_phase_id
3699: and nvl(b.user_freeze_override_flag,freeze_override_flag)

Line 3770: from qp_event_phases a,

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
3768: AND NVL(UPDATED_FLAG, 'N')='N'
3769: AND PRICING_PHASE_ID IN (select b.pricing_phase_id
3770: from qp_event_phases a,
3771: qp_pricing_phases b
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)

Line 3851: from qp_event_phases a,

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
3851: from qp_event_phases a,
3852: qp_pricing_phases b
3853: where instr(p_pricing_events, a.pricing_event_code||',') > 0
3854: and b.pricing_phase_id = a.pricing_phase_id
3855: and nvl(b.user_freeze_override_flag,b.freeze_override_flag)

Line 4083: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases

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)
4085: --changes to enable multiple events passed as a string
4086: where instr(l_pricing_events, pricing_event_code||',') > 0)
4087: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,

Line 4101: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases

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)
4103: --changes to enable multiple events passed as a string
4104: where instr(l_pricing_events, pricing_event_code||',') > 0)
4105: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,

Line 6558: l_sql := 'SELECT ''Y'' FROM qp_pricing_phases p, qp_event_phases e WHERE p.pricing_phase_id=e.pricing_phase_id'

6554: BEGIN
6555: l_event_in_phase1 := 'N';
6556: --- bug# 9436193 : Start : using dynamic sql
6557: oe_debug_pub.add(' l_event_in_phase1 = '||l_event_in_phase1||' p_pricing_events = '||p_pricing_events);
6558: l_sql := 'SELECT ''Y'' FROM qp_pricing_phases p, qp_event_phases e WHERE p.pricing_phase_id=e.pricing_phase_id'
6559: ||' AND p.pricing_phase_id = 1 AND trunc(sysdate) BETWEEN trunc(nvl(e.end_date_active,sysdate)) AND trunc(nvl(e.end_date_active,sysdate))'
6560: ||' AND e.pricing_event_code in ('''||replace(trim(p_pricing_events),',',''',''')||''') ' ;
6561: oe_debug_pub.add(' l_sql = '||l_sql);
6562: EXECUTE IMMEDIATE l_sql INTO l_event_in_phase1;

Line 6567: qp_event_phases e

6563: oe_debug_pub.add('after l_sql: l_event_in_phase1 =>> '||l_event_in_phase1);
6564: /*
6565: SELECT 'Y' INTO l_event_in_phase1
6566: FROM qp_pricing_phases p,
6567: qp_event_phases e
6568: WHERE p.pricing_phase_id=e.pricing_phase_id
6569: AND p.pricing_phase_id = 1
6570: AND e.pricing_event_code= p_pricing_events
6571: AND trunc(sysdate) BETWEEN trunc(nvl(e.end_date_active,sysdate)) AND trunc(nvl(e.end_date_active,sysdate));