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 OE_AGREEMENTS_VL

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

5783:
5784: If l_line_tbl(line_Tbl_Index).agreement_id is not null Then
5785: BEGIN
5786: Select 'x' into l_dummy from dual
5787: where exists (select 'x' from oe_agreements_vl where
5788: agreement_id = l_line_tbl(line_Tbl_Index).agreement_id and
5789: ( trunc(nvl(l_line_tbl(line_Tbl_Index).PRICING_DATE,sysdate))
5790: between
5791: trunc(nvl(start_date_active, nvl(l_line_tbl(line_Tbl_Index).PRICING_DATE,sysdate)))

Line 5801: from oe_agreements_vl where agreement_id =

5797: Exception
5798: When no_data_found then
5799: Begin
5800: select name, revision into l_agreement_name, l_revision
5801: from oe_agreements_vl where agreement_id =
5802: l_line_tbl(line_Tbl_Index).agreement_id;
5803:
5804: Exception
5805: When no_data_found then