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.AS_GAR_QOT_PUB dependencies on JTF_TAE_1001_QUOTE_NM_TRANS

Line 1532: FROM JTF_TAE_1001_QUOTE_NM_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH

1528: CURSOR set_primary_srep_sc1_nm(c_worker_id number) IS
1529: SELECT W.trans_object_id, MAX(access_id)
1530: FROM ASO_QUOTE_ACCESSES AQA1,
1531: ( SELECT DISTINCT trans_object_id -- Q8
1532: FROM JTF_TAE_1001_QUOTE_NM_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH
1533: WHERE worker_id=c_worker_id
1534: AND TRANS.trans_object_id = AQH.quote_number
1535: AND NOT EXISTS
1536: (

Line 1581: FROM JTF_TAE_1001_QUOTE_NM_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH

1577: GROUP BY trans_object_id;
1578:
1579: CURSOR set_primary_srep_sc2_nm(c_worker_id NUMBER) IS
1580: SELECT DISTINCT trans_object_id -- Q9, Q10
1581: FROM JTF_TAE_1001_QUOTE_NM_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH
1582: WHERE worker_id=c_worker_id
1583: AND TRANS.trans_object_id = AQH.quote_number
1584: AND NOT EXISTS
1585: (SELECT 'X'