APPS.EAM_ASSETATTR_GRP_PUB dependencies on MTL_SYSTEM_ITEMS
Line 621: MTL_SYSTEM_ITEMS_KFV
617: L_STATUS NUMBER;
618: BEGIN
619: SELECT count(*) INTO L_status
620: FROM 621: MTL_SYSTEM_ITEMS_KFV 622: WHERE
623: INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
624: AND
625: ORGANIZATION_ID = P_ORGANIZATION_ID
Line 648: from mtl_system_items
644: is
645: l_eam_item_type number;
646: begin
647: select eam_item_type into l_eam_item_type 648: from mtl_system_items 649: where inventory_item_id=p_inventory_item_id
650: and rownum=1;
651:
652: return l_eam_item_type;