DBA Data[Home] [Help]

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;