APPS.RCV_SEEDEVENTS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1346: FROM mtl_system_items MSI

1342: -- Verify that item exists in organization where event is being created.
1343: l_stmt_num := 30;
1344: SELECT count(*)
1345: INTO l_item_exists
1346: FROM mtl_system_items MSI
1347: WHERE MSI.inventory_item_id = p_rcv_event.item_id
1348: AND MSI.organization_id = p_rcv_event.organization_id;
1349:
1350: IF(l_item_exists = 0) THEN

Line 1365: FROM mtl_system_items MSI,

1361: -- available for both Invoice Match and Receiving events.
1362: l_stmt_num := 40;
1363: SELECT MSI.inventory_asset_flag
1364: INTO l_asset_flag
1365: FROM mtl_system_items MSI,
1366: po_line_locations POLL
1367: WHERE MSI.inventory_item_id = p_rcv_event.item_id
1368: AND MSI.organization_id = POLL.ship_to_organization_id
1369: AND POLL.line_location_id = p_rcv_event.po_line_location_id;

Line 1995: FROM mtl_system_items

1991: ELSE
1992: l_stmt_num := 30;
1993: SELECT primary_uom_code
1994: INTO l_primary_uom_code
1995: FROM mtl_system_items
1996: WHERE organization_id = p_event_rec.organization_id
1997: AND inventory_item_id = l_item_id;
1998:
1999: l_stmt_num := 40;