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_ADJ_PVT dependencies on QP_PRICING_PHASES

Line 10886: from qp_event_Phases e, qp_pricing_phases p

10882: Procedure Populate_Pricing_Phases(p_pricing_event in Varchar2) Is
10883:
10884: Cursor get_phases(l_event_code1 in Varchar2) Is
10885: Select e.Pricing_Phase_Id,nvl(p.user_freeze_override_flag,p.freeze_override_flag) freeze_override_flag
10886: from qp_event_Phases e, qp_pricing_phases p
10887: where e.pricing_phase_id = p.pricing_phase_id and
10888: trunc(sysdate) between Trunc(nvl(start_date_active,sysdate)) and
10889: trunc(nvl(End_Date_Active,sysdate))
10890: and e.pricing_event_code IN

Line 13487: FROM qp_pricing_phases a , qp_event_phases b

13483: AND qppr.product_attribute='PRICING_ATTRIBUTE3' -- bug#7488440
13484: AND qppr.product_attr_value='ALL' -- bug#7488440
13485: AND qppr.pricing_phase_id
13486: IN ( SELECT distinct a.pricing_phase_id
13487: FROM qp_pricing_phases a , qp_event_phases b
13488: WHERE
13489: a.pricing_phase_id = b.pricing_phase_id
13490: -- AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y') -- bug#7488440
13491: AND b.pricing_event_code in (SELECT decode(rownum