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.JTF_FM_OCM_REND_REQ dependencies on IBC_CITEM_VERSIONS_VL

Line 317: ibc_citem_versions_vl a

313: CURSOR get_file_query1_c is
314: SELECT attachment_file_id
315: FROM
316: ibc_content_items b,
317: ibc_citem_versions_vl a
318: WHERE
319: b.live_citem_version_id = a.citem_version_id
320: AND
321: b.content_item_id = p_citem_id;

Line 325: FROM ibc_citem_versions_vl a,

321: b.content_item_id = p_citem_id;
322:
323: CURSOR get_file_query2_c is
324: SELECT attachment_file_id
325: FROM ibc_citem_versions_vl a,
326: (SELECT MAX(version_number) version_number
327: FROM ibc_citem_versions_b
328: WHERE content_item_id=p_citem_id) b
329: WHERE

Line 380: -- FROM ibc_citem_versions_vl a,

376: -- status which the above SQL won't find.
377: -- So get the latest version of this attachment.
378:
379: -- SELECT attachment_file_id INTO file_id
380: -- FROM ibc_citem_versions_vl a,
381: -- (SELECT MAX(version_number) version_number
382: -- FROM ibc_citem_versions_b
383: -- WHERE content_item_id=p_citem_id) b
384: -- WHERE