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_ASSIGN_REALTIME_PUB dependencies on JTF_QUAL_TYPES_ALL

Line 331: , jtf_qual_types_all jqta

327: ) WT
328: , jtf_terr_all jta
329: , jtf_terr_rsc_all jtr
330: , jtf_terr_rsc_access_all jtra
331: , jtf_qual_types_all jqta
332: , jtf_rs_roles_b inv
333: WHERE WT.terr_id = jta.terr_id
334: AND WT.terr_id = jtr.terr_id
335: AND ( (TRUNC(jtr.start_date_active) BETWEEN trunc(p_plan_start_date) AND trunc(p_plan_end_date) ) OR

Line 485: , jtf_qual_types_all jqta

481: ) WT
482: , jtf_terr_all jta
483: , jtf_terr_rsc_all jtr
484: , jtf_terr_rsc_access_all jtra
485: , jtf_qual_types_all jqta
486: , jtf_rs_roles_b inv
487: WHERE WT.terr_id = jta.terr_id
488: AND WT.terr_id = jtr.terr_id
489: AND jtr.end_date_active >= WT.txn_date

Line 587: , jtf_qual_types_all jqta

583: SELECT 1
584: FROM
585: jtf_terr_rsc_all jtr
586: , jtf_terr_rsc_access_all jtra
587: , jtf_qual_types_all jqta
588: WHERE WT.terr_id = jtr.terr_id
589: AND jtr.end_date_active >= WT.txn_date
590: AND jtr.start_date_active <= WT.txn_date
591: AND jtr.resource_type <> 'RS_ROLE'

Line 779: , jtf_qual_types_all jqta

775: , jtf_terr_all jta
776: , jtf_terr_all jta_p
777: , jtf_terr_rsc_all jtr
778: , jtf_terr_rsc_access_all jtra
779: , jtf_qual_types_all jqta
780: , (select a.group_id resource_id, a.group_name resource_name, 'RS_GROUP' resource_type
781: from jtf_rs_groups_tl a
782: where a.language = userenv('LANG')
783: union all

Line 1365: , jtf_qual_types_all jqta

1361: ) WINNERS
1362: , jtf_terr_all jta
1363: , jtf_terr_rsc_all jtr
1364: , jtf_terr_rsc_access_all jtra
1365: , jtf_qual_types_all jqta
1366: , jtf_rs_roles_b inv
1367: WHERE WINNERS.win_terr_id = jta.terr_id
1368: AND WINNERS.win_terr_id = jtr.terr_id
1369: AND jtr.end_date_active >= WINNERS.txn_date

Line 1562: , jtf_qual_types_all jqta

1558: SELECT 1
1559: FROM
1560: jtf_terr_rsc_all jtr
1561: , jtf_terr_rsc_access_all jtra
1562: , jtf_qual_types_all jqta
1563: WHERE WINNERS.win_terr_id = jtr.terr_id
1564: AND jtr.end_date_active >= WINNERS.txn_date
1565: AND jtr.start_date_active <= WINNERS.txn_date
1566: AND jtr.resource_type <> 'RS_ROLE'

Line 1851: , jtf_qual_types_all jqta

1847: , jtf_terr_all jta
1848: , jtf_terr_all jta_p
1849: , jtf_terr_rsc_all jtr
1850: , jtf_terr_rsc_access_all jtra
1851: , jtf_qual_types_all jqta
1852: , (select a.group_id resource_id, a.group_name resource_name, 'RS_GROUP' resource_type
1853: from jtf_rs_groups_tl a
1854: where a.language = userenv('LANG')
1855: union all