APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 116: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

112:
113: i PLS_INTEGER := 0;
114: l_org_id NUMBER;
115: l_incurred_by_org_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE;
116: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
117: l_user_id NUMBER DEFAULT FND_GLOBAL.USER_ID;
118: l_transaction_source PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE;
119: l_sysdate date:=sysdate;
120: l_ref_sufix NUMBER;

Line 313: FROM mtl_system_items_kfv

309: SELECT concatenated_segments,
310: serial_number_control_code
311: INTO l_item_name,
312: l_serial_code
313: FROM mtl_system_items_kfv
314: WHERE inventory_item_id = p_in_srv_pa_attr_rec.item_id
315: AND organization_id = p_in_srv_pa_attr_rec.inv_master_org_id;
316:
317: debug(' item : '||l_item_name);