APPS.INVPVDR5 dependencies on MTL_SYSTEM_ITEMS_B

Line 1151: FROM mtl_system_items_b

1147: ELSIF cr.transaction_type ='UPDATE' THEN
1148:
1149: SELECT item_catalog_group_id
1150: INTO l_old_catalog_id
1151: FROM mtl_system_items_b
1152: WHERE inventory_item_id = cr.inventory_item_id
1153: AND organization_id = cr.organization_id;
1154:
1155: --Bug: 2805253 Modified the validation

Line 1222: from mtl_system_items_b

1218: l_source_subinv_error := FALSE;
1219: if ( cr.ORGANIZATION_ID <> cr.SOURCE_ORGANIZATION_ID ) then
1220: select restrict_subinventories_code
1221: into l_source_restrict_sub
1222: from mtl_system_items_b
1223: where organization_id = cr.SOURCE_ORGANIZATION_ID
1224: and inventory_item_id = cr.INVENTORY_ITEM_ID;
1225: else
1226: l_source_restrict_sub := nvl(cr.RESTRICT_SUBINVENTORIES_CODE, 2) ;