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

6463: -- Added to check if Agreement is Active for Bug#2740845
6464: If l_line_tbl(line_Tbl_Index).agreement_id is not null Then
6465: BEGIN
6466: Select 'x' into l_dummy from dual
6467: where exists (select 'x' from oe_agreements_vl where
6468: agreement_id = l_line_tbl(line_Tbl_Index).agreement_id and
6469: ( trunc(nvl(l_line_tbl(line_Tbl_Index).PRICING_DATE,sysdate))
6470: between
6471: trunc(nvl(start_date_active, nvl(l_line_tbl(line_Tbl_Index).PRICING_DATE,sysdate)))

Line 6481: from oe_agreements_vl where agreement_id =

6477: Exception
6478: When no_data_found then
6479: Begin
6480: select name, revision into l_agreement_name, l_revision
6481: from oe_agreements_vl where agreement_id =
6482: l_line_tbl(line_Tbl_Index).agreement_id;
6483:
6484: Exception
6485: When no_data_found then