DBA Data[Home] [Help]

APPS.BOMPIMPL dependencies on MTL_SYSTEM_ITEMS

Line 316: From mtl_system_items msi1,

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

Line 317: mtl_system_items msi2

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

Line 329: From mtl_system_items msi

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;

Line 615: From mtl_system_items msi1,

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

Line 616: mtl_system_items msi2

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

Line 628: From mtl_system_items msi

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;