APPS.BOMPCMBM dependencies on MTL_SYSTEM_ITEMS_B

Line 271: MTL_SYSTEM_ITEMS_B msi,

267: SELECT
268: orgs.ORGANIZATION_ID
269: FROM
270: ORG_ACCESS_VIEW oav,
271: MTL_SYSTEM_ITEMS_B msi,
272: MTL_PARAMETERS orgs,
273: MTL_PARAMETERS child_org
274: WHERE
275: orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID

Line 917: FROM MTL_SYSTEM_ITEMS_B ITM

913: /*if default_wip_params = 'Y'
914: then
915: SELECT ITM.WIP_SUPPLY_TYPE, ITM.WIP_SUPPLY_LOCATOR_ID, ITM.WIP_SUPPLY_SUBINVENTORY
916: --INTO l_wip_supply_type, l_locator_id, l_supply_subinventory
917: FROM MTL_SYSTEM_ITEMS_B ITM
918: WHERE inventory_item_id = comp_rec.component_item_id
919: AND organization_id = l_dest_org_id;
920: comp_rec.supply_locator_id := l_locator_id;
921: comp_rec.wip_supply_type := l_wip_supply_type;

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

1085: , comp_rec.from_minor_revision_id
1086: , comp_rec.component_sequence_id
1087: , comp_rec.basis_type
1088: , 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))
1089: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom
1090: WHERE comp_rec.bill_sequence_id = p_src_bill_sequence_id
1091: AND bom.bill_sequence_id = comp_rec.bill_sequence_id
1092: AND comp_rec.COMPONENT_ITEM_ID = item.inventory_item_id
1093: AND item.organization_id = l_dest_org_id

Line 1358: FROM MTL_SYSTEM_ITEMS_B

1354: if default_wip_params = 1
1355: then
1356: SELECT WIP_SUPPLY_TYPE, WIP_SUPPLY_LOCATOR_ID, WIP_SUPPLY_SUBINVENTORY
1357: INTO l_wip_supply_type, l_locator_id, l_supply_subinventory
1358: FROM MTL_SYSTEM_ITEMS_B
1359: WHERE inventory_item_id = src_comp_details.component_item_id
1360: AND organization_id = bill_rec.organization_id;
1361: src_comp_details.supply_locator_id := l_locator_id;
1362: src_comp_details.wip_supply_type := l_wip_supply_type;