DBA Data[Home] [Help]

APPS.MRP_GET_PRODUCT_FAMILY_ID dependencies on MTL_SYSTEM_ITEMS

Line 8: select product_family_item_id into pfid from mtl_system_items

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;