APPS.BOM_IMPLODER_PUB dependencies on MTL_SYSTEM_ITEMS

Line 346: from MTL_SYSTEM_ITEMS_B MSI,

342: and (
343: (
344: bbm.obj_name = 'EGO_ITEM' or bbm.obj_name is NULL
345: and (exists (select 'X'
346: from MTL_SYSTEM_ITEMS_B MSI,
347: MTL_SYSTEM_ITEMS_B MSI_CHILD
348: where MSI.ORGANIZATION_ID = BBM.ORGANIZATION_ID
349: and MSI.INVENTORY_ITEM_ID = BBM.ASSEMBLY_ITEM_ID
350: AND MSI_CHILD.ORGANIZATION_ID = BBM.ORGANIZATION_ID

Line 347: MTL_SYSTEM_ITEMS_B MSI_CHILD

343: (
344: bbm.obj_name = 'EGO_ITEM' or bbm.obj_name is NULL
345: and (exists (select 'X'
346: from MTL_SYSTEM_ITEMS_B MSI,
347: MTL_SYSTEM_ITEMS_B MSI_CHILD
348: where MSI.ORGANIZATION_ID = BBM.ORGANIZATION_ID
349: and MSI.INVENTORY_ITEM_ID = BBM.ASSEMBLY_ITEM_ID
350: AND MSI_CHILD.ORGANIZATION_ID = BBM.ORGANIZATION_ID
351: AND MSI_CHILD.INVENTORY_ITEM_ID = bic.COMPONENT_ITEM_ID

Line 1324: MTL_SYSTEM_ITEMS_B msi,

1320: SELECT
1321: orgs.ORGANIZATION_ID
1322: FROM
1323: ORG_ACCESS_VIEW oav,
1324: MTL_SYSTEM_ITEMS_B msi,
1325: MTL_PARAMETERS orgs,
1326: MTL_PARAMETERS child_org
1327: WHERE
1328: orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID

Line 1361: from mtl_system_items

1357: Organization List*/
1358:
1359: select count(*)
1360: into dummy
1361: from mtl_system_items
1362: where organization_id = t_org_code_list(I)
1363: and inventory_item_id = pk1_value;
1364:
1365: if dummy <1 then