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.BOMPIMPL dependencies on MTL_SYSTEM_ITEMS

Line 323: From mtl_system_items msi1,

319: Cursor Check_Configured_Parent(
320: P_Parent_Item in number,
321: P_Comp_Item in number) is
322: Select 1 dummy
323: From mtl_system_items msi1,
324: mtl_system_items msi2
325: Where msi1.inventory_item_id = P_Parent_Item
326: And msi1.organization_id = org_id
327: And msi2.inventory_item_id = P_Comp_Item

Line 324: mtl_system_items msi2

320: P_Parent_Item in number,
321: P_Comp_Item in number) is
322: Select 1 dummy
323: From mtl_system_items msi1,
324: mtl_system_items msi2
325: Where msi1.inventory_item_id = P_Parent_Item
326: And msi1.organization_id = org_id
327: And msi2.inventory_item_id = P_Comp_Item
328: And msi2.organization_id = org_id

Line 336: From mtl_system_items msi

332: And msi2.bom_item_type in (1, 2); -- model or option class
333: Cursor Check_Disabled_Parent(
334: P_Parent_Item in number) is
335: Select 1 dummy
336: From mtl_system_items msi
337: Where msi.inventory_item_id = P_Parent_Item
338: And msi.organization_id = org_id
339: And msi.bom_enabled_flag = 'N';
340: Prune_Tree exception;

Line 628: From mtl_system_items msi1,

624: Cursor Check_Configured_Parent(
625: P_Parent_Item in number,
626: P_Comp_Item in number) is
627: Select 1 dummy
628: From mtl_system_items msi1,
629: mtl_system_items msi2
630: Where msi1.inventory_item_id = P_Parent_Item
631: And msi1.organization_id = org_id
632: And msi2.inventory_item_id = P_Comp_Item

Line 629: mtl_system_items msi2

625: P_Parent_Item in number,
626: P_Comp_Item in number) is
627: Select 1 dummy
628: From mtl_system_items msi1,
629: mtl_system_items msi2
630: Where msi1.inventory_item_id = P_Parent_Item
631: And msi1.organization_id = org_id
632: And msi2.inventory_item_id = P_Comp_Item
633: And msi2.organization_id = org_id

Line 641: From mtl_system_items msi

637: And msi2.bom_item_type in (1, 2); -- model or option class
638: Cursor Check_Disabled_Parent(
639: P_Parent_Item in number) is
640: Select 1 dummy
641: From mtl_system_items msi
642: Where msi.inventory_item_id = P_Parent_Item
643: And msi.organization_id = org_id
644: And msi.bom_enabled_flag = 'N';
645: Prune_Tree exception;