APPS.RCV_SEEDEVENTS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1339: FROM mtl_system_items MSI

1335: -- Verify that item exists in organization where event is being created.
1336: l_stmt_num := 30;
1337: SELECT count(*)
1338: INTO l_item_exists
1339: FROM mtl_system_items MSI
1340: WHERE MSI.inventory_item_id = p_rcv_event.item_id
1341: AND MSI.organization_id = p_rcv_event.organization_id;
1342:
1343: IF(l_item_exists = 0) THEN

Line 1358: FROM mtl_system_items MSI,

1354: -- available for both Invoice Match and Receiving events.
1355: l_stmt_num := 40;
1356: SELECT MSI.inventory_asset_flag
1357: INTO l_asset_flag
1358: FROM mtl_system_items MSI,
1359: po_line_locations POLL
1360: WHERE MSI.inventory_item_id = p_rcv_event.item_id
1361: AND MSI.organization_id = POLL.ship_to_organization_id
1362: AND POLL.line_location_id = p_rcv_event.po_line_location_id;

Line 1988: FROM mtl_system_items

1984: ELSE
1985: l_stmt_num := 30;
1986: SELECT primary_uom_code
1987: INTO l_primary_uom_code
1988: FROM mtl_system_items
1989: WHERE organization_id = p_event_rec.organization_id
1990: AND inventory_item_id = l_item_id;
1991:
1992: l_stmt_num := 40;