PACKAGE BODY: APPS.MRP_GET_PRODUCT_FAMILY_ID

Source

1 PACKAGE BODY MRP_GET_PRODUCT_FAMILY_ID   AS
2 /* $Header: MRPGPFIB.pls 115.0 2002/03/26 03:58:23 pkm ship        $  */
3 
4 FUNCTION p_family(ITEM_ID IN NUMBER,ORG_ID IN NUMBER) RETURN NUMBER IS
5 pfid      NUMBER;
6 BEGIN
7 
8 select product_family_item_id into pfid from mtl_system_items
9 where inventory_item_id = ITEM_ID and
10 organization_id = ORG_ID;
11 
12 return pfid;
13 
14 END;
15 END;