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 382: MTL_SYSTEM_ITEMS MSI

378: FROM
379: BOM_SMALL_IMPL_TEMP BITT,
380: BOM_INVENTORY_COMPONENTS BIC,
381: BOM_BILL_OF_MATERIALS BBM,
382: MTL_SYSTEM_ITEMS MSI
383: where bic.pk1_value = BITT.PARENT_ITEM_ID and
384: bic.pk2_value = NVL(bbm.common_organization_id,bbm.organization_id) and
385: bitt.current_level = 0
386: and bitt.organization_id = c_org_id

Line 616: From mtl_system_items msi1,

612: Cursor Check_Configured_Parent(
613: P_Parent_Item in number,
614: P_Comp_Item in number) is
615: Select 1 dummy
616: From mtl_system_items msi1,
617: mtl_system_items msi2
618: Where msi1.inventory_item_id = P_Parent_Item
619: And msi1.organization_id = org_id
620: And msi2.inventory_item_id = P_Comp_Item

Line 617: mtl_system_items msi2

613: P_Parent_Item in number,
614: P_Comp_Item in number) is
615: Select 1 dummy
616: From mtl_system_items msi1,
617: mtl_system_items msi2
618: Where msi1.inventory_item_id = P_Parent_Item
619: And msi1.organization_id = org_id
620: And msi2.inventory_item_id = P_Comp_Item
621: And msi2.organization_id = org_id

Line 629: From mtl_system_items msi

625: And msi2.bom_item_type in (1, 2); -- model or option class
626: Cursor Check_Disabled_Parent(
627: P_Parent_Item in number) is
628: Select 1 dummy
629: From mtl_system_items msi
630: Where msi.inventory_item_id = P_Parent_Item
631: And msi.organization_id = org_id
632: And msi.bom_enabled_flag = 'N';
633:

Line 1048: MTL_SYSTEM_ITEMS MSI

1044: FROM
1045: BOM_SMALL_IMPL_TEMP BITT,
1046: BOM_INVENTORY_COMPONENTS BIC,
1047: BOM_BILL_OF_MATERIALS BBM,
1048: MTL_SYSTEM_ITEMS MSI
1049: where bic.pk1_value = BITT.PARENT_ITEM_ID and
1050: bic.pk2_value = NVL(bbm.common_organization_id, bbm.organization_id) and
1051: bitt.current_level = c_current_level
1052: and bitt.organization_id = c_org_id

Line 1164: From mtl_system_items msi1,

1160: Cursor Check_Configured_Parent(
1161: P_Parent_Item in number,
1162: P_Comp_Item in number) is
1163: Select 1 dummy
1164: From mtl_system_items msi1,
1165: mtl_system_items msi2
1166: Where msi1.inventory_item_id = P_Parent_Item
1167: And msi1.organization_id = org_id
1168: And msi2.inventory_item_id = P_Comp_Item

Line 1165: mtl_system_items msi2

1161: P_Parent_Item in number,
1162: P_Comp_Item in number) is
1163: Select 1 dummy
1164: From mtl_system_items msi1,
1165: mtl_system_items msi2
1166: Where msi1.inventory_item_id = P_Parent_Item
1167: And msi1.organization_id = org_id
1168: And msi2.inventory_item_id = P_Comp_Item
1169: And msi2.organization_id = org_id

Line 1177: From mtl_system_items msi

1173: And msi2.bom_item_type in (1, 2); -- model or option class
1174: Cursor Check_Disabled_Parent(
1175: P_Parent_Item in number) is
1176: Select 1 dummy
1177: From mtl_system_items msi
1178: Where msi.inventory_item_id = P_Parent_Item
1179: And msi.organization_id = org_id
1180: And msi.bom_enabled_flag = 'N';
1181: