DBA Data[Home] [Help]

APPS.IBE_CATALOG_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

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.organization_id = p_organization_id_tbl(i) -- bug 10092967, scnagara

Line 3188: from ibe_dsp_msite_sct_items a, ibe_dsp_section_items b

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