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.JTM_CON_QUERY_REQUEST_PKG dependencies on JTM_PUB_ACC

Line 24: , jtm_pub_acc pubacc

20: /*** cursor retriving the primary key of pub_item associated with this query ***/
21: CURSOR c_primary_key(b_con_query_id NUMBER) IS
22: SELECT distinct pubitm.primary_key_column
23: FROM asg_pub_item pubitm
24: , jtm_pub_acc pubacc
25: WHERE pubacc.publication_item_name = pubitm.name
26: AND pubacc.con_query_id = b_con_query_id
27: AND pubacc.execute_flag = 'Y'
28: AND pubitm.status = 'Y'

Line 510: TYPE pitnameTab IS TABLE OF JTM_PUB_ACC.PUBLICATION_ITEM_NAME%TYPE INDEX BY BINARY_INTEGER;

506: ,p_accessList IN ASG_DOWNLOAD.ACCESS_LIST
507: ,p_dml_type IN CHAR
508: ) RETURN BOOLEAN IS
509:
510: TYPE pitnameTab IS TABLE OF JTM_PUB_ACC.PUBLICATION_ITEM_NAME%TYPE INDEX BY BINARY_INTEGER;
511: l_publication_item_name pitnameTab;
512:
513: local_item_resources c_item_resources%ROWTYPE;
514: local_tab_resource ASG_DOWNLOAD.USER_LIST;

Line 520: FROM JTM_PUB_ACC WHERE CON_QUERY_ID = p_con_query_id;

516: j BINARY_INTEGER;
517:
518: BEGIN
519: SELECT publication_item_name BULK COLLECT INTO l_publication_item_name
520: FROM JTM_PUB_ACC WHERE CON_QUERY_ID = p_con_query_id;
521:
522: IF(l_publication_item_name.COUNT >0) THEN
523: FOR j IN l_publication_item_name.FIRST..l_publication_item_name.LAST LOOP
524: