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 5878: where exists (select 'x' from oe_agreements_vl where

5874:
5875: If l_line_tbl(line_Tbl_Index).agreement_id is not null Then
5876: BEGIN
5877: Select 'x' into l_dummy from dual
5878: where exists (select 'x' from oe_agreements_vl where
5879: agreement_id = l_line_tbl(line_Tbl_Index).agreement_id and
5880: ( trunc(nvl(l_line_tbl(line_Tbl_Index).PRICING_DATE,sysdate))
5881: between
5882: trunc(nvl(start_date_active, nvl(l_line_tbl(line_Tbl_Index).PRICING_DATE,sysdate)))

Line 5892: from oe_agreements_vl where agreement_id =

5888: Exception
5889: When no_data_found then
5890: Begin
5891: select name, revision into l_agreement_name, l_revision
5892: from oe_agreements_vl where agreement_id =
5893: l_line_tbl(line_Tbl_Index).agreement_id;
5894:
5895: Exception
5896: When no_data_found then