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_TL

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 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