312: Cursor Check_Configured_Parent(
313: P_Parent_Item in number,
314: P_Comp_Item in number) is
315: Select 1 dummy
316: From mtl_system_items msi1,
317: mtl_system_items msi2
318: Where msi1.inventory_item_id = P_Parent_Item
319: And msi1.organization_id = org_id
320: And msi2.inventory_item_id = P_Comp_Item
313: P_Parent_Item in number,
314: P_Comp_Item in number) is
315: Select 1 dummy
316: From mtl_system_items msi1,
317: mtl_system_items msi2
318: Where msi1.inventory_item_id = P_Parent_Item
319: And msi1.organization_id = org_id
320: And msi2.inventory_item_id = P_Comp_Item
321: And msi2.organization_id = org_id
325: And msi2.bom_item_type in (1, 2); -- model or option class
326: Cursor Check_Disabled_Parent(
327: P_Parent_Item in number) is
328: Select 1 dummy
329: From mtl_system_items msi
330: Where msi.inventory_item_id = P_Parent_Item
331: And msi.organization_id = org_id
332: And msi.bom_enabled_flag = 'N';
333: Prune_Tree exception;
611: Cursor Check_Configured_Parent(
612: P_Parent_Item in number,
613: P_Comp_Item in number) is
614: Select 1 dummy
615: From mtl_system_items msi1,
616: mtl_system_items msi2
617: Where msi1.inventory_item_id = P_Parent_Item
618: And msi1.organization_id = org_id
619: And msi2.inventory_item_id = P_Comp_Item
612: P_Parent_Item in number,
613: P_Comp_Item in number) is
614: Select 1 dummy
615: From mtl_system_items msi1,
616: mtl_system_items msi2
617: Where msi1.inventory_item_id = P_Parent_Item
618: And msi1.organization_id = org_id
619: And msi2.inventory_item_id = P_Comp_Item
620: And msi2.organization_id = org_id
624: And msi2.bom_item_type in (1, 2); -- model or option class
625: Cursor Check_Disabled_Parent(
626: P_Parent_Item in number) is
627: Select 1 dummy
628: From mtl_system_items msi
629: Where msi.inventory_item_id = P_Parent_Item
630: And msi.organization_id = org_id
631: And msi.bom_enabled_flag = 'N';
632: Prune_Tree exception;