APPS.BOMPIINQ dependencies on MTL_SYSTEM_ITEMS

Line 106: FROM ORG_ACCESS_VIEW oav, MTL_SYSTEM_ITEMS_B msi,

102:
103: elsif ( organization_option = 3 ) then
104: /* Bug:4929268 Performance Fix */
105: for C1 in ( SELECT orgs.ORGANIZATION_ID
106: FROM ORG_ACCESS_VIEW oav, MTL_SYSTEM_ITEMS_B msi,
107: MTL_PARAMETERS orgs, MTL_PARAMETERS child_org
108: WHERE orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID
109: AND msi.ORGANIZATION_ID = orgs.ORGANIZATION_ID
110: AND orgs.MASTER_ORGANIZATION_ID = child_org.MASTER_ORGANIZATION_ID

Line 145: select count(*) into dummy from mtl_system_items where

141: if found then call the Imploder API for the Organization,otherwise
142: check the existence of the Item in the next Organization of the
143: Organization List*/
144:
145: select count(*) into dummy from mtl_system_items where
146: organization_id = t_org_code_list(I) and
147: inventory_item_id = item_id;
148:
149: if dummy <1 then

Line 369: MTL_SYSTEM_ITEMS MSI

365: FROM
366: BOM_SMALL_IMPL_TEMP BITT,
367: BOM_INVENTORY_COMPONENTS BIC,
368: BOM_BILL_OF_MATERIALS BBM,
369: MTL_SYSTEM_ITEMS MSI
370: where bitt.current_level = 0
371: and bitt.organization_id = c_org_id
372: and MSI.ORGANIZATION_ID = BBM.ORGANIZATION_ID
373: and MSI.INVENTORY_ITEM_ID = BBM.ASSEMBLY_ITEM_ID

Line 601: From mtl_system_items msi1,

597: Cursor Check_Configured_Parent(
598: P_Parent_Item in number,
599: P_Comp_Item in number) is
600: Select 1 dummy
601: From mtl_system_items msi1,
602: mtl_system_items msi2
603: Where msi1.inventory_item_id = P_Parent_Item
604: And msi1.organization_id = org_id
605: And msi2.inventory_item_id = P_Comp_Item

Line 602: mtl_system_items msi2

598: P_Parent_Item in number,
599: P_Comp_Item in number) is
600: Select 1 dummy
601: From mtl_system_items msi1,
602: mtl_system_items msi2
603: Where msi1.inventory_item_id = P_Parent_Item
604: And msi1.organization_id = org_id
605: And msi2.inventory_item_id = P_Comp_Item
606: And msi2.organization_id = org_id

Line 614: From mtl_system_items msi

610: And msi2.bom_item_type in (1, 2); -- model or option class
611: Cursor Check_Disabled_Parent(
612: P_Parent_Item in number) is
613: Select 1 dummy
614: From mtl_system_items msi
615: Where msi.inventory_item_id = P_Parent_Item
616: And msi.organization_id = org_id
617: And msi.bom_enabled_flag = 'N';
618:

Line 1020: MTL_SYSTEM_ITEMS MSI

1016: FROM
1017: BOM_SMALL_IMPL_TEMP BITT,
1018: BOM_INVENTORY_COMPONENTS BIC,
1019: BOM_BILL_OF_MATERIALS BBM,
1020: MTL_SYSTEM_ITEMS MSI
1021: where
1022: bitt.current_level = c_current_level
1023: and bitt.organization_id = c_org_id
1024: and msi.organization_id = BBM.organization_id

Line 1135: From mtl_system_items msi1,

1131: Cursor Check_Configured_Parent(
1132: P_Parent_Item in number,
1133: P_Comp_Item in number) is
1134: Select 1 dummy
1135: From mtl_system_items msi1,
1136: mtl_system_items msi2
1137: Where msi1.inventory_item_id = P_Parent_Item
1138: And msi1.organization_id = org_id
1139: And msi2.inventory_item_id = P_Comp_Item

Line 1136: mtl_system_items msi2

1132: P_Parent_Item in number,
1133: P_Comp_Item in number) is
1134: Select 1 dummy
1135: From mtl_system_items msi1,
1136: mtl_system_items msi2
1137: Where msi1.inventory_item_id = P_Parent_Item
1138: And msi1.organization_id = org_id
1139: And msi2.inventory_item_id = P_Comp_Item
1140: And msi2.organization_id = org_id

Line 1148: From mtl_system_items msi

1144: And msi2.bom_item_type in (1, 2); -- model or option class
1145: Cursor Check_Disabled_Parent(
1146: P_Parent_Item in number) is
1147: Select 1 dummy
1148: From mtl_system_items msi
1149: Where msi.inventory_item_id = P_Parent_Item
1150: And msi.organization_id = org_id
1151: And msi.bom_enabled_flag = 'N';
1152: