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 319: FROM mtl_system_items_kfv

315: SELECT concatenated_segments,
316: serial_number_control_code
317: INTO l_item_name,
318: l_serial_code
319: FROM mtl_system_items_kfv
320: WHERE inventory_item_id = p_in_srv_pa_attr_rec.item_id
321: AND organization_id = p_in_srv_pa_attr_rec.inv_master_org_id;
322:
323: debug(' item : '||l_item_name);