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_WINNERS

Line 270: FROM JTF_TAE_1001_QUOTE_WINNERS

266:
267: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
268: IS
269: SELECT count(*)
270: FROM JTF_TAE_1001_QUOTE_WINNERS
271: WHERE request_id = c_request_id
272: AND resource_type = c_resource_type
273: AND worker_id = c_worker_id
274: AND ROWNUM < 2;

Line 313: INSERT INTO JTF_TAE_1001_QUOTE_WINNERS

309: /** Note
310: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
311: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
312: **/
313: INSERT INTO JTF_TAE_1001_QUOTE_WINNERS
314: (trans_object_id,
315: trans_detail_object_id,
316: terr_id,
317: resource_id,

Line 372: JTF_TAE_1001_QUOTE_WINNERS T,

368: J.person_id,
369: T.org_id,
370: T.worker_id
371: FROM
372: JTF_TAE_1001_QUOTE_WINNERS T,
373: (
374: SELECT TM.team_resource_id resource_id,
375: TM.person_id person_id2,
376: MIN(G.group_id)group_id,

Line 486: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_QUOTE_WINNERS rt1

482: WHERE j.team_id = t.resource_id
483: AND t.request_id = l_request_id
484: AND t.worker_id = l_worker_id
485: AND t.resource_type = 'RS_TEAM'
486: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_QUOTE_WINNERS rt1
487: WHERE rt1.resource_id = j.resource_id
488: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
489: AND rt1.request_id = t.request_id
490: AND rt1.worker_id = t.worker_id

Line 537: FROM JTF_TAE_1001_QUOTE_WINNERS

533:
534: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
535: IS
536: SELECT count(*)
537: FROM JTF_TAE_1001_QUOTE_WINNERS
538: WHERE request_id = c_request_id
539: AND resource_type = c_resource_type
540: AND worker_id = c_worker_id
541: AND ROWNUM < 2;

Line 581: INSERT INTO JTF_TAE_1001_QUOTE_WINNERS

577: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
578: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
579: **/
580:
581: INSERT INTO JTF_TAE_1001_QUOTE_WINNERS
582: (trans_object_id,
583: trans_detail_object_id,
584: terr_id,
585: resource_id,

Line 641: JTF_TAE_1001_QUOTE_WINNERS t,

637: J.person_id,
638: T.org_id,
639: T.worker_id
640: FROM
641: JTF_TAE_1001_QUOTE_WINNERS t,
642: (
643: SELECT MIN(m.resource_id) resource_id,
644: res.CATEGORY resource_category,
645: m.group_id group_id, MIN(res.source_id) person_id

Line 671: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_QUOTE_WINNERS rt1

667: WHERE j.group_id = t.resource_id
668: AND t.request_id = l_request_id
669: AND t.worker_id = l_worker_id
670: AND t.resource_type = 'RS_GROUP'
671: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_QUOTE_WINNERS rt1
672: WHERE rt1.resource_id = j.resource_id
673: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
674: AND rt1.request_id = t.request_id
675: AND rt1.worker_id = t.worker_id

Line 738: FROM JTF_TAE_1001_QUOTE_WINNERS WIN,

734:
735: CURSOR merge_records(c_worker_id number) IS
736: SELECT DISTINCT
737: A.quote_number , A.resource_id
738: FROM JTF_TAE_1001_QUOTE_WINNERS WIN,
739: ASO_QUOTE_ACCESSES A
740: WHERE WIN.trans_object_id = A.quote_number
741: AND WIN.source_id = -1001
742: AND WIN.resource_id = A.RESOURCE_ID

Line 750: FROM JTF_TAE_1001_QUOTE_WINNERS WIN1

746: AND (NVL(win.group_id,-777) <> NVL(A.resource_grp_id,-777)
747: OR NVL(win.role_id,-777) <> NVL(A.role_id,-777))
748: AND NOT EXISTS
749: (SELECT 'X'
750: FROM JTF_TAE_1001_QUOTE_WINNERS WIN1
751: WHERE WIN1.trans_object_id = A.quote_number
752: AND WIN1.source_id = -1001
753: AND WIN1.resource_id = A.RESOURCE_ID
754: AND WIN1.worker_id = c_worker_id

Line 809: FROM JTF_TAE_1001_QUOTE_WINNERS W

805: role_id ,
806: territory_id )
807: = (
808: SELECT MAX(W.full_access_flag ),MIN( W.group_id),MIN(w.role_id) ,MIN(W.terr_id)
809: FROM JTF_TAE_1001_QUOTE_WINNERS W
810: WHERE trans_object_id = l_quote_number_id(I)
811: AND resource_id = l_resource_id(i)
812: GROUP BY trans_object_id,resource_id
813: )

Line 836: FROM JTF_TAE_1001_QUOTE_WINNERS W

832: role_id ,
833: territory_id )
834: = (
835: SELECT MAX(W.full_access_flag ),MIN( W.group_id),MIN(w.role_id) ,MIN(W.terr_id)
836: FROM JTF_TAE_1001_QUOTE_WINNERS W
837: WHERE trans_object_id = l_quote_number_id(I)
838: AND resource_id = l_resource_id(i)
839: GROUP BY trans_object_id,resource_id
840: )

Line 910: FROM JTF_TAE_1001_QUOTE_WINNERS WIN,

906:
907: CURSOR merge_records(c_worker_id number) IS
908: SELECT DISTINCT
909: A.access_id,WIN.full_access_flag,WIN.terr_id
910: FROM JTF_TAE_1001_QUOTE_WINNERS WIN,
911: ASO_QUOTE_ACCESSES A
912: WHERE WIN.trans_object_id = A.quote_number
913: AND WIN.source_id = -1001
914: AND WIN.resource_id = A.RESOURCE_ID

Line 1070: FROM JTF_TAE_1001_QUOTE_WINNERS W

1066: MIN(W.group_id),
1067: MIN(W.role_id) ,
1068: MAX(W.full_access_flag ) faf,
1069: MIN(W.terr_id)
1070: FROM JTF_TAE_1001_QUOTE_WINNERS W
1071: WHERE W.resource_type = 'RS_EMPLOYEE'
1072: AND W.source_id = -1001
1073: AND W.worker_id = c_worker_id
1074: AND NOT EXISTS

Line 1290: FROM JTF_TAE_1001_QUOTE_WINNERS W

1286: CURSOR ins_tacc(c_worker_id number) IS
1287: SELECT w.terr_id
1288: ,w.trans_object_id
1289: ,w.resource_id
1290: FROM JTF_TAE_1001_QUOTE_WINNERS W
1291: WHERE W.SOURCE_ID = -1001
1292: AND W.worker_id = c_worker_id
1293: AND W.resource_type = 'RS_EMPLOYEE'
1294: GROUP BY W.TERR_ID,

Line 2105: FROM JTF_TAE_1001_QUOTE_WINNERS

2101: sales person if winners not returning any records so same kind of logic followed here also
2102: */
2103: CURSOR del_quote_totalmode(c_worker_id number) IS
2104: SELECT distinct trans_object_id
2105: FROM JTF_TAE_1001_QUOTE_WINNERS
2106: WHERE worker_id=c_worker_id;
2107:
2108: BEGIN
2109: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);

Line 2159: FROM JTF_TAE_1001_QUOTE_WINNERS W

2155: DELETE FROM ASO_QUOTE_ACCESSES ACC
2156: WHERE ACC.QUOTE_NUMBER =l_quote_number_id(i)
2157: AND NVL(ACC.KEEP_FLAG,'N') <> 'Y'
2158: AND NOT EXISTS (SELECT 'X'
2159: FROM JTF_TAE_1001_QUOTE_WINNERS W
2160: WHERE W.TRANS_OBJECT_ID = ACC.QUOTE_NUMBER
2161: AND W.WORKER_ID = l_worker_id
2162: AND W.RESOURCE_ID = ACC.RESOURCE_ID)
2163: AND ROWNUM < G_DEL_REC;

Line 2181: FROM JTF_TAE_1001_QUOTE_WINNERS W

2177: DELETE FROM ASO_QUOTE_ACCESSES ACC
2178: WHERE ACC.QUOTE_NUMBER =l_quote_number_id(i)
2179: AND NVL(ACC.KEEP_FLAG,'N') <> 'Y'
2180: AND NOT EXISTS (SELECT 'X'
2181: FROM JTF_TAE_1001_QUOTE_WINNERS W
2182: WHERE W.TRANS_OBJECT_ID = ACC.QUOTE_NUMBER
2183: AND W.WORKER_ID = l_worker_id
2184: AND W.RESOURCE_ID = ACC.RESOURCE_ID);
2185: COMMIT;