DBA Data[Home] [Help]

APPS.GME_ERES_PKG dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 213: FROM MTL_SYSTEM_ITEMS_B_KFV

209: P_INVENTORY_ITEM_ID NUMBER) RETURN VARCHAR2 IS
210: L_ITEM_NUMBER varchar2(240);
211: CURSOR GET_ITEM_NUM IS
212: SELECT CONCATENATED_SEGMENTS
213: FROM MTL_SYSTEM_ITEMS_B_KFV
214: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
215: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
216: BEGIN
217: OPEN GET_ITEM_NUM;