865: l_stmt_num := 30;
866:
867: SELECT COUNT (*)
868: INTO l_item_exists
869: FROM mtl_system_items msi
870: WHERE msi.inventory_item_id = p_rcv_accttxn.item_id
871: AND msi.organization_id = p_rcv_accttxn.organization_id;
872:
873: IF (l_item_exists = 0)
894: l_stmt_num := 40;
895:
896: SELECT msi.inventory_asset_flag
897: INTO l_asset_flag
898: FROM mtl_system_items msi, po_line_locations poll
899: WHERE msi.inventory_item_id = p_rcv_accttxn.item_id
900: AND msi.organization_id = poll.ship_to_organization_id
901: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id;
902: EXCEPTION
1586: l_stmt_num := 30;
1587:
1588: SELECT primary_uom_code
1589: INTO l_primary_uom_code
1590: FROM mtl_system_items
1591: WHERE organization_id = p_event_rec.organization_id
1592: AND inventory_item_id = l_item_id;
1593:
1594: l_stmt_num := 40;