DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

Line 2419: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b

2415: l_inventory_item_id := to_number(l_attribute_value);
2416: --inv_debug.message('ssia', 'l_inventory_item_id is ' || l_inventory_item_id);
2417: select count(s.inventory_item_id)
2418: into l_item_exists
2419: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b
2420: where s.section_item_id = b.section_item_id
2421: and b.mini_site_id = p_minisite_id
2422: and s.inventory_item_id = l_inventory_item_id
2423: and (s.end_date_active > sysdate or s.end_date_active is null )

Line 3202: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b

3198: IF p_merchant_item_ids(i) IS NOT NULL THEN
3199: --inv_debug.message('ssia', 'p_cust_item_number is ' || p_cust_item_number_tbl(i));
3200: select count(s.inventory_item_id)
3201: into l_item_exists
3202: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b
3203: where s.section_item_id = b.section_item_id
3204: and b.mini_site_id = p_minisite_id
3205: and s.inventory_item_id = p_merchant_item_ids(i)
3206: and (s.end_date_active > sysdate or s.end_date_active is null )