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.IBC_LOAD_CITEMS_PVT dependencies on IBC_CONTENT_ITEMS

Line 25: from ibc_associations a, ibc_content_items c

21: CURSOR Get_Citems IS
22: SELECT content_item_id, citem_version_id, label_code
23: FROM ibc_citem_version_labels
24: WHERE content_item_id IN (select distinct a.CONTENT_ITEM_ID
25: from ibc_associations a, ibc_content_items c
26: where a.content_item_id = c.content_item_id
27: and c.content_item_status = 'APPROVED'
28: and c.WD_RESTRICTED_FLAG = 'F'
29: and c.LIVE_CITEM_VERSION_ID IS NOT NULL)

Line 37: from ibc_associations a, ibc_content_items c

33: UNION
34: SELECT a.*
35: FROM (select distinct a.CONTENT_ITEM_ID, c.live_citem_version_id as citem_version_id,
36: NULL as label_code
37: from ibc_associations a, ibc_content_items c
38: where a.content_item_id = c.content_item_id
39: and c.content_item_status = 'APPROVED'
40: and c.WD_RESTRICTED_FLAG = 'F'
41: and c.LIVE_CITEM_VERSION_ID IS NOT NULL) a