APPS.GMF_RCV_ACCOUNTING_PKG dependencies on MTL_SYSTEM_ITEMS

Line 875: FROM mtl_system_items msi

871: l_stmt_num := 30;
872:
873: SELECT COUNT (*)
874: INTO l_item_exists
875: FROM mtl_system_items msi
876: WHERE msi.inventory_item_id = p_rcv_accttxn.item_id
877: AND msi.organization_id = p_rcv_accttxn.organization_id;
878:
879: IF (l_item_exists = 0)

Line 904: FROM mtl_system_items msi, po_line_locations poll

900: l_stmt_num := 40;
901:
902: SELECT msi.inventory_asset_flag
903: INTO l_asset_flag
904: FROM mtl_system_items msi, po_line_locations poll
905: WHERE msi.inventory_item_id = p_rcv_accttxn.item_id
906: AND msi.organization_id = poll.ship_to_organization_id
907: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id;
908: EXCEPTION

Line 1596: FROM mtl_system_items

1592: l_stmt_num := 30;
1593:
1594: SELECT primary_uom_code
1595: INTO l_primary_uom_code
1596: FROM mtl_system_items
1597: WHERE organization_id = p_event_rec.organization_id
1598: AND inventory_item_id = l_item_id;
1599:
1600: l_stmt_num := 40;