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.JTY_TERR_TRIGGER_HANDLERS dependencies on DUAL

Line 541: USING ( SELECT p_terr_id terr_id from dual ) S

537: END IF;
538: ELSIF (Trigger_Mode = 'ON-DELETE') THEN
539:
540: MERGE INTO jty_changed_terrs A
541: USING ( SELECT p_terr_id terr_id from dual ) S
542: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
543: WHEN MATCHED THEN
544: UPDATE SET
545: A.rank_calc_flag = 'N'

Line 571: USING ( SELECT p_terr_id terr_id from dual ) S

567: ,decode(o_named_acct_flag, 'Y', 'N', 'Y')
568: ,'D');
569:
570: MERGE INTO jty_changed_dea_terrs A
571: USING ( SELECT p_terr_id terr_id from dual ) S
572: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
573: WHEN MATCHED THEN
574: UPDATE SET
575: A.rank_calc_flag = 'N'

Line 1162: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S

1158: IS
1159: BEGIN
1160: IF (triggering_mode = 'ON-INSERT') THEN
1161: MERGE INTO jty_changed_terrs A
1162: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
1163: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
1164: WHEN MATCHED THEN
1165: UPDATE SET
1166: A.source_id = S.source_id

Line 1190: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S

1186: ,'Y'
1187: ,'I');
1188:
1189: MERGE INTO jty_changed_dea_terrs A
1190: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
1191: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
1192: WHEN MATCHED THEN
1193: UPDATE SET
1194: A.source_id = S.source_id

Line 1218: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S

1214: ,'Y'
1215: ,'I');
1216: ELSIF (triggering_mode = 'ON-DELETE') THEN
1217: MERGE INTO jty_changed_terrs A
1218: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
1219: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
1220: WHEN MATCHED THEN
1221: UPDATE SET
1222: A.source_id = S.source_id

Line 1246: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S

1242: ,'Y'
1243: ,'D');
1244:
1245: MERGE INTO jty_changed_dea_terrs A
1246: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
1247: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
1248: WHEN MATCHED THEN
1249: UPDATE SET
1250: A.source_id = S.source_id