APPS.INVPVDR5 dependencies on MTL_SYSTEM_ITEMS_B

Line 1180: FROM mtl_system_items_b

1176: ELSIF cr.transaction_type ='UPDATE' THEN
1177:
1178: SELECT item_catalog_group_id
1179: INTO l_old_catalog_id
1180: FROM mtl_system_items_b
1181: WHERE inventory_item_id = cr.inventory_item_id
1182: AND organization_id = cr.organization_id;
1183:
1184: --Bug: 2805253 Modified the validation

Line 1251: from mtl_system_items_b

1247: l_source_subinv_error := FALSE;
1248: if ( cr.ORGANIZATION_ID <> cr.SOURCE_ORGANIZATION_ID ) then
1249: select restrict_subinventories_code
1250: into l_source_restrict_sub
1251: from mtl_system_items_b
1252: where organization_id = cr.SOURCE_ORGANIZATION_ID
1253: and inventory_item_id = cr.INVENTORY_ITEM_ID;
1254: else
1255: l_source_restrict_sub := nvl(cr.RESTRICT_SUBINVENTORIES_CODE, 2) ;