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.

[Home] [Help]

APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_TERR_USGS_ALL

Line 739: FROM jtf_terr_usgs_all WHERE terr_id = l_TerrRsc_Tbl(1).terr_id ;

735: -- Get the default trans_access_code for the usage.
736: BEGIN
737: SELECT DECODE(source_id, '-1001' , 'FULL_ACCESS' , 'DEFAULT' )
738: INTO l_trans_access_code
739: FROM jtf_terr_usgs_all WHERE terr_id = l_TerrRsc_Tbl(1).terr_id ;
740: EXCEPTION
741: WHEN OTHERS THEN
742: NULL;
743: END;

Line 1266: JTF_TERR_USGS_ALL JTU,

1262:
1263: SELECT JSA.RSC_LOV_SQL
1264: INTO l_rsc_lov_sql
1265: FROM JTF_TERR_ALL JTA,
1266: JTF_TERR_USGS_ALL JTU,
1267: JTF_SOURCES_ALL JSA
1268: WHERE JTA.TERR_ID = P_TerrRsc_Rec.Terr_Id
1269: AND JTA.TERR_ID = JTU.TERR_ID
1270: AND JTU.SOURCE_ID = JSA.SOURCE_ID;

Line 1349: JTF_TERR_USGS_ALL JTU,

1345: SELECT JSA.RSC_LOV_SQL
1346: INTO l_rsc_lov_sql
1347: FROM JTF_TERR_ALL JTA,
1348: JTF_TERR_RSC_ALL JTR,
1349: JTF_TERR_USGS_ALL JTU,
1350: JTF_SOURCES_ALL JSA
1351: WHERE JTR.terr_rsc_id = P_TerrRsc_Rec.Terr_Rsc_Id
1352: AND JTR.TERR_ID = JTA.Terr_Id
1353: AND JTA.TERR_ID = JTU.TERR_ID