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.IBE_M_MIGRATION_PVT dependencies on JTF_AMV_ITEMS_B

Line 574: FROM ibe_dsp_lgl_phys_map b, jtf_amv_items_b c

570: AND file_id IS NOT NULL
571: AND attachment_used_by = 'ITEM'
572: AND NOT EXISTS (
573: SELECT NULL
574: FROM ibe_dsp_lgl_phys_map b, jtf_amv_items_b c
575: WHERE a.attachment_id = b.attachment_id
576: AND c.item_id = b.item_id
577: AND c.deliverable_type_code = 'TEMPLATE');
578:

Line 1622: FROM ibe_dsp_lgl_phys_map b, jtf_amv_items_b c

1618: AND last_update_date < l_date
1619: AND attachment_used_by = 'ITEM'
1620: AND NOT EXISTS (
1621: SELECT NULL
1622: FROM ibe_dsp_lgl_phys_map b, jtf_amv_items_b c
1623: WHERE a.attachment_id = b.attachment_id
1624: AND b.item_id = c.item_id
1625: AND c.deliverable_type_code = 'TEMPLATE');
1626:

Line 1649: FROM jtf_amv_items_b c

1645: AND last_update_date <= l_date
1646: AND attachment_id <> -1
1647: AND EXISTS (
1648: SELECT NULL
1649: FROM jtf_amv_items_b c
1650: WHERE a.item_id = c.item_id
1651: AND c.deliverable_type_code = 'MEDIA'
1652: AND c.application_id = 671);
1653:

Line 1673: -- FROM ibe_dsp_lgl_phys_map b, jtf_amv_items_b c

1669: -- AND last_update_date < l_date
1670: -- AND attachment_used_by = 'ITEM'
1671: -- AND NOT EXISTS (
1672: -- SELECT NULL
1673: -- FROM ibe_dsp_lgl_phys_map b, jtf_amv_items_b c
1674: -- WHERE a.attachment_id = b.attachment_id
1675: -- AND b.item_id = c.item_id
1676: -- AND c.deliverable_type_code = 'TEMPLATE');
1677: COMMIT;

Line 1704: from jtf_amv_items_b b

1700: -- It is using last_updated_by instead of lgl_phys_map_id
1701: -- to make sure the data owner is 'SEED'.
1702: CURSOR c_get_item_csr IS
1703: select b.item_id, b.access_name
1704: from jtf_amv_items_b b
1705: where b.deliverable_type_code <> 'TEMPLATE'
1706: and b.application_id = 671
1707: ORDER BY b.item_id;
1708: -- CURSOR c_get_item_csr IS

Line 1710: -- from jtf_amv_items_b b

1706: and b.application_id = 671
1707: ORDER BY b.item_id;
1708: -- CURSOR c_get_item_csr IS
1709: -- select b.item_id, b.access_name
1710: -- from jtf_amv_items_b b
1711: -- where b.deliverable_type_code <> 'TEMPLATE'
1712: -- and b.application_id = 671
1713: -- and exists (select null
1714: -- from ibe_dsp_lgl_phys_map a