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 IBE_DSP_LGL_PHYS_MAP

Line 44: FROM ibe_dsp_lgl_phys_map

40: AND status = c_status;
41:
42: CURSOR c_check_item_migrated IS
43: SELECT lgl_phys_map_id
44: FROM ibe_dsp_lgl_phys_map
45: WHERE content_item_key IS NOT NULL;
46:
47: l_temp NUMBER;
48: BEGIN

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 626: FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a

622: c_msite_id NUMBER, c_default_msite VARCHAR2,
623: c_language_code VARCHAR2, c_default_lang VARCHAR2) IS
624: -- SELECT b.file_id, b.display_width, b.display_height, b.file_name
625: SELECT b.file_id, b.display_height, b.display_width, b.file_name
626: FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a
627: WHERE a.attachment_id = b.attachment_id
628: AND a.default_language = c_default_lang
629: AND a.language_code = c_language_code
630: AND a.default_site = c_default_msite

Line 638: FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a

634: CURSOR c_get_any_mapping(c_item_id NUMBER,
635: c_msite_id NUMBER, c_default_msite VARCHAR2) IS
636: -- SELECT b.file_id, b.display_width, b.display_height, b.file_name
637: SELECT b.file_id, b.display_height, b.display_width, b.file_name
638: FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a
639: WHERE a.attachment_id = b.attachment_id
640: AND a.default_site = c_default_msite
641: AND a.msite_id = c_msite_id
642: AND a.item_id = c_item_id;

Line 765: FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a

761: c_msite_id NUMBER, c_default_msite VARCHAR2,
762: c_language_code VARCHAR2, c_default_lang VARCHAR2) IS
763: -- SELECT b.file_id, b.display_width, b.display_height, b.file_name
764: SELECT b.file_id, b.display_height, b.display_width, b.file_name
765: FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a
766: WHERE a.attachment_id = b.attachment_id
767: AND a.default_language = c_default_lang
768: AND a.language_code = c_language_code
769: AND a.default_site = c_default_msite

Line 994: SELECT IBE_DSP_LGL_PHYS_MAP_S1.nextval

990: FROM ibc_content_items
991: WHERE item_reference_code = c_item_ref_code;
992:
993: CURSOR c_get_lgl_phys_map_id_csr IS
994: SELECT IBE_DSP_LGL_PHYS_MAP_S1.nextval
995: FROM dual;
996:
997: CURSOR c_check_map(c_item_id NUMBER, c_msite_id NUMBER,
998: c_lang_code VARCHAR2, c_def_msite VARCHAR2, c_def_lang VARCHAR2) IS

Line 1000: FROM IBE_DSP_LGL_PHYS_MAP

996:
997: CURSOR c_check_map(c_item_id NUMBER, c_msite_id NUMBER,
998: c_lang_code VARCHAR2, c_def_msite VARCHAR2, c_def_lang VARCHAR2) IS
999: SELECT 1
1000: FROM IBE_DSP_LGL_PHYS_MAP
1001: WHERE item_id = c_item_id
1002: AND msite_id = c_msite_id
1003: AND language_code = c_lang_code
1004: AND default_site = c_def_msite

Line 1369: INSERT INTO ibe_dsp_lgl_phys_map

1365: printDebugLog('def site:'||px_attachment_rec.default_site);
1366: printDebugLog('content key:'||TO_CHAR(l_content_item_id));
1367: END IF;
1368: x_msg_data := 'Error when creating mapping';
1369: INSERT INTO ibe_dsp_lgl_phys_map
1370: (LGL_PHYS_MAP_ID,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1371: LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,MSITE_ID,
1372: LANGUAGE_CODE, ATTACHMENT_ID, ITEM_ID, DEFAULT_LANGUAGE,
1373: DEFAULT_SITE, CONTENT_ITEM_KEY)

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 1642: DELETE FROM ibe_dsp_lgl_phys_map a

1638: IF c_get_date_csr%FOUND THEN
1639: CLOSE c_get_date_csr;
1640: -- Add type checking for media mapping only
1641: -- Fix perf bug 2854588, sql id 5044423
1642: DELETE FROM ibe_dsp_lgl_phys_map a
1643: WHERE lgl_phys_map_id >= 10000
1644: AND content_item_key IS NULL
1645: AND last_update_date <= l_date
1646: AND attachment_id <> -1

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 1714: -- from ibe_dsp_lgl_phys_map a

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
1715: -- where a.item_id = b.item_id
1716: -- and a.last_updated_by <> 1)
1717: -- ORDER BY b.item_id;
1718:

Line 1726: FROM ibe_dsp_lgl_phys_map a

1722: SELECT b.msite_id, b.msite_name, decode(b.msite_id,1,'Y','N'),
1723: b.default_language_code
1724: from ibe_msites_vl b
1725: where EXISTS (select NULL
1726: FROM ibe_dsp_lgl_phys_map a
1727: WHERE a.msite_id = b.msite_id
1728: AND a.item_id = c_item_id
1729: AND b.site_type = 'I'
1730: AND a.content_item_key IS NULL)

Line 1737: FROM ibe_dsp_lgl_phys_map

1733: -- This cursor is to check if a seeded media object
1734: -- has default seeded mapping
1735: CURSOR c_get_seed_flag_csr(c_item_id NUMBER) IS
1736: SELECT 'Y'
1737: FROM ibe_dsp_lgl_phys_map
1738: WHERE content_item_key IS NULL
1739: AND default_site = 'Y'
1740: AND item_id = c_item_id
1741: AND lgl_phys_map_id < 10000;

Line 1755: FROM ibe_dsp_lgl_phys_map b

1751: AND file_id IS NOT NULL
1752: AND attachment_used_by = 'ITEM'
1753: AND NOT EXISTS (
1754: SELECT NULL
1755: FROM ibe_dsp_lgl_phys_map b
1756: WHERE b.attachment_id = a.attachment_id);
1757:
1758: l_lang VARCHAR2(4);
1759: l_langdesc VARCHAR2(255);