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 10778: from qp_event_Phases e, qp_pricing_phases p

10774: Procedure Populate_Pricing_Phases(p_pricing_event in Varchar2) Is
10775:
10776: Cursor get_phases(l_event_code1 in Varchar2) Is
10777: Select e.Pricing_Phase_Id,nvl(p.user_freeze_override_flag,p.freeze_override_flag) freeze_override_flag
10778: from qp_event_Phases e, qp_pricing_phases p
10779: where e.pricing_phase_id = p.pricing_phase_id and
10780: trunc(sysdate) between Trunc(nvl(start_date_active,sysdate)) and
10781: trunc(nvl(End_Date_Active,sysdate))
10782: and e.pricing_event_code IN

Line 13313: FROM qp_pricing_phases a , qp_event_phases b

13309: AND qppr.product_attribute='PRICING_ATTRIBUTE3' -- bug#7488440
13310: AND qppr.product_attr_value='ALL' -- bug#7488440
13311: AND qppr.pricing_phase_id
13312: IN ( SELECT distinct a.pricing_phase_id
13313: FROM qp_pricing_phases a , qp_event_phases b
13314: WHERE
13315: a.pricing_phase_id = b.pricing_phase_id
13316: -- AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y') -- bug#7488440
13317: AND b.pricing_event_code in (SELECT decode(rownum