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_PRICING_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 3696: qp_pricing_phases b

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)
3700: = decode(p_hdr_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))

Line 3771: qp_pricing_phases b

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)
3775: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))

Line 3852: qp_pricing_phases b

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)
3856: = decode(l_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))

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 6566: FROM qp_pricing_phases p,

6562: EXECUTE IMMEDIATE l_sql INTO l_event_in_phase1;
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