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_TRANS

Line 1504: FROM JTF_TAE_1001_QUOTE_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH

1500: CURSOR set_primary_srep_sc1_total(c_worker_id number) IS
1501: SELECT W.trans_object_id, MAX(access_id)
1502: FROM ASO_QUOTE_ACCESSES AQA1,
1503: ( SELECT DISTINCT trans_object_id -- Q8
1504: FROM JTF_TAE_1001_QUOTE_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH
1505: WHERE worker_id=c_worker_id
1506: AND TRANS.trans_object_id = AQH.quote_number
1507: AND NOT EXISTS
1508: (

Line 1564: FROM JTF_TAE_1001_QUOTE_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH

1560: | These quote headers and accesses should be updated with the profile defaults
1561: |-------------------------------------------------------------------------------*/
1562: CURSOR set_primary_srep_sc2_total(c_worker_id NUMBER) IS
1563: SELECT DISTINCT trans_object_id -- Q9, Q10
1564: FROM JTF_TAE_1001_QUOTE_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH
1565: WHERE worker_id=c_worker_id
1566: AND TRANS.trans_object_id = AQH.quote_number
1567: AND NOT EXISTS
1568: (SELECT 'X'