APPS.BOMPCMBM dependencies on MTL_SYSTEM_ITEMS_B

Line 369: MTL_SYSTEM_ITEMS_B msi,

365: SELECT
366: orgs.ORGANIZATION_ID
367: FROM
368: ORG_ACCESS_VIEW oav,
369: MTL_SYSTEM_ITEMS_B msi,
370: MTL_PARAMETERS orgs,
371: MTL_PARAMETERS child_org
372: WHERE
373: orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID

Line 1121: FROM MTL_SYSTEM_ITEMS_B ITM

1117: /*if default_wip_params = 'Y'
1118: then
1119: SELECT ITM.WIP_SUPPLY_TYPE, ITM.WIP_SUPPLY_LOCATOR_ID, ITM.WIP_SUPPLY_SUBINVENTORY
1120: --INTO l_wip_supply_type, l_locator_id, l_supply_subinventory
1121: FROM MTL_SYSTEM_ITEMS_B ITM
1122: WHERE inventory_item_id = comp_rec.component_item_id
1123: AND organization_id = l_dest_org_id;
1124: comp_rec.supply_locator_id := l_locator_id;
1125: comp_rec.wip_supply_type := l_wip_supply_type;

Line 1294: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom

1290: , comp_rec.from_minor_revision_id
1291: , comp_rec.component_sequence_id
1292: , comp_rec.basis_type
1293: , decode(comp_rec.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(comp_rec.component_item_revision_id, l_dest_org_id))
1294: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom
1295: WHERE comp_rec.bill_sequence_id = p_src_bill_sequence_id
1296: AND bom.bill_sequence_id = comp_rec.bill_sequence_id
1297: AND comp_rec.COMPONENT_ITEM_ID = item.inventory_item_id
1298: AND item.organization_id = l_dest_org_id

Line 1563: FROM MTL_SYSTEM_ITEMS_B

1559: if default_wip_params = 1
1560: then
1561: SELECT WIP_SUPPLY_TYPE, WIP_SUPPLY_LOCATOR_ID, WIP_SUPPLY_SUBINVENTORY
1562: INTO l_wip_supply_type, l_locator_id, l_supply_subinventory
1563: FROM MTL_SYSTEM_ITEMS_B
1564: WHERE inventory_item_id = src_comp_details.component_item_id
1565: AND organization_id = bill_rec.organization_id;
1566: src_comp_details.supply_locator_id := l_locator_id;
1567: src_comp_details.wip_supply_type := l_wip_supply_type;