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_SEARCH_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 22: |MTL_SYSTEM_ITEMS_B

Line 38: --added on 04/18 code to join on mtl_system_items_b

34:
35: -----------------------------------------------
36: --PROCEDURE CALLED ON INSERT IN ITEM CATEGORIES
37: --HERE YOU NEED TO INSERT A NEW ROW INTO IMEDIA_SEARCH TABLE
38: --added on 04/18 code to join on mtl_system_items_b
39: --table to get web status flag over
40: -----------------------------------------------
41: procedure Item_Category_Inserted(
42: new_category_id number,

Line 109: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c

105: new_inventory_item_id, b.LANGUAGE,
106: b.DESCRIPTION, b.LONG_DESCRIPTION,
107: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),
108: new_category_set_id , a.web_status
109: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
110: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
111: and b.organization_id = a.organization_id
112: and b.INVENTORY_ITEM_ID = new_inventory_item_id
113: and b.ORGANIZATION_ID = new_organization_id

Line 137: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c

133: new_inventory_item_id, b.LANGUAGE,
134: b.DESCRIPTION, b.LONG_DESCRIPTION,
135: ibe_search_setup_pvt.WriteToLob(b.description, b.long_description ,c.concatenated_segments),
136: new_category_set_id , a.web_status
137: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
138: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
139: and b.organization_id = a.organization_id
140: and b.INVENTORY_ITEM_ID = new_inventory_item_id
141: and b.ORGANIZATION_ID = new_organization_id

Line 163: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c

159: new_inventory_item_id, b.LANGUAGE,
160: b.DESCRIPTION, b.LONG_DESCRIPTION,
161: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),
162: new_category_set_id , a.web_status
163: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
164: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
165: and b.organization_id = a.organization_id
166: and b.INVENTORY_ITEM_ID = new_inventory_item_id
167: and b.ORGANIZATION_ID = new_organization_id

Line 223: select 1 from mtl_system_items_b item

219: l_web_status VARCHAR2(30);
220: l_temp number;
221:
222: CURSOR c_check_section_item_csr (c_inventory_item_id number, c_organization_id number) is
223: select 1 from mtl_system_items_b item
224: where item.inventory_item_id =c_inventory_item_id
225: and item.organization_id=c_organization_id
226: and item.web_status='PUBLISHED' and
227: exists (select 1 from ibe_dsp_section_items sec_item

Line 324: select web_status into l_web_status from mtl_system_items_b

320: ElSIF new_category_set_id = l_search_category_set THEN
321: ----dbms_output.put_line('Adding row :new category set id = l_search category set');
322: --Insert item into ibe_ct_imedia_search table based on the new value and IBE_SEARCH_WEB_STATUS profile value;
323:
324: select web_status into l_web_status from mtl_system_items_b
325: where inventory_item_id=new_inventory_item_id and organization_id= new_organization_id;
326: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
327:
328: ----dbms_output.put_line('l_web_status='||l_web_status||':search web status='||l_search_web_status);

Line 353: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c

349: new_inventory_item_id, b.LANGUAGE,
350: b.DESCRIPTION, b.LONG_DESCRIPTION,
351: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),
352: new_category_set_id , a.web_status
353: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
354: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
355: and b.organization_id = a.organization_id
356: and b.INVENTORY_ITEM_ID = new_inventory_item_id
357: and b.ORGANIZATION_ID = new_organization_id

Line 490: from mtl_system_items_tl b ,mtl_item_categories d, mtl_system_items_b_kfv a

486: old_inventory_item_id, b.LANGUAGE,
487: b.DESCRIPTION, b.LONG_DESCRIPTION,
488: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),
489: d.category_set_id , new_web_status
490: from mtl_system_items_tl b ,mtl_item_categories d, mtl_system_items_b_kfv a
491: where b.INVENTORY_ITEM_ID = old_inventory_item_id
492: and b.ORGANIZATION_ID = old_organization_id
493: and b.INVENTORY_ITEM_ID = d.INVENTORY_ITEM_ID
494: and b.organization_id = d.organization_id

Line 546: from mtl_system_items_tl b ,mtl_item_categories d, mtl_system_items_b_kfv a

542: old_inventory_item_id, b.LANGUAGE,
543: b.DESCRIPTION, b.LONG_DESCRIPTION,
544: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),
545: d.category_set_id , new_web_status
546: from mtl_system_items_tl b ,mtl_item_categories d, mtl_system_items_b_kfv a
547: where b.INVENTORY_ITEM_ID = old_inventory_item_id
548: and b.ORGANIZATION_ID = old_organization_id
549: and b.INVENTORY_ITEM_ID = d.INVENTORY_ITEM_ID
550: and b.organization_id = d.organization_id

Line 645: select 1 from mtl_system_items_b item

641: l_item_exists Number:=0;
642: l_temp number;
643:
644: CURSOR c_check_section_item_csr (c_inventory_item_id number, c_organization_id number) is
645: select 1 from mtl_system_items_b item
646: where item.inventory_item_id =c_inventory_item_id
647: and item.organization_id=c_organization_id
648: and item.web_status='PUBLISHED' and
649: exists (select 1 from ibe_dsp_section_items sec_item

Line 726: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c

722: new_inventory_item_id, new_LANGUAGE,
723: new_DESCRIPTION, new_LONG_DESCRIPTION,
724: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),
725: c.category_set_id , b.web_status
726: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c
727: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
728: and b.organization_id = a.organization_id
729: and b.INVENTORY_ITEM_ID = new_inventory_item_id
730: and b.ORGANIZATION_ID = new_organization_id

Line 753: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c

749: new_inventory_item_id, new_LANGUAGE,
750: new_DESCRIPTION, new_LONG_DESCRIPTION,
751: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),
752: c.category_set_id , b.web_status
753: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c
754: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
755: and b.organization_id = a.organization_id
756: and b.INVENTORY_ITEM_ID = new_inventory_item_id
757: and b.ORGANIZATION_ID = new_organization_id

Line 779: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c

775: new_inventory_item_id, new_LANGUAGE,
776: new_DESCRIPTION, new_LONG_DESCRIPTION,
777: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),
778: c.category_set_id , b.web_status
779: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c
780: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
781: and b.organization_id = a.organization_id
782: and b.INVENTORY_ITEM_ID = new_inventory_item_id
783: and b.ORGANIZATION_ID = new_organization_id