APPS.IBE_CATALOG_PVT dependencies on IBE_DSP_SECTION_ITEMS

Line 84: 'FROM IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B MSIB ' ||

80: L_MSIB_STMT CONSTANT VARCHAR2(2000) :=
81: 'SELECT si.inventory_item_id, si.organization_id, si.usage_name, MSIB.web_status, ' ||
82: ' si.start_date_active assoc_start_dt, si.end_date_active assoc_end_date, ' ||
83: ' MSIB.start_date_active start_dt, MSIB.end_date_active end_dt ' ||
84: 'FROM IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B MSIB ' ||
85: 'WHERE si.section_id = :sect_id ' ||
86: 'AND si.inventory_item_id = MSIB.inventory_item_id ' ||
87: 'AND si.organization_id = MSIB.organization_id ' ||
88: 'AND (MSIB.WEB_STATUS = ''PUBLISHED'' OR MSIB.WEB_STATUS = ''UNPUBLISHED'') ' ||

Line 99: 'FROM IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_VL MSIV ' ||

95: L_MSIV_STMT CONSTANT VARCHAR2(2000) :=
96: 'SELECT si.inventory_item_id, si.organization_id, si.usage_name, MSIV.web_status, ' ||
97: ' si.start_date_active assoc_start_dt, si.end_date_active assoc_end_dt, ' ||
98: ' MSIV.start_date_active start_dt, MSIV.end_date_active end_dt ' ||
99: 'FROM IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_VL MSIV ' ||
100: 'WHERE si.section_id = :sect_id ' ||
101: 'AND si.inventory_item_id = MSIV.inventory_item_id ' ||
102: 'AND si.organization_id = MSIV.organization_id ' ||
103: 'AND (MSIV.WEB_STATUS = ''PUBLISHED'' OR MSIV.WEB_STATUS = ''UNPUBLISHED'') ' ||

Line 1770: FROM ibe_dsp_section_items s, ibe_dsp_msite_sct_items b

1766: x_valid_qty_tbl(i)= '') THEN
1767: BEGIN
1768: SELECT count(s.inventory_item_id)
1769: INTO l_item_exists
1770: FROM ibe_dsp_section_items s, ibe_dsp_msite_sct_items b
1771: WHERE s.section_item_id = b.section_item_id
1772: AND b.mini_site_id = p_msite_id
1773: AND s.inventory_item_id = p_item_id_tbl(i)
1774: AND (s.end_date_active > sysdate or s.end_date_active is null )

Line 3187: from ibe_dsp_msite_sct_items a, ibe_dsp_section_items b

3183: l_status VARCHAR2(5);
3184: l_init_msg_list VARCHAR2(5);
3185: cursor l_itms_msite_csr(l_temp_key VARCHAR2, l_minisite_id NUMBER) IS
3186: select b.inventory_item_id
3187: from ibe_dsp_msite_sct_items a, ibe_dsp_section_items b
3188: where a.section_item_id = b.section_item_id
3189: and a.mini_site_id = l_minisite_id and b.inventory_item_id IN
3190: (select NUM_VAL from IBE_TEMP_TABLE where key = l_temp_key );
3191: