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_AGREEMENTS_VL

Line 6183: where exists (select 'x' from oe_agreements_vl where

6179:
6180: If l_line_tbl(line_Tbl_Index).agreement_id is not null Then
6181: BEGIN
6182: Select 'x' into l_dummy from dual
6183: where exists (select 'x' from oe_agreements_vl where
6184: agreement_id = l_line_tbl(line_Tbl_Index).agreement_id and
6185: ( trunc(nvl(l_line_tbl(line_Tbl_Index).PRICING_DATE,sysdate))
6186: between
6187: trunc(nvl(start_date_active, nvl(l_line_tbl(line_Tbl_Index).PRICING_DATE,sysdate)))

Line 6197: from oe_agreements_vl where agreement_id =

6193: Exception
6194: When no_data_found then
6195: Begin
6196: select name, revision into l_agreement_name, l_revision
6197: from oe_agreements_vl where agreement_id =
6198: l_line_tbl(line_Tbl_Index).agreement_id;
6199:
6200: Exception
6201: When no_data_found then